29 August 2022 Python
The most popular and useful Python libraries and APIs for different free market-data services and sources.
28 May 2022 Risk Management
Due to its simplicity, the Black-Scholes-Merton (BSM) model has been widely used by financial institutions and traders for option pricing. However, the BSM model has a number of important...
2 May 2022 Python
Monte-Carlo simulation is a useful tool to simulate stochastic processes. In this article, I show a simple case of using Monte Carlo in Python to calculate a European option price and compare the...
7 January 2022 Risk Management
There are several regions with incredibly tense and unstable political situations and high anti-American sentiment. The probability of escalation in some of those regions is relatively high, and...
20 November 2021 Risk Management
The Global Financial Crisis was a unique phenomenon that not only affected many millions of people and tens of thousands of companies at the time but also impacted the global financial system and...
23 July 2021 Python
Here is a step-by-step example of how to create a Python app on an Apache virtual hosting and call this app from a php-site.
19 July 2021 SAS
Problem: We have a table of stock returns with columns "Date", "Ticker", "Return", which is not handy to analyse. We need to convert this table to the format "Date", "Ticker1 Return", "Ticker2...
3 January 2021 Market
An initial public offering, IPO, or stock market launch is the first sale of stock by a private company to the public. During 2019-2020 we could observe an IPO hype when hundreds of companies...
28 December 2020 Excel & VBA
Exponential Weighted Volatility (EWMA, Exponential Weighted Moving Average) is an approach to volatility calculation. The main objective of the EWMA approach is to closely track the volatility as it...
21 December 2020 Excel & VBA
One of the most useful functions in Excel is a function that shows unique values from a range. There is a native UNIQUE function but it doesn't do the job very well and isn't supported by older...
12 December 2020 Risk Management
In a case when there are no orders in a DOM for a strike but there is necessary data for the lower and higher strikes, one of the ways to calc the find "fair" implied volatility (IV) (and hence, an...
12 October 2020 Excel & VBA
The VBA script below saves a sheet to xlsx file with today's date in the name.