I use fxcm’s Tradestation, Is there a way I can export just the close price and 200MVA of each currency to excel? Or is there somewhere else I can get the data from?
What it is I am trying to do is use this as a quick way to sort of the strong and weak using R. Krivo’s method as I can only have 20 pairs on my TS at the same time so the indictor doesn’t work and I am to lazy to do it manually
Hi MissPIPa,
If you change the Marketscope chart to table mode, it will display the close price and indicator information in table format which you can then export into excel. Right click on the chart and you will see ‘Export to Excel…’ as a menu option. At the top of the chart navigate to Chart > Chart Mode > Table. The chart will display the date, OHLC, and any indicator information you have added to the chart for each candlestick.
If you want something automated, then your best option may be to create a tool using one of our API options to pull the data API Trading - FXCM UK *Losses can exceed deposits.
Jason
If you’re good enough in excel, you can get the raw data OHLC from Dukascopy in one minute segments in CSV - You have to manipulate it to whatever timeframe you want from there with formulae tho’.
Hope that is of some use and I don’t know what pairs they actually do other than the majors, but no doubt you will fiind out ! 