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.
I’d heard good things about this book from my friends – they’d remarked that this booked helped them to translate financial modelling theory into practice.
Get an Excel spreadsheet & VBA to calculate implied volatility with the bisection method. Discover how numerical bisection works, its advantages and disadvantages
This Excel spreadsheet has a VBA function (UDF) that scrapes live foreign exchange rates from Yahoo Finance. Read on for the free Excel spreadsheet and VBA.
Get real-time live foreign exchange rates in Excel with this free spreadsheet. The quotes are delayed by about 15 or 20 minutes but are updated every minute or so.
Want a tool to measure the stress of holding a stock? Then try the Ulcer Index, a technical indicator that describes the pain of continuously falling share prices.
Download historical stock quotes from Google Finance straight into Excel with this free spreadsheet. Everything is automated with some clever VBA (which you can view and extend.)
The Relative Strength Index helps you decide if a stock is overbought or oversold. Learn about it, and get an Excel spreadsheet that calculates RSI of a stock based on its ticker symbol.
Get VBA and an Excel spreadsheet for the Garman Kohlhagen model, a method of pricing European foreign exchange options.
Manage Cookie Consent
We use technologies like cookies to store and/or access device information. We do this to improve browsing experience and to show (non-) personalized ads. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
