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!
|
|
|
|
|
|
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,
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.
|
|
|
|
|
|
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?
|
|
|
|
|
|
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)
|
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.
|
 1 user thanked MS Support for this useful post.
|
|
|
|
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...
|
|
|
|
|
|
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 !
|
|
|
|
|
|
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,
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 |
|
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.
