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

Notification

Icon
Error
Can't download CSV data - CSV files not adding to offline instruments
Options
Go to last post Go to first unread
Previous Topic Next Topic
jm0849  
#1 Posted : Tuesday, February 7, 2017 4:13:28 PM(UTC)
jm0849

Rank: Member

Groups ready for retrieval: 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!
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
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: 2,002

Thanks: 98 times
Was thanked: 161 time(s) in 156 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.
Back to top
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 ready for retrieval: 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...)
Back to top
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: 2,002

Thanks: 98 times
Was thanked: 161 time(s) in 156 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
Back to top
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 ready for retrieval: 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...
Back to top
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
Back to top
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?
Back to top
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: 2,002

Thanks: 98 times
Was thanked: 161 time(s) in 156 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.
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2026, Yet Another Forum.NET