:: Subscribe to our newsletter
Articles / Directory
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.

Latest version of NeuralCode(v1.3) for
Neural Networks Trading.

ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.

InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.

Launch of
Free Investment and Financial Calculator for Excel.

Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines

ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel

Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.

Get real time rates in a stream every x Seconds

The ForexTechnicalAnalysis-RealTimeRates-Periodic.xls spreadsheet periodically calls the API Server at a frequency specified by the field as shown below.
  • Frequency of Rates in Seconds*
If a number 15 is specified for the above field, the API server will be called to retrieve rates data every 15 seconds.

The output of the data is placed in the Rates worksheet as shown in the diagram below. The data is in the format Date, Time, Bid, Ask. All the different currencies downloaded and placed alongside each other as shown in the diagram. For example, after the EUR/USD currency pair, the GBP/AUD currency pair rates are placed in a similar Date, Time, Bid, Ask format.

Internally the spreadsheet uses a timer to periodically call the API server. The GetRatesDataSet web service is called for this purpose. It is important to click on the Stop button to stop the timer when rates are no longer required at the specified frequency.

Back to FOREX Technical Analysis Software.

Back to Technical Analysis Software


Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.

Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners