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!
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.
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.
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!
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!