Hacking Microsoft Office Excel to Read Live RSS Stock News Feeds

Published

Introduction: Hacking Microsoft Office Excel to Read Live RSS Stock News Feeds

You can easily get Excel to act as a live stock RSS news reader with a free add-on. What's cool about this, as opposed to using a regular news reader, is that you can have it update the news depending on the stock symbol you are interested in. Plus, you can also add live stock quotes as well.

And simply by pressing F9, your news will udpate to the latest news about your stocks!

Step 1: Free Download for Microsoft Office Excel Reads RSS Files

Download and install this software at http://www.esquotes.com/SetupESQ20.exe

It will install a small dll in your system32 folder, which is used by Excel to read the RSS file.

Step 2: Workbook for Microsoft Office Excel DYI RSS Reader for Stocks

Go to Windows start: programs: ESQuotes2: ESQMgr.exe.
Click on the Examples tab and then on ESQBasic.

Step 3: Create Your Own Personal Excel Workbook to Read Stock RSS Feeds

In cell D26, enter IXIC
In cell D27, enter DJI
In cell D28, enter GCI
In cell D29, enter WTR
In cell D30, enter LEN
In cell D31, enter MSA
In cell D32, enter OCR
In cell D33, enter IVC
In cell E26, enter =HYPERLINK(ESQNewsLink(D26,0),ESQNewsHead(D26,0)&" ("&esqnewsdate(D26,0)&")")
In cell E27, enter =HYPERLINK(ESQNewsLink(D27,0),ESQNewsHead(D27,0)&" ("&esqnewsdate(D27,0)&")")
In cell E28, enter =HYPERLINK(ESQNewsLink(D28,0),ESQNewsHead(D28,0)&" ("&esqnewsdate(D28,0)&")")
In cell E29, enter =HYPERLINK(ESQNewsLink(D29,0),ESQNewsHead(D29,0)&" ("&esqnewsdate(D29,0)&")")
In cell E30, enter =HYPERLINK(ESQNewsLink(D30,0),ESQNewsHead(D30,0)&" ("&esqnewsdate(D30,0)&")")
In cell E31, enter =HYPERLINK(ESQNewsLink(D31,0),ESQNewsHead(D31,0)&" ("&esqnewsdate(D31,0)&")")
In cell E32, enter =HYPERLINK(ESQNewsLink(D32,0),ESQNewsHead(D32,0)&" ("&esqnewsdate(D32,0)&")")
In cell E33, enter =HYPERLINK(ESQNewsLink(D33,0),ESQNewsHead(D33,0)&" ("&esqnewsdate(D33,0)&")")

Press F9 and your workbook will update and give you the latest news on any stock you want!

Share

    Recommendations

    • Oil Contest

      Oil Contest
    • Clocks Contest

      Clocks Contest
    • Creative Misuse Contest

      Creative Misuse Contest

    5 Discussions

    rhis isn't hacking...its downloading a file to insert rss functionality into excel...why you would want rss in excel beats me, there are far better options...although it is kinda cool because excel isn't an rss program...anywho...

    I use QuoteCat for placing stock quotes in Excel. It's very cool.

    That's pretty cool, man. Sknaht!