Populate the current offers from TS into Excel using DDE

Strategies are published here.

Moderator: admin

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

Postby steveped » Fri Sep 21, 2018 9:47 am

Hi guys, what's the code for getting Rollover values? I mean, =TS2OFFERS|EUR_USD!??? Thanks
steveped
 
Posts: 15
Joined: Sun Oct 19, 2014 3:57 am

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

Postby Apprentice » Thu Sep 27, 2018 2:48 am

IntrS = core.host:findTable("offers"):find("Instrument", source:instrument()).IntrS;
IntrB = core.host:findTable("offers"):find("Instrument", source:instrument()).IntrB;
User avatar
Apprentice
FXCodeBase: Confirmed User
 
Posts: 20115
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia

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

Postby steveped » Fri Nov 16, 2018 1:35 pm

Unfortunately If I enter =TS2OFFERS|EUR_USD!IntrS or =TS2OFFERS|EUR_USD!IntrB I receive an errore message: #name? Any suggestions?
steveped
 
Posts: 15
Joined: Sun Oct 19, 2014 3:57 am

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

Postby Apprentice » Sat Nov 17, 2018 5:31 am

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;
User avatar
Apprentice
FXCodeBase: Confirmed User
 
Posts: 20115
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia

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

Postby SANTOSH » Sat Nov 24, 2018 11:25 pm

Hello Everyone ..

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

Regards,
Santosh.
SANTOSH
 
Posts: 39
Joined: Tue Apr 21, 2015 12:21 am


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

Postby SANTOSH » Sun Nov 25, 2018 8:51 am

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.
SANTOSH
 
Posts: 39
Joined: Tue Apr 21, 2015 12:21 am

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

Postby SANTOSH » Mon Nov 26, 2018 8:38 am

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 ?
SANTOSH
 
Posts: 39
Joined: Tue Apr 21, 2015 12:21 am

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

Postby Apprentice » Wed Nov 28, 2018 5:30 am

Sure.
Can you give me an actual example, so we can code this for you?
User avatar
Apprentice
FXCodeBase: Confirmed User
 
Posts: 20115
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia

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

Postby SANTOSH » Wed Nov 28, 2018 7:10 am

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.
SANTOSH
 
Posts: 39
Joined: Tue Apr 21, 2015 12:21 am

PreviousNext

Return to Custom Strategies

Who is online

Users browsing this forum: No registered users and 6 guests