Forums - TradersStudio Data Management

HOME FORUMS BROKERS SOFTWARE BOOKS CONTACT US

Your Account • Become a Member • Help • Search

	Forums ›› Tools of the Trade ›› Data Sets and Feeds ›› TradersStudio Data Management

dotdonk

Registered: Sep 2010
Posts: 6

09-21-11 06:37 AM

Hi guys,

I'm trying to add a new EURUSD ASCII Data Source from FXCM vendor.

The ASCII format in the .csv file looks like this:

, , , , , ,
28-11-2001,00:10:00,0.88480,0.88490,0.88480,0.88490,2
28-11-2001,00:11:00,0.88480,0.88490,0.88470,0.88470,6

When I go through the wizard in TradersStudio I select the following:

file format: [date/time],OPEN,HIGH,LOW,CLOSE,VOLUME
date format: DD_MM_CCYY
time format: HH_MM_SS

When I hit the FINISH button I get an error message:

"-->>>Error loading file EURUSD 1 minute.csv. Wrong time frame.<<<--"

Anyone who can help me out?

Thanks.

Edit/Delete • Quote • Complain

Murray Ruggiero
TradersStudio

Registered: May 2005
Posts: 1473

09-22-11 03:11 PM

Please post your sample data file , plus textinfo.txt. It could be a few issues, for example if you have 1 minute data but your missing many 3-4 minute segments that could create a problem. It also could be the empty ",,,,," on top of file.

__________________
Contributing Editor Futures Magazine and Vice President of Research and Development for TradersStudio.
Learn more about TradersStudio at www.TradersStudio.com
If you want to see what TradersStudio can do for you watch the video on our home page.
See a written overview at
TraderStudio Overview

Edit/Delete • Quote • Complain

dotdonk

Registered: Sep 2010
Posts: 6

09-22-11 04:52 PM

Hi Mr. Ruggiero,
The empty ",,,,," on top of file is done by some char filtration on the elitetrader.com website. You can see the original data format in the attached .csv file.
Anyway - I ran a VBA script I created on a sample of the 1 min. EURUSD data in the .csv file. I formated the date and time. But without any luck.

Original: 28-03-2005,09:54:00,
Formated: 03/28/2005,095400,

As you can see there is a Volume field as the last field in a row. I don't know why, because there is no volume in FX.

But you apparently inspired me somehow!
I deleted the top row in the .csv file and wolla! It's working like a charm...
Thanks.

BTW. I uploaded the .csv file so you can see the format.

eurusd(1min)_data_sample_fxcm.zip
This has been downloaded 30 time(s).

Edit/Delete • Quote • Complain

Receive an email whenever a new post is added to this thread by subscribing to it.

Rate This Thread:

Forum Jump:

Conduct Rules - Privacy Policy - Day Trader - Day Trader Forum - Best Trading Software - Sitemap

WHILE YOU'RE HERE, TAKE A MINUTE TO VISIT SOME OF OUR SPONSORS:
Advantage Futures Futures Brokerage & Clearing AMP Global Clearing Futures and FX Trading Bright Trading Professional Equities Trading CTS Futures Trading Software DaytradingBias.com Professional Trading Analytics ECHOtrade Professional Trading Firm	eSignal Trading Software Provider FXCM Forex Trading Services Global Futures Futures, Options & FX Trading Interactive Brokers Pro Gateway to World Markets JC Trading Group Direct Access Trading MB Trading Direct Access Trading	MultiCharts Trading Software Provider NinjaTrader Trading Software Provider OANDA Currency Trading optionshouse Option Trading & Education Questrade Canada's #1 Online Broker Rithmic Futures Trade Execution Platform	SpeedTrader Direct Access Trading SpreadProfessor Spread Trading Instruction thinkorswim by TD Ameritrade Direct Access Trading TradersStudio System Building & Backtesting Trading Technologies Trading Software Provider Trend Following Trading Systems Provider