A script for Yahoo stock data and older Quicken versions
Dec 04, '06 07:30:05AM • Contributed by: rjbailey
Dec 04, '06 07:30:05AM • Contributed by: rjbailey
Since Intuit finally broke the online stock quote feature for users of Quicken 2002 (presumably other versions, too), I was unable to update my stock portfolio by any automated method. Downloading stock price histories from Yahoo is pretty easy, but the CSV data format is not readable by older versions of Quicken, and I'm not about to reward Intuit for obsoleting Q2002 if all I'm missing is online stock quotes.
Not happy with other options I found on the internet, I was forced to come up with a method to streamline importing quotes from Yahoo into Quicken via a QIF file. I wrote a shell script that downloads a set of CSV price history files for a set of specified securities, converts them into QIF format, and writes them to a QIF file on the desktop for easy importing into Q2002.
The script is broken into several sections:
Not happy with other options I found on the internet, I was forced to come up with a method to streamline importing quotes from Yahoo into Quicken via a QIF file. I wrote a shell script that downloads a set of CSV price history files for a set of specified securities, converts them into QIF format, and writes them to a QIF file on the desktop for easy importing into Q2002.
The script is broken into several sections:
- Definition of symbol set for desired securities.
- Define first and last dates to download.
- Loop through set of symbols and download CSV files from Yahoo.
- Loop through CSV files and append properly formatted data to a single file named SecurityPrices.qif.
- Replace Unix EOL characters with Mac EOL characters.
- Remove temporary files.
•
[8,713 views]
