WL7 can not read Data if Dataset have different format.
For ecample:
My provider have data with open high low close the past 10 years, before only the close price.
WL7 can not read this and displayed (can not optain data).
Same problem in metastock and ASCII.
This was no problem in WL6.
What can i do?
For ecample:
My provider have data with open high low close the past 10 years, before only the close price.
WL7 can not read this and displayed (can not optain data).
Same problem in metastock and ASCII.
This was no problem in WL6.
What can i do?
Rename
It looks like you'd better do something with data rather than with WL7.
I would suggest some kind of yeasy Python script. To convert data to the same format:
- add OHL equal to C where you have only C.
or
- delete OHL where you have OHLC.
It's pretty easy with python and pandas.
I would suggest some kind of yeasy Python script. To convert data to the same format:
- add OHL equal to C where you have only C.
or
- delete OHL where you have OHLC.
It's pretty easy with python and pandas.
Thomas, two points as I worked with your data files already.
1. I've fixed the Metastock provider so it will import your data file from Build 4. Problem was, the symbol name in Metastock file itself is incorrect / unexpected.
2. As for the ASCII data, WL6 would not import your misformatted file either. Good code should not be making assumptions in case there's a sudden format change in the middle of the file. Like it is with your file which is Close-only prior to a date in 1997 and then the data becomes OHLC.
As Michael correctly suggests you're better off "massaging" the data file prior to working with it. Excel or Notepad++ should get the job done.
1. I've fixed the Metastock provider so it will import your data file from Build 4. Problem was, the symbol name in Metastock file itself is incorrect / unexpected.
2. As for the ASCII data, WL6 would not import your misformatted file either. Good code should not be making assumptions in case there's a sudden format change in the middle of the file. Like it is with your file which is Close-only prior to a date in 1997 and then the data becomes OHLC.
As Michael correctly suggests you're better off "massaging" the data file prior to working with it. Excel or Notepad++ should get the job done.
Your Response
Post
Edit Post
Login is required