♦ Stock Quotes in Excel ♦Yahoo Finance Publishes delayed stock quotes from over 60 world exchanges through the Yahoo YQL web service. ♦Our product RealTimeToExcel allows getting and refreshing these stock quotes in Microsoft Excel. ♦To get stock quotes in Excel, just use formulas like these: =RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","Open") =RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","Last") |
♦ Fundamental Data in Excel ♦Yahoo Finance publishes technical and fundamental data. ♦You may easily get estimated price target, PE, PEG, market cap, dividends, actual and estimated EPS, etc. ♦To get the data, just use Regular Excel Formulas like these: =RTD("gartle.rtd",,"YahooFinanceQuotes","FB","PERatio") =RTD("gartle.rtd",,"YahooFinanceQuotes","FB","BookValue") |
♦ Historical Data in Excel ♦Yahoo Finance publishes historical stock prices. ♦RealTimeToExcel allows easily getting stock prices for the specified symbol and date in Excel. ♦Just use Excel formulas like this: =RTD("gartle.rtd",,"YahooFinanceHistoricalData","GOOG","2014-11-10","Close") |
♦ Option Data in Excel ♦Yahoo Finance publishes option chains. ♦RealTimeToExcel allows getting option data in two forms: by contract code and by contract parts. To get option data in Excel, use formulas like these: =RTD("gartle.rtd",,"YahooFinanceOptions", "AAPL150117C00100000","OpenInt") =RTD("gartle.rtd",,"YahooFinanceOptions", "AAPL","2015-01 17",100,"CALL","OpenInt") |
♦ Stock and Option Watchlists in Excel ♦ You may create stock and option watchlists in Excel. ♦Just combine all required data using regular Excel formulas, add formulas and values, apply formatting, etc. ♦ Excel can help you to find trading opportunities. ♦ Just open the workbook and check refreshed lists. |
♦ Track Portfolios in Excel ♦ There a lot of excellent online tools for tracking portfolios. ♦Excel is an excellent tool for training and tracking history of your trade successes and mistakes. ♦You may easily create multiple virtual portfolios and document your trade ideas. Excel will do the other jobs. |