Neil (nt) wrote,
Neil
nt

  • Mood:
  • Music:
I have a spreadsheet with stock quotes, which I used to update by looking up the quotes in the newspaper (and later, on the internet) and entering them manually into the spreadsheet. After I had been on the internet a while, I searched for an Excel add-in that would automate the process. I found ESQuotes, which worked well, so I registered it and used it for a few years. Then I updated to Windows XP and found that ESQuotes no longer worked properly. I tried contacting support, but didn't get a response, so I searched again and found another add-in called QuoteCat. That worked until today, when it disappeared from my Excel menu. Uninstalling and re-installing QuoteCat didn't fix the problem.

Fortunately, a few weeks ago I had discovered OpenOffice, a free open-source office suite (also marketed by Sun as StarOffice). Out of curiosity, I googled to see if it had a stock quote function and found a user-written macro that would do exactly what I wanted. I filed it in the back of my mind, thinking it might be worth trying someday. After my problem with QuoteCat, I decided that today would be the day. It took me only half an hour to download and install OpenOffice, add the macro and convert my spreadsheet! And it works perfectly.
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic
  • 5 comments