Đã Đóng

Excel Macro for building Market Profile graph

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)

Kỹ năng: Excel, Visual Basic

Xem thêm: market profile graph excel, market profile excel spreadsheet, market profile macro excel, macro excel market profile, building market profile, building market profile excel, draw market profile excel, excel macro referring spreadsheet, excel macro graph csv, excel macro locks spreadsheet, excel macro color graph, excel macro developer profile, excel macro cut paste spreadsheet, excel macro script insert data spreadsheet, refresh spreadsheet view excel macro

Về Bên Thuê:
( 0 nhận xét ) Hong Kong

Mã Dự Án: #15435415

12 freelancer đang chào giá trung bình $170 cho công việc này

$200 USD trong 1 ngày
(254 Đánh Giá)
7.6
elqueabandona

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 Thêm

$180 USD trong 4 ngày
(176 Đánh Giá)
6.7
$110 USD trong 3 ngày
(114 Đánh Giá)
5.7
zu02

Hi there, I can code this your Excel. Relevant Skills and Experience Excel, vba Proposed Milestones $250 USD - default

$250 USD trong 4 ngày
(27 Đánh Giá)
5.6
AndrejStastny

Great VBA Developer! Look at my reviews pls. Relevant Skills and Experience VBA VB Excel Proposed Milestones $100 USD - Demo $177 USD - Final

$277 USD trong 5 ngày
(15 Đánh Giá)
4.2
whitehorsetechn

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 y Thêm

$180 USD trong 3 ngày
(3 Đánh Giá)
3.0
bondilimahesh

I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time.

$111 USD trong 3 ngày
(2 Đánh Giá)
2.4
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now. Relevant Skills and Experience Excel VBA Proposed Milestones $111 USD - 1

$111 USD trong 3 ngày
(1 Đánh Giá)
1.4
ardenraman

--Very Nice Job. Professional Math & Excel & Visual Basic & VBA & Machine Learning expert. Best result in time----- Relevant Skills and Experience I have high skills and many experiences for the fields such as Math & Thêm

$30 USD trong 3 ngày
(0 Đánh Giá)
0.0
xlbymalix

VBA Professional Relevant Skills and Experience l VBA Professional Proposed Milestones $155 USD - Total

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0
$277 USD trong 5 ngày
(0 Đánh Giá)
0.0
AnujDangaich2512

Hi, I would like to complete your project Relevant Skills and Experience Excel / Macro Proposed Milestones $155 USD - Completion

$155 USD trong 10 ngày
(0 Đánh Giá)
0.0