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)
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
Habilidades y experiencia relevante
VBA/Databases
Htos propuestos
$180 USD - final delivery
Greeting,
I have understood your Excel Macro for building Market Profile graph task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Excel, Visual Basic
Proposed Milestones
$180 USD - Excel Macro