Page 3 of 5

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Fri Sep 21, 2018 9:47 am
by steveped
Hi guys, what's the code for getting Rollover values? I mean, =TS2OFFERS|EUR_USD!??? Thanks

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Thu Sep 27, 2018 2:48 am
by Apprentice
IntrS = core.host:findTable("offers"):find("Instrument", source:instrument()).IntrS;
IntrB = core.host:findTable("offers"):find("Instrument", source:instrument()).IntrB;

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Fri Nov 16, 2018 1:35 pm
by steveped
Unfortunately If I enter =TS2OFFERS|EUR_USD!IntrS or =TS2OFFERS|EUR_USD!IntrB I receive an errore message: #name? Any suggestions?

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Sat Nov 17, 2018 5:31 am
by Apprentice
Try this version.
local InstrumentName="EUR/USD"
IntrS = core.host:findTable("offers"):find("Instrument", InstrumentName).IntrS;
IntrB = core.host:findTable("offers"):find("Instrument", InstrumentName).IntrB;

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Sat Nov 24, 2018 11:25 pm
by SANTOSH
Hello Everyone ..

Is there a way to export Live trade-station strategy alerts to excel ?

Regards,
Santosh.

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Sun Nov 25, 2018 5:46 am
by Apprentice

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Sun Nov 25, 2018 8:51 am
by SANTOSH
Ya ,
But this is data recording for the indicators to excel .
Can we export Live text alerts from a strategy.lua file which is running in tradestation ?

Regards,
Santosh.

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Mon Nov 26, 2018 8:38 am
by SANTOSH
Hello Everyone ,
Awaiting reply ,
Because i am to trying export all live tradestation alerts of the strategy that i have made to excel .

Is there anyone who can help me in this task ?

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Wed Nov 28, 2018 5:30 am
by Apprentice
Sure.
Can you give me an actual example, so we can code this for you?

Re: Populate the current offers from TS into Excel using DDE

PostPosted: Wed Nov 28, 2018 7:10 am
by SANTOSH
Sure ,
Just an example below .
Suppose have a reverse div strategy with following code :

terminal:alertMessage(instance.ask:instrument(), instance.ask[NOW], "|BUY| reverse divergence |"..curr-prev,instance.ask:date(NOW));

Now , the text alert which comes in trade station , that needs to live exported to excel .

In simpler terms , just want to export tradestation live strategy alerts to excel .

Hope its clear now ?

Regards ,
SANTOSH.