Plot the historical returns histogram from prices automatically downloaded from Yahoo Finance, all in Excel.
Learn how to calculate the exponential moving average in Excel and VBA, and get a free web-connected spreadsheet.
Get financial data for multiple companies in Excel, straight from the web. Retrieve EPS estimates, EBIDTA, dividend yields, PE ratios and more.
Learn how to annualize daily, weekly and monthly volatilities. Plus get free web-connected spreadsheets to calculate the historic volatility of stocks, precious metals and currency pairs.
This spreadsheet imports historical prices for gold, silver, platinum and palladium from the Internet, and plots several technical trading indicators.
Get gold spot prices in Excel with a live connection to the web. Import the open, bid, ask and previous closes prices, updating regularly.
Get historical prices for gold and silver with this free web-connected spreadsheet. You can get prices in many different currencies.
Discover a simple technique to calculate if a stock is a good buy, based on easily-found financial data. This approach is similar to the techniques pioneered by Warren Buffet and Benjamin Graham.
This free Excel spreadsheet downloads multiple FX rate histories from a web service. You can then plot and analyze the exchange rate data, and backtest your trading strategies with Excel’s broad suite of tools and functions.
Automatically download historical prices for West Texas Intermediate crude oil into Excel. Once in Excel, you can analyze, visualize and back-test the data.