News

Analyzing Exposures to Bitcoin in Real-Time

Recently, the price of bitcoin has reached a record high—increasing by more than 500% since early this year. Due to its decentralized nature and the popularity of block chain technology, there are those who see a bright future for cryptocurrency. Furthermore, the performance of bitcoin investments has attracted the attention of traditional investors looking to hop on the bandwagon through investments in companies likely to be impacted by this new technology.

TS Imagine’s constantly-expanding data offering allows investors to access historical prices of the bitcoin cryptocurrency (using the symbol USDBTC). With this data, investors track the relationship between holdings and bitcoin using a historical price time series of a portfolio containing holdings with cryptocurrency exposure. They then create a custom calculation (custom column) to calculate beta between the daily, weekly, and monthly price of each holding, and that of USDBTC within a certain time frame, e.g., 90/180/365 days.

The customized beta calculation can be displayed as a standalone portfolio column, or  incorporated into more advanced custom calculation columns, as shown below.

Investors looking to analyze the correlation between bitcoin and companies influenced by cryptocurrency utilize TS Imagine’s regression tools, either from the TS Imagine Trading System  (ITS)  or via the TS Imagine Financial Platform (IFP).

ITS users use a Multi-factor Regression tool that runs a least-squares regression on the portfolio to solve the beta relative to the chosen factor of USDBTC. The generated beta details can then be utilized by TS Imagine’s other risk tools, like a random Monte Carlo simulation.

TS Imagine 8.1 introduces the ability for an investor to run the multi-factor regression via an IFP app. Similar to the tools available within ITS, an IFP app offers the flexibility to define inputs like data source frequency, independent factors, time frame, and securities to be analyzed.  The output gives the result based on the desired setup.


About the Author

Jie Shen recently joined TS Imagine with more than three years’ experience in consulting and workflow customization in the financial technology industry. Jie is a member of TS Imagine’s APAC consulting team and will engage in new client implementation projects. She holds a PhD in Financial Mathematics from The City University of Hong Kong. She can be reached by email and phone: +852 3929 2268.

Related News

Insights from Interns

Our most recent interns, Nicholas and Timur, both joined us from Imperial College London where they are going into the third year of their Mechanical and Aerospace Engineering degrees, respectively. They spent 11 weeks working with TS Imagine’s Professional Services team in London this summer under the supervision of myself and Simarjit Johal (Regional Team Lead).

February 2, 2023

The Dollar Milkshake Theory – Stress Testing the Potential Impact of a Sovereign Debt and Currency Crisis

Stress Tests play an important role in improving financial stability by enhancing market discipline and transparency.  Here we consider the third example of these stresses based on current market conditions and show how the risk factors can be generated along with their relevant shock examples.

November 28, 2022

Europe, Russia & Energy – Simulating the Market Impact of Price Caps and the Cost of War

Since the start of the war in Ukraine, Western nations have imposed sanctions on many Russian individuals, businesses and state-run enterprises. Stress Tests play an important role in improving financial stability by enhancing market discipline and transparency. 

November 21, 2022