adding new data line from excel

Questions about MultiCharts and user contributed studies.
User avatar
rokanten
Posts: 48
Joined: 29 Jul 2010
Location: south korea
Has thanked: 15 times

adding new data line from excel

Postby rokanten » 12 Apr 2015

Hi.

I am trying to add a new data line of O,H,L,C daily.
How i am doing it now, is like this..
1. download data of O,H,L,C from yahoo to excel
2. go to symbol -> edit data -> add -> manually inputting data

I tried 'copy-paste', but this also is not convenient.
Is there any more convinient way to do this?
thanks in advance.

Regards.

User avatar
TJ
Posts: 7740
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1033 times
Been thanked: 2221 times

Re: adding new data line from excel

Postby TJ » 12 Apr 2015

Hi.

I am trying to add a new data line of O,H,L,C daily.
How i am doing it now, is like this..
1. download data of O,H,L,C from yahoo to excel
2. go to symbol -> edit data -> add -> manually inputting data

I tried 'copy-paste', but this also is not convenient.
Is there any more convinient way to do this?
thanks in advance.

Regards.
Is this a one time edit?
or are you planning to do this on a daily basis?

User avatar
rokanten
Posts: 48
Joined: 29 Jul 2010
Location: south korea
Has thanked: 15 times

Re: adding new data line from excel

Postby rokanten » 12 Apr 2015

yes, it's daily work for about 30symbols.

User avatar
JoshM
Posts: 2195
Joined: 20 May 2011
Location: The Netherlands
Has thanked: 1544 times
Been thanked: 1565 times
Contact:

Re: adding new data line from excel

Postby JoshM » 13 Apr 2015

I am trying to add a new data line of O,H,L,C daily.
How i am doing it now, is like this..
1. download data of O,H,L,C from yahoo to excel
2. go to symbol -> edit data -> add -> manually inputting data

I tried 'copy-paste', but this also is not convenient.
Is there any more convinient way to do this?
thanks in advance.
Have you tried using the FreeQuotes connection? That connection can download data from Yahoo directly.

User avatar
rokanten
Posts: 48
Joined: 29 Jul 2010
Location: south korea
Has thanked: 15 times

Re: adding new data line from excel

Postby rokanten » 29 Apr 2015

thanks for introducing freequotes to me.
but that's not for me, because some of data's from yahoo, and some from my broker.
and data from my broker(i'm korean) is not supported by MC,
so I'm trying to put data through excel.

is there any other way for me?
(adding data from excel directly)
thanks for your reply, and hope I could get more from you.

Best regards.

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: adding new data line from excel

Postby Henry MultiСharts » 01 May 2015

Hello rokanten,

You can use ASCII mapping functionality. It creates a link from the software to the ASCII file with data. ASCII mapping does not import data into MultiCharts database (Edit data window of QuoteManager will be empty). Each time you plot an ASCII mapping symbol-the data is taken from the file directly. That is possible to map multiple ASCII files at the same time. You do not need to create ASCII mapping instrument manually-it is created automatically upon mapping.
For more information please see our Wiki section: Mapping_ASCII.


Return to “MultiCharts”