Hi Everyone,
I have set up a list of symbols in QuoteManager, all with daily trade OHLC.
I would like to add further daily trade OHLC data from a single .csv file, the format is as follow:
ticker,date,open.high,low,close,volume
AAAP,2015/11/09,16,16,16,16,100
AAAP,2015/11/10,16,16,16,16,100
AAAU,2018/08/13,11.74,11.74,11.74,11.74,100
AAAU,2018/08/14,11.74,11.74,11.74,11.74,100
...
What is the best way to go about it?
QuoteManager Data Import [SOLVED]
Re: QuoteManager Data Import
I now have a list of .txt files:
AAAP.txt
AAAU.txt
...
with daily trade OHLCV in them:
2015/11/09,16,16,16,16,100
2015/11/10,16,16,16,16,100
...
The filename match the symbol in QuoteManager. Any idea how I could batch import all the data? There are over 1,000 files...
AAAP.txt
AAAU.txt
...
with daily trade OHLCV in them:
2015/11/09,16,16,16,16,100
2015/11/10,16,16,16,16,100
...
The filename match the symbol in QuoteManager. Any idea how I could batch import all the data? There are over 1,000 files...
Re: QuoteManager Data Import
Attached is how the text files look, and then how QuoteManager interpret them.
I am at loss at what to do here, never imagined such a basic operation would generate so many issues.
I am at loss at what to do here, never imagined such a basic operation would generate so many issues.
- Attachments
-
- mc2.png
- quotemanager
- (29.48 KiB) Not downloaded yet
-
- mc1.png
- notepad
- (18.77 KiB) Not downloaded yet
Re: QuoteManager Data Import
Hi duration,
I am new here, but i could work recently with ASCII mapping following this link:
https://www.youtube.com/watch?v=lAqDk2pdkKg
My data are formatted this way:
ASCII File with csv extension.
Column names: Date, Open, High, Low, Close, Volume
Date format example: 2006-01-01: YYYY-MM-DD
Decimal separator = "."
CSV separator = ","
It seems that Multicharts have a restriction with the volume data, so I have to divide all my data volume by 1000, in order those number were less bigger.
Best regards,
Nicolás
I am new here, but i could work recently with ASCII mapping following this link:
https://www.youtube.com/watch?v=lAqDk2pdkKg
My data are formatted this way:
ASCII File with csv extension.
Column names: Date, Open, High, Low, Close, Volume
Date format example: 2006-01-01: YYYY-MM-DD
Decimal separator = "."
CSV separator = ","
It seems that Multicharts have a restriction with the volume data, so I have to divide all my data volume by 1000, in order those number were less bigger.
Best regards,
Nicolás
Re: QuoteManager Data Import [SOLVED]
Thanks Nicolás.
MC Support Vlada came back to me and explained that my files were corrupted.
I re-exported the files with another method specifying the encoding and the corruption problem is gone.
MC Support Vlada came back to me and explained that my files were corrupted.
I re-exported the files with another method specifying the encoding and the corruption problem is gone.