can i add a line of data from excel?

Questions about MultiCharts and user contributed studies.
User avatar
rokanten
Posts: 48
Joined: 29 Jul 2010
Location: south korea
Has thanked: 15 times

can i add a line of data from excel?

Postby rokanten » 21 Jun 2019

hi

i've saved daily endofday data into my own created symbols.
and the data comes from my broker into excel sheet.

what i do is (example)
1. choose symbol ES on QM
2. edit data
3. load-add
4. then paste a1 cell data to open, b1 cell data to high.. and so on
(daily EOD is saved on my excel sheet, OHLC volume OI, from A1 cell to F1,
and for second symbol, its from A2 to F2.. and so on)

i am doing this with autohotkey, because i trade 25 instruments which makes above job real exhausting.
can i do this with excel DDE or VBA or something else which is supported by multicharts?

getting whole data series from broker or other data vender is also possible and i know how to do it,
but i prefer to keep my own created symbols, because of some not so superbig problems.

thanks.

User avatar
Anna MultiCharts
Posts: 560
Joined: 14 Jul 2017
Has thanked: 42 times
Been thanked: 140 times

Re: can i add a line of data from excel?

Postby Anna MultiCharts » 24 Jun 2019

Hello, rokanten!

If your excel file is constantly updating with data, then you might find the ASCII Mapping feature useful:
https://www.multicharts.com/trading-sof ... ping_ASCII
Have you tried/considered this option?


Return to “MultiCharts”