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

Notification

Icon
Error

Options
Go to last post Go to first unread
jm0849  
#1 Posted : Tuesday, February 7, 2017 4:13:28 PM(UTC)
jm0849

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 11/29/2016(UTC)
Posts: 10

Thanks: 5 times

I am trying to add CSV offline data to the offline instruments through the Power Console.  When I browse to the data folder no files are shown.

I have checked the data file.  It has headers.

What do I need to do?

 TIA!

MS Support  
#2 Posted : Tuesday, February 7, 2017 10:23:30 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
Hi, The individual files will not show in the Add Folder dialogue. Basically once you are pointing at the proper folder, simply click the "Select Folder" button. However, if after doing this no securities show up in your list, then we would probably need to take a look at one of them to see what might be happening. Copy/pasting the header and a few lines of data should hopefully give us an idea where the process is failing.
thanks 1 user thanked MS Support for this useful post.
jm0849 on 2/7/2017(UTC)
jm0849  
#3 Posted : Tuesday, February 7, 2017 10:53:05 PM(UTC)
jm0849

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 11/29/2016(UTC)
Posts: 10

Thanks: 5 times
"Select Folders" is greyed out. (Sorry - forgot to mention that - that's the rub after all...)
MS Support  
#4 Posted : Tuesday, February 7, 2017 11:58:37 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
Hi, are you certain you are not referring to the "Select All" button? Either way if you are on the dialogue I think you're on, the symbols should be showing up. If they are not, the problem is more than likely related to the data formatting. As per your other post, if you want to try and Copy/Paste some of the data we might be able to see very quickly where the process is failing. For example: <date>,<ticker>,<per>,<open>,<high>,<low>,<volume>,<close> 2/1/2017,IBM,D,48.93,49.810001,48.68,22446,49.259998 2/2/2017,IBM,D,48.880001,49.00,48.470001,13522,48.900002
thanks 1 user thanked MS Support for this useful post.
jm0849 on 2/9/2017(UTC)
jm0849  
#5 Posted : Thursday, February 9, 2017 7:20:40 PM(UTC)
jm0849

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 11/29/2016(UTC)
Posts: 10

Thanks: 5 times
I am going to go back and look at my data - there may be something wrong there. Thanks so much... I may be back...
Guest  
#6 Posted : Sunday, December 24, 2017 7:38:08 AM(UTC)
Guest

Rank: Member

Groups: Guests
Joined: 5/6/2007(UTC)
Posts: 25

I seem to be having the same issue - my Downloader doesn't recognise my CSV files... The data is as follows: ANR,20171222,1.705,1.705,1.7,1.7,28020 ANS,20171222,0.007,0.007,0.007,0.007,0 ANW,20171222,0.013,0.013,0.012,0.012,7098823 ANZ,20171222,28.99,29.005,28.86,28.87,6069350 Any thoughts? Thanks
dominicowens  
#7 Posted : Thursday, December 28, 2017 5:20:14 PM(UTC)
dominicowens

Rank: Newbie

Groups: Subscribers, Unverified Users
Joined: 9/28/2017(UTC)
Posts: 4
Location: London

Thanks: 1 times
How you found out that it doesn't recognise the CSV files?
MS Support  
#8 Posted : Tuesday, January 2, 2018 5:18:32 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)

Originally Posted by: Guest Go to Quoted Post
I seem to be having the same issue - my Downloader doesn't recognise my CSV files... The data is as follows: ANR,20171222,1.705,1.705,1.7,1.7,28020 ANS,20171222,0.007,0.007,0.007,0.007,0 ANW,20171222,0.013,0.013,0.012,0.012,7098823 ANZ,20171222,28.99,29.005,28.86,28.87,6069350 Any thoughts? Thanks

Hi,

We added a note for this in DownLoader 15 (we need to add a note to the MetaStock Help file as well) but basically, if you are converting multiple instruments within a single CSV file, you must also specify <PER> (Periodicity) Column. If the data is all Daily, you would just put a D for this value.

I can't determine if you already have a header within your CSV data, but this is required for DownLoader to recognize the data.

Users browsing this topic
Guest (Hidden)
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.