Not possible to import multiple ticker quotes - any alternative ?

Questions about MultiCharts and user contributed studies.
Automeq
Posts: 101
Joined: 16 Apr 2014
Has thanked: 12 times
Been thanked: 1 time

Not possible to import multiple ticker quotes - any alternative ?

Postby Automeq » 09 Mar 2018

I have a big txt file with historical quotes of S&P500 components

As far as I understood, reading another tópic, there is no possibility to import this into Quote Manager, right ?

Does this mean that I would have to split the txt file in 500 files, one for each ticker ?

User avatar
fbertram
Posts: 166
Joined: 16 Oct 2014
Location: Seattle, USA
Has thanked: 37 times
Been thanked: 72 times
Contact:

Re: Not possible to import multiple ticker quotes - any alternative ?

Postby fbertram » 09 Mar 2018

Unfortunately yes. I suggest you write a little script to do so.

Cheers, Felix

Automeq
Posts: 101
Joined: 16 Apr 2014
Has thanked: 12 times
Been thanked: 1 time

Re: Not possible to import multiple ticker quotes - any alternative ?

Postby Automeq » 10 Mar 2018

Thanks. Sounds the only solution, although in Python should not be difficult.

Another question: if I manage to have, every day, the daily quotes of these S&P500 components, does QuoteManager append that new day to the existing quotes ? Or does it delete everything and only leaves the current day ?

User avatar
fbertram
Posts: 166
Joined: 16 Oct 2014
Location: Seattle, USA
Has thanked: 37 times
Been thanked: 72 times
Contact:

Re: Not possible to import multiple ticker quotes - any alternative ?

Postby fbertram » 10 Mar 2018

The daily quotes will be *added* to the database. Please note that this might also lead to issues: after splits or dividends, past quotes need to be adjusted... something that won't happen automatically. Once in a while it might be good to delete the data in the database and download historical quotes again.

Cheers, Felix

Automeq
Posts: 101
Joined: 16 Apr 2014
Has thanked: 12 times
Been thanked: 1 time

Re: Not possible to import multiple ticker quotes - any alternative ?

Postby Automeq » 10 Mar 2018

Yep.... splits are not so frequent in S&P500 but dividends can be a pain!
Thanks for the advice.


Return to “MultiCharts”