Forex Tester Forum (Professional Training Software for Traders) Forum Index Forex Tester Forum (Professional Training Software for Traders)

Back to main site   Risk disclosure
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Importing Tick Data as M1 Data

 
Post new topic   Reply to topic    Forex Tester Forum (Professional Training Software for Traders) Forum Index -> Data sources
View previous topic :: View next topic  
Author Message
Tantalus



Joined: 23 Mar 2007
Posts: 300

PostPosted: Mon Jun 15, 2009 5:42 pm    Post subject: Importing Tick Data as M1 Data Reply with quote

Mike, perhaps you can help a little here.

I want to try out some ideas of working directly with tick data for strategy testing. I don't want FT to treat the tick data as tick data, though; I want it to treat is as if it was M1 data. Here is the reason.

I'd like to try some ideas of applying indicators and other analyses directly to the tick stream - there are some MT4 indicators available for this, and I have found the idea intriguing. Since FT prefers to work from M1 data (and create it's own synthetic tick data) this won't work... I thought I would try to take tick data and reformat it to look like M1 data. That way I could trade on the ticks directly, and have FT apply the indicators directly to that imported tick stream.

I know there are others who are working on creating tick data files directly from their own tick source, but in that case, FT would still convert those ticks to M1 (or higher) timeframe before allowing you to trade on it. I want to trade directly on the tick data, so I'm trying to trick FT into thinking that the tick data _is_ M1 data. I hope you follow me.

Here is what I tried:

1. I exported M1 data from MT4 as a .csv file.
2. I left the date, time and volume columns intact, but I copied and pasted my tick data in where the price columns are. I used the same numbers for the Open, High, Low and Close columns, effectively creating data wherein the Open High Low and Close for each bar are exactly the same. Bars like this occasionally occur in real data (usually at short timeframes) so I hoped that it would not cause a problem for FT.
3. I deleted any extra bars beyond what I had tick data for. Essentially I created a M1 .csv file but put in tick data where the M1 data had been. FT should have seen this as M1 data.
4. I imported this file into FT (v1) and the data was recognized as M1 data. The import went without any errors.

Now I ran into problems... First, FT would only display this data as D1 bars, no matter what timeframe I specified. Sometimes it would let me view the raw tick data as M1 (which is what I want), but if I viewed it in any other TF, it would default to D1 display, even though it said on screen that it was in a different timeframe.

Also, When I used the crosshair mode, it displayed only the horizontal line and not the vertical one. This was a consistent problem and occurred in both edit mode and testing mode.

Can you think of any reason off-hand why this method should have problems?

I will try to get some screen shots later and post them along with my pseudo-M1 data file (tick data as M1).

Any thoughts or suggestions would be appreciated..

B-

_________________
Tantalus Research - Developing 21st Century Trading Systems.
Back to top
View user's profile Send private message Visit poster's website
Tantalus



Joined: 23 Mar 2007
Posts: 300

PostPosted: Mon Jun 15, 2009 7:55 pm    Post subject: Reply with quote

AHA! I found the problem!

Excel (a Microsoft product) is screwing up my data by changing the format of the time of day data without asking my permission.

Original TOD:

03:04

After Excel changes it:

3:04

Dropping the leading zero is not acceptable to the FT data importer, but Excel does it automatically. I futzed around and figured out how to get Excel to leave the data in the original format (I'll share if anyone asks) so now I can pull in my tick data and work with it directly, as I intended.

Here's a screen shot of my tick data with some indicators applied... Fun!

B-



Image2.jpg
 Description:
 Filesize:  71.83 KB
 Viewed:  7276 Time(s)

Image2.jpg



_________________
Tantalus Research - Developing 21st Century Trading Systems.
Back to top
View user's profile Send private message Visit poster's website
ghamm



Joined: 11 Feb 2009
Posts: 37

PostPosted: Tue Jun 16, 2009 2:37 am    Post subject: Reply with quote

I too spend a lot of time building real time tick algorithms.
If Im understanding your problem.. Id just build my own Tick file, and copy it into the respective FT directory.. That way, you can Use native data , real ticks, or of course build interpolated data.

Gordon
Back to top
View user's profile Send private message
Tantalus



Joined: 23 Mar 2007
Posts: 300

PostPosted: Tue Jun 16, 2009 5:42 am    Post subject: Reply with quote

The problem with building a tick file (like FT uses for the ticks it generates) is that the only way you can analyze and trade with it is to let FT cast it into timeframes, which means you're trading with M1 and higher data. I want to work with the pure tick data.

I have the import issue figured out, now let's see if there's something useful I can do with it...

B-

_________________
Tantalus Research - Developing 21st Century Trading Systems.
Back to top
View user's profile Send private message Visit poster's website
ABC



Joined: 09 May 2009
Posts: 3

PostPosted: Tue Jun 16, 2009 10:58 am    Post subject: Reply with quote

Tantalus

where do you come from?I think you are very ingenious.I like you. Laughing


Last edited by ABC on Thu Jun 25, 2009 4:09 pm; edited 1 time in total
Back to top
View user's profile Send private message
ABC



Joined: 09 May 2009
Posts: 3

PostPosted: Tue Jun 16, 2009 11:25 am    Post subject: Reply with quote

Laughing

Last edited by ABC on Thu Jun 25, 2009 4:08 pm; edited 1 time in total
Back to top
View user's profile Send private message
Tantalus



Joined: 23 Mar 2007
Posts: 300

PostPosted: Tue Jun 16, 2009 12:56 pm    Post subject: Reply with quote

No problem! I'm just glad someone is listening to me babble!! Very Happy

B-

_________________
Tantalus Research - Developing 21st Century Trading Systems.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Forex Tester Forum (Professional Training Software for Traders) Forum Index -> Data sources All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group