Thanks a lot for this very useful tool! I think the URL you are building in the macro is an old one.
Open an Account
Use Cases supported The following use cases are supported by this collection of spreadsheets. The data downloaded allows a complete analysis to be carried out on historical data, daily rates, hourly and minute rates.
Get real time rates in a stream every x Seconds. Get real time rates in a stream every time there is a new rate from the Rates Server. Display the latest rates. The data in the spreadsheet is updated every time there is a new rate from the Rates Server.
Get tick-by-tick rates for a specific day or across two days but is subjected to a maximum of 24 hours limit. Demo or Live Accounts The spreadsheets can be parameterized to connect to the demo servers or live servers of https: You can choose the appropriate URL depending on whether you are using a demo or live account.
API Live trading accounts: Password - Password for your live or demo account. Brand - Brand key. Cookies cannot be used to identify you personally.
To block, delete or manage cookies, please visit aboutcookies. Restricting cookies will prevent you benefiting from some of the functionality of our website.
How to Use This Tool Choose your primary account currency. Select the trade's currency pair from the list. Current exchange rates are shown. Choose the action the type of trade, buy or sell.
Type the number of units in the trade. Type a hypothetical closing rate for the currency pair for example, a future value you speculate the pair might reach. Alternatively, type the current rate into this field and then change the pre-filled value to a previous rate. Use the Calculate button.