---
title: "Alper San (@siftingio) | Hashnode"
description: "Building SiftingIO: market data APIs and practical examples for developers. Read the latest articles by Alper San on Hashnode."
url: "https://hashnode.com/@siftingio"
---

@siftingio

# Alper San

@siftingio · Joined October 2026

Building SiftingIO: market data APIs and practical examples for developers.

### [Tracking Error vs Tracking Difference: A Python Example](https://siftingio-developers.hashnode.dev/tracking-error-vs-tracking-difference-python?utm_source=hashnode&utm_medium=feed)

Compare tracking error and tracking difference with a tested Python example, ETF return tables and checks for NAV, benchmarks and annualisation.

8 min read · [siftingio-developers.hashnode.dev](https://siftingio-developers.hashnode.dev/tracking-error-vs-tracking-difference-python?utm_source=hashnode&utm_medium=feed)

[5d ago](https://hashnode.com/posts/tracking-error-vs-tracking-difference-python/6afac54326182420102be5bf)

### [RSI in Python: Wilder’s Formula and Live Candle Updates](https://siftingio-developers.hashnode.dev/rsi-in-python-wilder-s-formula-and-live-candle-updates?utm_source=hashnode&utm_medium=feed)

Calculate RSI in Python with Wilder's smoothing, check a worked example and update live candles without counting the same bar twice.

12 min read · [siftingio-developers.hashnode.dev](https://siftingio-developers.hashnode.dev/rsi-in-python-wilder-s-formula-and-live-candle-updates?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/rsi-in-python-wilder-s-formula-and-live-candle-updates/6af32998f910c8b38f0b389e) [Nov 10](https://hashnode.com/posts/rsi-in-python-wilder-s-formula-and-live-candle-updates/6af32998f910c8b38f0b389e)

### [CAGR vs Average Annual Return: Formula and Examples](https://siftingio-developers.hashnode.dev/cagr-vs-average-annual-return-formula-and-examples?utm_source=hashnode&utm_medium=feed)

Compare CAGR and arithmetic average annual return with worked examples, Excel formulas and checks for historical price data.

9 min read · [siftingio-developers.hashnode.dev](https://siftingio-developers.hashnode.dev/cagr-vs-average-annual-return-formula-and-examples?utm_source=hashnode&utm_medium=feed)

[Nov 7](https://hashnode.com/posts/cagr-vs-average-annual-return-formula-and-examples/6aef307e4cf43edb0a6b6244)

### [Market Data CSV to Parquet in Python: Preserve Types and UTC Timestamps](https://siftingio-developers.hashnode.dev/market-data-csv-to-parquet-in-python-preserve-types-and-utc-timestamps?utm_source=hashnode&utm_medium=feed)

A market data CSV is easy to inspect and share. It is less good at telling your next Python script what each column means. A timestamp arrives as text, a blank volume field can become a missing number

6 min read · [siftingio-developers.hashnode.dev](https://siftingio-developers.hashnode.dev/market-data-csv-to-parquet-in-python-preserve-types-and-utc-timestamps?utm_source=hashnode&utm_medium=feed)

[Nov 2](https://hashnode.com/posts/market-data-csv-to-parquet-in-python-preserve-types-and-utc-timestamps/6ae8ac7fe6c2f5e49bee6cb0)

### [Maximum Drawdown in Python: Calculate Loss and Recovery Time](https://siftingio-developers.hashnode.dev/maximum-drawdown-in-python-calculate-loss-and-recovery-time?utm_source=hashnode&utm_medium=feed)

Calculate maximum drawdown with pandas, identify peak and recovery dates, handle unrecovered losses, and plot historical market data.

9 min read · [siftingio-developers.hashnode.dev](https://siftingio-developers.hashnode.dev/maximum-drawdown-in-python-calculate-loss-and-recovery-time?utm_source=hashnode&utm_medium=feed)

[Oct 28](https://hashnode.com/posts/maximum-drawdown-in-python-calculate-loss-and-recovery-time/6ae1db1f6d689120c59fedb0)
