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:04:25 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 open a MS formatted data file in the Power Console.  The data is weekly.  I get the following message: "Data Validation Failed - Invalid Weekly Timestamp".

How do I proceed?
 
TIA!
MS Support  
#2 Posted : Tuesday, February 7, 2017 10:26:10 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 52 times
Was thanked: 130 time(s) in 126 post(s)
Hi, If you would like to Copy/Paste some of the data into a post that might help us determine the issue. We might need to see all of the data for one security if this ends up being insufficient.
jm0849  
#3 Posted : Tuesday, February 7, 2017 10:56:16 PM(UTC)
jm0849

Rank: Member

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

Thanks: 5 times
Sorry - a definite newbie here - I will learn quickly, but... How do I add the files to the post?
MS Support  
#4 Posted : Tuesday, February 7, 2017 11:56:01 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 52 times
Was thanked: 130 time(s) in 126 post(s)
I would say just try and Copy and Paste some of the data for now vs. attaching the entire file. File uploads can be a bit tricky here, so most people actually link to a 3rd party site. You should be able to just highlight the first few rows (and header), press Ctrl-C to Copy, then open a new post here and press Ctrl-V to Paste it in.
thanks 1 user thanked MS Support for this useful post.
jm0849 on 2/9/2017(UTC)
jm0849  
#5 Posted : Thursday, February 9, 2017 7:19:49 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...
jm0849  
#6 Posted : Tuesday, March 14, 2017 4:58:47 PM(UTC)
jm0849

Rank: Member

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

Thanks: 5 times
Hi - I'm back... This is from a .csv file - Date 1Yr-Infl 1/22/1926 3.7 1/29/1926 3.7 2/5/1926 3.7 2/11/1926 3.72 2/19/1926 3.72 2/26/1926 3.72 3/5/1926 3.72 3/12/1926 3.04 3/19/1926 2.9 Thoughts? TIA !
MS Support  
#7 Posted : Tuesday, March 14, 2017 7:49:00 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 52 times
Was thanked: 130 time(s) in 126 post(s)
Hi, I think we would need to take a look at the entire CSV in retrospect. The formatting is not necessarily an issue (it does of course need to be comma delimited and have the right headers) but there could be an issue between a set of specific dates. I would make sure you have the latest build, 4257 (in Help > About MetaStock) as well. If you can link off the the txt file we can take a look at it, otherwise you can also contact support directly and have them take a look at it. Typically if there is a data validation issue, it will tell you about it when you add the CSV to a list. This would be stored inside a log file in C:\Users\(Windows.Username)\AppData\Local\Thomson Reuters\MetaStock\15.0\Logs\MetaStock If you were to try and look through this yourself I would recommend closing MetaStock, clearing the contents of the above ...\Logs\MetaStock folder, restart MetaStock and add the CSV to a new local list. Then close MetaStock and look near the end of the MSWinLog text file to see if it mentions a data-related problem.
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.