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 ?
Not possible to import multiple ticker quotes - any alternative ?
- fbertram
- Posts: 166
- Joined: 16 Oct 2014
- Location: Seattle, USA
- Has thanked: 36 times
- Been thanked: 76 times
- Contact:
Re: Not possible to import multiple ticker quotes - any alternative ?
Unfortunately yes. I suggest you write a little script to do so.
Cheers, Felix
Cheers, Felix
Re: Not possible to import multiple ticker quotes - any alternative ?
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 ?
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 ?
- fbertram
- Posts: 166
- Joined: 16 Oct 2014
- Location: Seattle, USA
- Has thanked: 36 times
- Been thanked: 76 times
- Contact:
Re: Not possible to import multiple ticker quotes - any alternative ?
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
Cheers, Felix