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!
9 years ago on Introduction
Work with excel files by the use of how to fix excell 2007
Read this article http://www.fixnotopenexcelfile.excelfilefix.com to know how
14 years ago on Introduction
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...
16 years ago
I use QuoteCat for placing stock quotes in Excel. It's very cool.
16 years ago
I featured this hack on The Daily Hack today. Neat trick!
16 years ago
That's pretty cool, man. Sknaht!