Discussions
»
Product and Service Development
»
MetaStock
»
Copying from Excel and Pasting to MetaStock
Rank: Member
Groups: Registered, Registered Users
Joined: 11/10/2006(UTC)
Posts: 14
|
When copying a series of data from Excel and paste it in a new inner window in MetaStock; it does not display data as it should ie the data plotted reverse dates( the oldest data in the series is ploted as the last (newest) data on the chart. Any Ideas how to fix that?
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/14/2009(UTC)
Posts: 140
Location: Austria
|
What happens if you reverse it in excel - sort column in different direction - before you copy it to metastock?
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 11/10/2006(UTC)
Posts: 14
|
Thanks. That was a smart suggestion but still nothing changed.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/14/2009(UTC)
Posts: 140
Location: Austria
|
hm can it be something with different date-formats (dateformat in excel vs. dateformat in your systemsettings) ?
Try to change the dateformat in your excel column - or try to copy a dateseries from metastock to your excel and maybe you can see there which format should be used..
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
Copying from Excel and Pasting to MetaStock
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.
