Includes articles relating to accessing live feeds in Excel through Deriscope

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. Deriscope automates this process through a special spreadsheet formula called dsLive that takes as input the handle name of an object containing the specs o...
Continue reading
  562 Hits
  0 Comments
562 Hits
0 Comments

Asian Option Pricing in Excel using QuantLib: Monte Carlo, Finite Differences, Analytic models for Arithmetic and Geometric Average. Example with live EUR/USD rate

cover
Asian options come in different flavors as described below, but to the extent they have European exercise rights they can be priced by QuantLib using primarily Monte Carlo , but under certain circumstances using also Finite Differences or even analytic formulas. The main feature of an Asian option is that it involves the average of the realized pri...
Continue reading
  1050 Hits
  0 Comments
1050 Hits
0 Comments

Introduction to Deriscope – Part 5: Live Feeds

cover
Deriscope enables you to get live feeds that include last traded stock prices, forex rates, bid/offer quotes, historical time series and financial data from various providers in Excel. Currently these providers are the Yahoo Finance, Alpha Vantage, IEX (Investors Exchange) and TrueFX. The special function dsLive takes as input an object of type Liv...
Continue reading
  1229 Hits
  0 Comments
1229 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 ) Enter heading here...  In this post I will guide you through another Excel spreadsheet called DsTradingSimulatorFX.xlsm that you can also download for...
Continue reading
  563 Hits
  0 Comments
563 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. ​ Apologies for the long time gap since my earlier post, but I wanted to provide you with the very latest version of the Simulator describ...
Continue reading
  633 Hits
  0 Comments
633 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 ...
Continue reading
  161 Hits
  0 Comments
161 Hits
0 Comments