Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/18/2008(UTC)
Posts: 37
|
Hi, i know this is a already well explained subject over years but i need to convert in metastock the excell file at the following link: http://sdw.ecb.europa.eu/quickviewexport.do?SERIES_KEY=117.BSI.M.U2.N.U.L61.X.1.Z5.0000.Z01.E&type=xls
(upload new files does not work and i cannot attach any file) it has some problems: 1 date is in a version that i cannot change 2 date start from the last to the oldest and it needs to be inverted 3 then it need to be saved in a ascii txt file suitable to be red in downloader i ve tried so many times by myself without succes please could anyone help me ? and could show me the way to save as txt suitable for downloader?
many thanks
|
|
|
|
|
|
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: magiclaas  Hi, i know this is a already well explained subject over years but i need to convert in metastock the excell file at the following link: http://sdw.ecb.europa.eu/quickviewexport.do?SERIES_KEY=117.BSI.M.U2.N.U.L61.X.1.Z5.0000.Z01.E&type=xls
(upload new files does not work and i cannot attach any file) it has some problems: 1 date is in a version that i cannot change 2 date start from the last to the oldest and it needs to be inverted 3 then it need to be saved in a ascii txt file suitable to be red in downloader i ve tried so many times by myself without succes please could anyone help me ? and could show me the way to save as txt suitable for downloader?
many thanks
Hello, The main issue is with the Date Column. Changing the Ascending/Descending aspect is pretty easy, but that date format is probably not going to be very usable for most. Excel doesn't seem to be able to format that date differently, so unless you can find a converter to change that date to something else (like YYYY-MM-DD) you would probably have to manually change the dates to make it readable.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/18/2008(UTC)
Posts: 37
|
thank you.. please help me by click download from this link: https://gofile.io/?c=QrdQ5F it will dowload ecbM1 data in excell. i did it but the insuperable problem for me was to find a right csv setting in order to converti it in metastock data
please can anyone try to convert it for me and help me by tell me step by step the process? thank you
|
|
|
|
|
|
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: magiclaas thank you.. please help me by click download from this link: https://gofile.io/?c=QrdQ5F it will dowload ecbM1 data in excell. i did it but the insuperable problem for me was to find a right csv setting in order to converti it in metastock data
please can anyone try to convert it for me and help me by tell me step by step the process? thank you
Here is a modified version of the CSV file that should work - https://gofile.io/?c=OFT45B Keep in mind this basically took Finding and Replacing the years (Finding 2020, replacing with 2020- and so on) as well as finding and replacing the month (Finding Jan, replacing with 01-31 and so on). Probably could do with even less replacing by just doing Find Jan and replace with -01-31 and so on. Afterward opening in Excel and sorting the date column. Edited by user Monday, April 13, 2020 4:10:07 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/18/2008(UTC)
Posts: 37
|
it works,
thank you very much
|
|
|
|
|
|
| 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.
