logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Espartano  
#1 Posted : Monday, February 5, 2018 9:36:42 PM(UTC)
Espartano

Rank:: Newbie

Groups: Registered Users, Subscribers
Joined: 7/26/2016(UTC)
Posts: 5
Location: Rua Sao Vicente, 110/202

Was thanked: 1 time(s) in 1 post(s)

I assembled a CSV file with S&P500 Future 20 ticks chart data (copy/paste) but the Downloader Console (in MS XV) doesn't find my CSV file. I don't know what is the problem.

When I browse the Downloader Console to the data folder no files are shown.

My file is CSV format like below:

Date,Time,Open,High,Low,Close,Volume 10/11/2017,14:18,2580.75,2580.75,2580.5,2580.5,219 10/11/2017,14:18,2580.5,2580.5,2580.25,2580.5,122 10/11/2017,14:19,2580.5,2580.5,2580.25,2580.5,84 10/11/2017,14:19,2580.25,2580.5,2580.25,2580.5,201 10/11/2017,14:19,2580.5,2580.5,2580.5,2580.5,194 10/11/2017,14:19,2580.5,2580.75,2580.5,2580.75,132 10/11/2017,14:19,2580.5,2580.5,2580.5,2580.5,227 10/11/2017,14:19,2580.5,2580.5,2580.25,2580.5,248

MS Support  
#2 Posted : Monday, February 5, 2018 10:57:20 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: Espartano Go to Quoted Post

I assembled a CSV file with S&P500 Future 20 ticks chart data (copy/paste) but the Downloader Console (in MS XV) doesn't find my CSV file. I don't know what is the problem.

When I browse the Downloader Console to the data folder no files are shown.

My file is CSV format like below:

Date,Time,Open,High,Low,Close,Volume 10/11/2017,14:18,2580.75,2580.75,2580.5,2580.5,219 10/11/2017,14:18,2580.5,2580.5,2580.25,2580.5,122 10/11/2017,14:19,2580.5,2580.5,2580.25,2580.5,84 10/11/2017,14:19,2580.25,2580.5,2580.25,2580.5,201 10/11/2017,14:19,2580.5,2580.5,2580.5,2580.5,194 10/11/2017,14:19,2580.5,2580.75,2580.5,2580.75,132 10/11/2017,14:19,2580.5,2580.5,2580.5,2580.5,227 10/11/2017,14:19,2580.5,2580.5,2580.25,2580.5,248

The following format should work:

Code:
Date,Time,Close,Volume
10/11/2017,14:18:01,2580.75,219
10/11/2017,14:18:02,2580.5,122
10/11/2017,14:19:01,2580.5,84
10/11/2017,14:19:02,2580.25,201
10/11/2017,14:19:03,2580.5,194
10/11/2017,14:19:04,2580.75,132
10/11/2017,14:19:05,2580.5,227
10/11/2017,14:19:06,2580.5,248

Tick count is not required but I added on just as an example. The main issue is that a tick can only have a Close price, having an Open, High, Low defined prevents MetaStock from identifying the data as tick.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.