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
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 charge their trading data in real time. These include live and historical prices of over 8,000 US stocks and mutual funds plus financial information and news.If all you want is a very quick a...
Continue reading
  6831 Hits
  0 Comments
6831 Hits
0 Comments

Market Data in Excel from TrueFX

cover
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. If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos below:Getting easily live...
Continue reading
  6193 Hits
  0 Comments
6193 Hits
0 Comments

Market Data in Excel from Alpha Vantage

cover
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 indicators. If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos below:Getting...
Continue reading
  9415 Hits
  0 Comments
9415 Hits
0 Comments

Market Data in Excel from Barchart

cover
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 crypto). If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos below:Getting easily...
Continue reading
  5621 Hits
  0 Comments
5621 Hits
0 Comments

Market Data in Excel from Yahoo Finance

cover
Yahoo Finance is a provider of market information that includes live and historical prices of global stocks, indices, mutual funds, futures, options, commodities as well as forex (both fiat and crypto) and US treasury bond rates. If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in y...
Continue reading
  23756 Hits
  0 Comments
23756 Hits
0 Comments

Market Data in Excel from World Trading Data

cover
*********************************************************************************************** Deprecated! This service provider has been shut down! ***********************************************************************************************World Trading Data is a provider of live and historical prices of global stocks, indices, US mutual ...
Continue reading
  7546 Hits
  0 Comments
7546 Hits
0 Comments

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

cover
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 special URL. For hundreds of businesses and individuals who had relied for years on Yahoo's benevolent free service, this single action meant only one thing: Instant death!If all you w...
Continue reading
  2940 Hits
  0 Comments
2940 Hits
0 Comments

Accessing and Manipulating Historical Data from Yahoo Finance in Excel

cover
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 with these data for free.If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos bel...
Continue reading
  13843 Hits
  0 Comments
13843 Hits
0 Comments

Introduction to Deriscope – Part 5: Live Feeds

cover
Overview Deriscope enables you to receive in Excel live feeds from several different providers.These feeds include real time or almost real time prices of financial securities (stocks, ETFs, indices, currencies, cryptocurrencies, futures and options), bid/offer quotes and sizes, time series of historical prices and statistical indicators, comp...
Continue reading
  21330 Hits
  0 Comments
21330 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) In this post I will guide you through another Excel spreadsheet called DsTradingSimulatorFX.xlsm that you can also download for free. This new spreadsh...
Continue reading
  14196 Hits
  0 Comments
14196 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.​Here comes a spreadsheet called DsTradingSimulator.xlsm that you can download for free from https://www.deriscope.com/freedownload.ph...
Continue reading
  8294 Hits
  0 Comments
8294 Hits
0 Comments

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

Investopedia-OrderStock
Have you ever thought of being a trader? I mean trading things like stocks, currencies, options or anything else that you can buy and sell almost instantly - typically online - by pressing a button and not illiquid assets, such as houses or antique furniture. Wouldn't it be great to get some sense of what real world trading looks like before s...
Continue reading
  1796 Hits
  0 Comments
1796 Hits
0 Comments