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

  • (no subject)

    In Calgary, Exploring the Cultural Side of ‘Cowtown’ (link is to The New York Times) Pretty good article, although I've never seen Calgarians…

  • Broken trees

    A few examples of trees broken by the accumulation of snow, as mentioned in my last post. The snow is gone, but the damage remains.

  • (no subject)

    I drove around town today and was shocked at the number of trees that had been damaged by the heavy snowfall earlier in the week. It's too early in…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic
  • 5 comments