Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

A script for Yahoo stock data and older Quicken versions Apps
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:
  1. Definition of symbol set for desired securities.
  2. Define first and last dates to download.
  3. Loop through set of symbols and download CSV files from Yahoo.
  4. Loop through CSV files and append properly formatted data to a single file named SecurityPrices.qif.
  5. Replace Unix EOL characters with Mac EOL characters.
  6. Remove temporary files.
I'm certain the script could be written more elegantly, compactly, and efficiently, but it works well for me -- at least until Yahoo switches their URL scheme. I created a do shell script AppleScript that lives in my Scripts menu and executes the shell script, so it takes only a mouse click to do the whole operation, and another one to import the date into Quicken.
    •    
  • Currently 3.60 / 5
  You rated: 5 / 5 (5 votes cast)
 
[8,717 views]  

A script for Yahoo stock data and older Quicken versions | 0 comments | Create New Account
Click here to return to the 'A script for Yahoo stock data and older Quicken versions' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.