FXCM historical data has DST offset in raw "UTC" data - Reviews of Brokers and Data Feeds | futures io social day trading
futures io futures trading

FXCM historical data has DST offset in raw "UTC" data
Updated: Views / Replies:1,122 / 2
Created: by noetus Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 100,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Thread Tools Search this Thread

FXCM historical data has DST offset in raw "UTC" data

  #1 (permalink)
Aix-en-Provence, France
Posts: 5 since May 2013
Thanks: 0 given, 0 received

FXCM historical data has DST offset in raw "UTC" data

I have been using FXCM's "Historical Data Downloader" software to download historical forex data on 20 different currency pairs (data from late 2001 through to the present). Backtesting on at least 10 years of data is vital to my trading strategy. The retail cost of this software is $500.

I downloaded minute data; the software claims the data has UTC timestamps and you can choose the offset from UTC when you download it. Stating that the data is UTC timestamped means the data should have NO DST offsets in it. Whatever charting software you use would then apply DST offsets depending on what timezone you happen to be in; Ninjatrader for example (what I use) uses the computer clock (i.e. local time) to calculate and apply timestamps to chart candles (and Ninjatrader's data importer asks for the data to be UTC, i.e. with no DST offsets).

I have analysed their data and I have come to the rather shocking conclusion that the data from 2001 through to 9 March 2008 has a DST offset in it, with the offset boundaries corresponding to the dates of DST in the New York (Eastern) timezone. From spring 2008 onwards to the present the data has no DST offset in it. Furthermore, the data from 2001 to 9 March 2008 uses EDT (i.e., summer time) as the reference for calculating the UTC offset when you select that using their Historical Data Downloader. In other words, it is not that during the summer there is an offset of +1 hour applied to all the data. Rather it is that during the winter there is a -1 hour offset applied to all the data.

Given that this is a retail product I am really shocked. It matters a lot to people like me whose trading strategies depend on accurate absolute timestamps. It now seems that all my backtesting is invalid. I have to correct their data (I guess I will have to write a script to change the timestamps in their raw data) and run my backtests again (months of work).

Have I stumbled upon a well-known fact about FXCM's data? Do I have the basis of a complaint against them?

If anyone is interested, I can supply the steps of my analysis that demonstrate that their data contains DST offsets during the time period I mentioned (although my analysis could only be verified by someone with access to the same data I have).

Reply With Quote
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

  #3 (permalink)
Market Wizard
Los Angeles, California Republic
Trading Experience: None
Platform: Sierra Chart
Broker/Data: CQG
Favorite Futures: ES
srgtroy's Avatar
Posts: 1,731 since Jan 2011
Thanks: 1,124 given, 2,897 received

I would be interested to know what their response is. Please keep us informed.

Reply With Quote


futures io > > > > FXCM historical data has DST offset in raw "UTC" data

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

futures io is celebrating 10-years w/ over $18,000 in prizes!

Right now

$250 Amazon Gift Cards with our "Thanks Contest" challenge!

Right now

The Best of Both Worlds: Automated & Discretionary Trading w/SharkIndicators

Jan 23

Similar Threads
Thread Thread Starter Forum Replies Last Post
Does Elite circle "QCollector tick data sharing thread" contain latest 2015 data? ayteck Traders Hideout 8 December 19th, 2017 02:47 PM
Big S&P (SP) "Pit" Historical Data OZTrade Reviews of Brokers and Data Feeds 5 May 20th, 2015 04:10 PM
Ninja7 "reload Historical data"grayed out traderTX NinjaTrader 4 April 6th, 2014 02:07 PM
Loading historical data via "Restore" jnorris Elite Automated NinjaTrader Trading 5 October 28th, 2013 12:00 AM
Is it possible to get "historical" Time and Sales data? adaseb Reviews of Brokers and Data Feeds 2 September 8th, 2010 12:18 PM

All times are GMT -4. The time now is 04:51 AM. (this page content is cached, log in for real-time version)

Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts