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
  7547 Hits
  0 Comments
7547 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
  6862 Hits
  0 Comments
6862 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
  10418 Hits
  0 Comments
10418 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
  6059 Hits
  0 Comments
6059 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
  24529 Hits
  0 Comments
24529 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
  8054 Hits
  0 Comments
8054 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
  3352 Hits
  0 Comments
3352 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
  14924 Hits
  0 Comments
14924 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
  22560 Hits
  0 Comments
22560 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
  16371 Hits
  0 Comments
16371 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
  9756 Hits
  0 Comments
9756 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
  2004 Hits
  0 Comments
2004 Hits
0 Comments