Resources

Blog-style articles that help you understand derivatives better by pricing them in Excel.
If you choose a category from the list on the left and click on the appearing envelope icon, you will be notified by email when a new article is posted in that category.

Includes articles relating to accessing live feeds in Excel through Deriscope

Market Data in Excel from IEX

cove_20181001-153146_1
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.IEX (Investors Exchange) is a new United States national stock exchange launched in New York in September 2016. Since February 2017 IEX publishes free of...
Continue reading
  7708 Hits
  0 Comments
7708 Hits
0 Comments

Market Data in Excel from TrueFX

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In. TrueFX is a provider of real time forex rates between the most liquid currencies. Both current prices and bid/offer quotes are streamed as quoted by various brokers.&n...
Continue reading
  7020 Hits
  0 Comments
7020 Hits
0 Comments

Market Data in Excel from Alpha Vantage

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.Alpha Vantage is a provider of live and historical prices of global stocks, indices and forex rates (both fiat and crypto) as well as time series of statistical in...
Continue reading
  10754 Hits
  0 Comments
10754 Hits
0 Comments

Market Data in Excel from Barchart

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In. Barchart is – among else - a provider of live and historical prices of global stocks, indices, mutual funds, futures, options and forex rates (both fiat and crypt...
Continue reading
  6175 Hits
  0 Comments
6175 Hits
0 Comments

Market Data in Excel from Yahoo Finance

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.Yahoo Finance is a provider of market information that includes live and historical prices of global stocks, indices, mutual funds, futures, options, commodities a...
Continue reading
  24836 Hits
  0 Comments
24836 Hits
0 Comments

Market Data in Excel from World Trading Data

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details.*********************************************************************************************** Deprecated! This service provider has been shut down! ******************************************************************************************...
Continue reading
  8256 Hits
  0 Comments
8256 Hits
0 Comments

Yahoo Finance Live Feeds in Excel after their API Discontinuation in November 2017

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In. On the fateful Wednesday of November 1st, 2017 Yahoo decided to stop their – until then – free service of delivering real time market data as a text stream through a s...
Continue reading
  3476 Hits
  0 Comments
3476 Hits
0 Comments

Accessing and Manipulating Historical Data from Yahoo Finance in Excel

cover
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.Yahoo Finance displays historical data for stock prices, indices, bond yields, fx rates, commodity prices etc on their website and allow anyone to download a text file ...
Continue reading
  15326 Hits
  0 Comments
15326 Hits
0 Comments

Introduction to Deriscope – Part 5: Live Feeds

cover
Overview Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.Deriscope enables you to receive in Excel live feeds from several different providers.These feeds include real time or almost real time prices of financia...
Continue reading
  22832 Hits
  0 Comments
22832 Hits
0 Comments

Using a Forex Trading Simulator in Excel

DsSimulatorFXOper
In my last post I showed you how to use the Deriscope Stock Trading Simulator Excel spreadsheet to place simulated BUY and SELL market orders on US stocks traded on IEX (the Investors Exchange)Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still...
Continue reading
  16971 Hits
  0 Comments
16971 Hits
0 Comments

Using a Stock Trading Simulator in Excel

DsSimulatorOper
As I promised you in my previous article I am back with a review of a Stock Trading Simulator that works in Excel and does not suffer from the mentioned drawbacks that hamper all other available free simulators.​Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the informat...
Continue reading
  10199 Hits
  0 Comments
10199 Hits
0 Comments

Should I use a Trading Simulator to learn how to trade?

Investopedia-OrderStock
Have you ever thought of being a trader? Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.I mean trading things like stocks, currencies, options or anything else that you can buy and sell almost instantly - typic...
Continue reading
  2091 Hits
  0 Comments
2091 Hits
0 Comments