Neil (nt) wrote,

  • 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.
  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic