QuoteManager Data Import  [SOLVED]

Questions about MultiCharts and user contributed studies.
duration
Posts: 179
Joined: 20 Dec 2005
Been thanked: 1 time

QuoteManager Data Import

Postby duration » 09 Jun 2020

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?

duration
Posts: 179
Joined: 20 Dec 2005
Been thanked: 1 time

Re: QuoteManager Data Import

Postby duration » 11 Jun 2020

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...

duration
Posts: 179
Joined: 20 Dec 2005
Been thanked: 1 time

Re: QuoteManager Data Import

Postby duration » 13 Jun 2020

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.
Attachments
mc2.png
quotemanager
(29.48 KiB) Not downloaded yet
mc1.png
notepad
(18.77 KiB) Not downloaded yet

naguilag
Posts: 7
Joined: 09 Apr 2020
Has thanked: 4 times

Re: QuoteManager Data Import

Postby naguilag » 16 Jun 2020

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

duration
Posts: 179
Joined: 20 Dec 2005
Been thanked: 1 time

Re: QuoteManager Data Import  [SOLVED]

Postby duration » 17 Jun 2020

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.


Return to “MultiCharts”