ddrrbb wrote:Is it possible to load historical prices into excel with this strategy? Right now, I manually load prices into excel at the end of the day.
This sample will write "yyyy-m-d.csv" file into the TS folder daily (not DDE is needed).
Moderator: admin
ddrrbb wrote:Is it possible to load historical prices into excel with this strategy? Right now, I manually load prices into excel at the end of the day.
To put data via DDE in excel, all you need is to enter the following formula into the excel cell:
=A|B!C
where
A is a service name
B is a topic
and
C is a value.
topic.bid = dde_server:addValue(topic.id, "Bid");
topic.ask = dde_server:addValue(topic.id, "Ask");
topic.high = dde_server:addValue(topic.id, "High");
topic.low = dde_server:addValue(topic.id, "Low");
topic.pipcost = dde_server:addValue(topic.id, "PipCost");
topic.time = dde_server:addValue(topic.id, "Time");
-- topic.mmr = dde_server:addValue(topic.id, "MMR");
Users browsing this forum: No registered users and 100 guests