I have corrected the formula above to reflect the new URL. Thanks to Paul Valencia for pointing out that in late May 2017 the URL for the Yahoo Finance webservice changed. Who knows.analyzing earnings calls as I describe could help you make more profitable trades! In it, I describe a novel approach for tracking how a company's earnings calls and the sentiments expressed therein evolve over time.
If you pay close attention to corporate earnings calls, please take a look at this article. I hope you find the template useful, and please let me know if you have any feedback! I'm glad this post has proven useful to you. To take this exercise one step further, I've created a simple Portfolio Tracking Template and posted it to my OneDrive account. Update: Thanks for all the nice feedback.
Excel will add a new category named Data Type under the Refresh command, along with other data type related actions. I recently posted this article that describes a solution using Excel and Google Finance to get real-time information for listings on non-US exchanges. You need to right-click on a cell with the stock icon. Note: In my experience the above solution is hit-or-miss with regards to supporting equities listed on non-US exchanges.
And, when your spreadsheet is open, click ctrl+alt+F9 to update B1 with the latest-and-greatest price.
Paste the above formula into cell B1, and you'll get a real-time price of VTI in B1. In this example, cell A1 contains the symbol of a stock or ETF or mutual fund.VTI for example. If you use Excel 2013 to track a stock/ETF/mutual fund portfolio, like I do, here's a formula that you might find super-useful, like I do!