Instructables

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!
 
Remove these adsRemove these ads by Signing Up

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!
Work with excel files by the use of how to fix excell 2007

Read this article http://www.fixnotopenexcelfile.excelfilefix.com to know how
fwjs285 years ago
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...
dingleboy7 years ago
I use QuoteCat for placing stock quotes in Excel. It's very cool.
cflowers7 years ago
I featured this hack on The Daily Hack today. Neat trick!
royalestel7 years ago
That's pretty cool, man. Sknaht!