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.
adding new data line from excel
- 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
Is this a one time edit?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.
or are you planning to do this on a daily basis?
- 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
Have you tried using the FreeQuotes connection? That connection can download data from Yahoo directly.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.
Re: adding new data line from excel
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.
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.
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: adding new data line from excel
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.
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.