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

Discussion in 'Automated Trading' started by Nilats, Sep 28, 2015.

  1. Nilats

    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
     
  2. MattZ

    MattZ Sponsor

    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.
     
  3. Nilats

    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.
     
  4. MattZ

    MattZ Sponsor

    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.
     
  5. Nilats

    Nilats

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