Data engineer · Finance student · Italy

Hi, I'm Narcis.

I'm a data engineer in Italy, working toward becoming a financial advisor. What I love about both: building solutions, solving problems, turning big complex goals into small clear steps. I write about it every day. Stay a while; maybe you'll learn something. Maybe I will too.

Curious what I've been building? Start with the calculators: compound interest, FIRE, buy vs rent, lump sum vs DCA, and a few others.

Open the tools

yahoo_finance_pull.py

Yahoo Finance · daily prices

ecb_bonds_feed.json

ECB · EU gov bonds

pension_horizon.yaml

retirement plan · 40y horizon

transform.py

normalize · enrich

# transform.py — personal portfolio etl from pathlib import Path import pandas as pd import numpy as np import duckdb, yaml def load_prices(p: Path) -> pd.DataFrame: df = pd.read_parquet(p) df.index = pd.to_datetime(df.index) return df.resample("M").last() prices = load_prices("data/raw/prices") bonds = pd.read_json("data/raw/bonds.json") plan = yaml.safe_load(open("horizon.yaml")) # normalize · monthly log returns ret = np.log(prices / prices.shift()) ret = ret.dropna(how="all") # 60/40 weights, monthly rebalance w = np.array([0.60, 0.40]) port = (ret * w).sum(axis=1) # enrich · dca + compound nav = (1 + port).cumprod() * 1e4 nav = nav.add(plan["dca"], axis=0) # write · analytics store con = duckdb.connect("vwce_and_chill.duckdb") con.register("nav", nav.reset_index()) con.execute("create or replace table portfolio as ...") print("done · 360 rows · 60/40") # transform.py — personal portfolio etl from pathlib import Path import pandas as pd import numpy as np import duckdb, yaml def load_prices(p: Path) -> pd.DataFrame: df = pd.read_parquet(p) df.index = pd.to_datetime(df.index) return df.resample("M").last()

investment_plan.duckdb

VWCE and chill · 60/40

portfolio · EUR

€642,318

Or jump straight to a section

Three places to start, depending on what brings you here.

Recently published

Latest from both collections.

Hi, I'm Narcis.

Or jump straight to a section

Programming

Personal Finance

About & contact

Recently published