Excel Macro for building Market Profile graph

Cancelled

Excel spreadsheet (Excel 2003) with macro that builds Market Profile Graph for a security as described in PDF file enclosed, an example in XLS file enclosed.

First sheet will contain the data input from DDE.

Second sheet will contain the configuration parameters:

- TPO height

- TPO timeframe

- profile timeframe

- volume x TPO

- destination folder/file for saving

Third sheet will contain database of the data input as 5-min average of data input from DDE per row, the sheet must be filled bottom up with the latest value on top

Fourth sheet will contain 5 profile graph with price TPO on the right and volume, relative to same TPO, on the left. Each cell should be colored accordingly with the correspondent letter inside, the graph in the columns at the center must also show:

- Open

- Value area

- Close

- Latest price

- POC

- Initial Balance

The macro will run on a file (excel 2003) which every 5 minutes autosaves and the macro saves automatically the whole working file in a second file (excel 2003)

Skills: Excel, Visual Basic

See more: market profile excel, excel market profile, market profile excel sheet, market data xls, excel macro market, market profile excel file, market profile xls, market profile value area excel, market profile excel xls, market profile excel spreadsheet, volume profile excel, market profile tpo excel, excel market profile volume, market profile poc spreadsheet, market profile, market profile spreadsheet, market profile graph excel, top graph, the graph, poc database, in a graph, graph top, graph the data, graph of data, graph in c

Project ID: #1567578

6 freelancers are bidding on average $187 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD in 5 days
(64 Reviews)
6.5
Krusche

Excel experts here. Please check our reviews and examples in your PMB

$240 USD in 2 days
(29 Reviews)
5.6
skctechno

I am serious on this project and having 9 years of professional experience. My bid cost is minimum. Let me know If I can proceed on your task. -Thanks and Regards

$100 USD in 4 days
(20 Reviews)
5.2
ethicalboy

Please see what I said.

$150 USD in 5 days
(23 Reviews)
4.4
ochristo

I'm a programmer with 5 years of financial industry experience. I use VBA every day to do financial analysis like this. Will deliver quality results on time.

$200 USD in 5 days
(7 Reviews)
2.9
cemetman

Dear Sir; I assure you that I can easily meet most of the mentioned requirements. I have 15 years VB and Excel Macro experience. Just give me a chance to fulfill your satisfaction. I can do your job according to your More

$180 USD in 5 days
(0 Reviews)
0.0