Hi all,
I've been searching for ways to setup an excel spreadsheet to contain live forex data. It's easy to export historical data to excel, but as for live data that will automatically update...seems harder.
The type of information I want would include high, low, close, & open, for a given time period (intraday, not just longer timeframes). For example, I've got a demo account with FXCM and it displays this information perfectly in table format, but no luck taking it to excel in a live way.
Also, let's say for example this was in reference to a 1 hour chart, for 200 periods. The period furtherest back in time (the 1st) will get deleted when a new period is put on (the newest 200th).
Any suggestions would be greatly appreciated, thanks.
I've been searching for ways to setup an excel spreadsheet to contain live forex data. It's easy to export historical data to excel, but as for live data that will automatically update...seems harder.
The type of information I want would include high, low, close, & open, for a given time period (intraday, not just longer timeframes). For example, I've got a demo account with FXCM and it displays this information perfectly in table format, but no luck taking it to excel in a live way.
Also, let's say for example this was in reference to a 1 hour chart, for 200 periods. The period furtherest back in time (the 1st) will get deleted when a new period is put on (the newest 200th).
Any suggestions would be greatly appreciated, thanks.
Aucun commentaire:
Enregistrer un commentaire