R trader pro - how to track price change in excel?

[Nilats]

hi

I see that R trade pro allows to setup automated trading in Excel.

I think it's great, but I do not see a way to actually be able to implement a simple Buy order if my condition is met.

My condition is simple I need to send market order each time price of a ESZ15.CME for example changed 1 point up.

I have to be able to catch and save Price variable somewhere and then create a condition that actually takes that reference point then add 1 point to it then compares it with current price and if values match then sends a Market order.

Any idea how can I implement it? I don't see any examples online on how to work in excel with such situations.. It seems it would require more complex programming... anyone can tell how can it be simply done using Excel?

Thanks

 

[MattZ]

hi

I see that R trade pro allows to setup automated trading in Excel.

I think it's great, but I do not see a way to actually be able to implement a simple Buy order if my condition is met.

My condition is simple I need to send market order each time price of a ESZ15.CME for example changed 1 point up.

I have to be able to catch and save Price variable somewhere and then create a condition that actually takes that reference point then add 1 point to it then compares it with current price and if values match then sends a Market order.

Any idea how can I implement it? I don't see any examples online on how to work in excel with such situations.. It seems it would require more complex programming... anyone can tell how can it be simply done using Excel?

Thanks

We have made this Video a while back about the orders for R Traders using Excel.
I hope this helps:

Thanks,
Matt
Optimus Futures

There is a risk of loss in futures trading. Past performance is not indicative of future results.

 

[Nilats]

Good video, but it's just very simplistic example, not what i was asking about...

I searched the web and i think your video is the only source of spreadsheet R trading examples )))

There's no easy way of tracking price changes... and setting order conditions - it would require programming in VB.

 

[MattZ]

Good video, but it's just very simplistic example, not what i was asking about...

I searched the web and i think your video is the only source of spreadsheet R trading examples )))

There's no easy way of tracking price changes... and setting order conditions - it would require programming in VB.

Thanks! We find that most people use the most basic functions of platforms, so we do videos according to that. I would be more than happy to provide you with a 30 day demo to see if you can take it further.

Matt
Optimus Futures

There is a risk of loss in futures trading. Past performance is not indicative of future results.

 

[Nilats]

Thanks! We find that most people use the most basic functions of platforms, so we do videos according to that. I would be more than happy to provide you with a 30 day demo to see if you can take it further.

Matt
Optimus Futures

There is a risk of loss in futures trading. Past performance is not indicative of future results.

Thank, but I do development only and I think we already have accounts necessary.