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.

  • (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


    Anonymous comments are disabled in this journal

    default userpic