Portfolio Risk & Historical VaR by Kenan Cengiz GülerPortfolio Risk & Historical VaR by Kenan Cengiz Güler

Portfolio Risk & Historical VaR

Portfolio project
Kenan Cengiz Güler

Overview

An independent educational sample using synthetic prices. It is not a real portfolio, a forecast or investment advice, and it is not a client project.

Objective

Calculate portfolio risk measures in a spreadsheet where the weights, confidence level and portfolio value can be changed.

My role

I defined the model scope and the method, built the workbook and methodology note with AI-assisted tooling, and reviewed the results. The calculations were cross-checked with an AI-assisted Python script.

Approach

252 daily returns for three asset proxies (equity-like, bond-like, gold-like) feed calculations of sample volatility, correlation, covariance, one-day historical 95% and 99% VaR and three illustrative stress scenarios.

Tools

Microsoft Excel; PDF methodology note; AI-assisted build and checks.

Deliverables

One workbook with prices, returns and analysis sheets, and a PDF explaining the quantile method, the annualization assumption and the limits of the model.

Results

Volatility, correlation, covariance and VaR matched the independent check, and input changes recalculated correctly. VaR does not cap losses, and the scenario shocks are illustrative rather than forecasts.

0 likes · 0 views · Oct 11, 2026

Independent sample: three-asset Excel risk model with volatility, correlation and historical 95%/99% VaR. Synthetic prices.

Tags