Frequently Asked Questions

What is a stock spread?

A stock spread is the difference between the price you paid for a stock and the actual market price at the time of your transaction. It helps you understand if you got a good deal or paid more than the market rate.

How does this calculator work?

Enter your transaction details including ISIN, number of units, total amount paid, fees, and the exact date/time of your transaction. The calculator fetches the historical market price from Yahoo Finance and compares it to your execution price.

What is an ISIN?

ISIN (International Securities Identification Number) is a unique 12-character alphanumeric code that identifies a specific security. You can usually find it on your broker's statement or by searching for the stock online.

Where does the market data come from?

The calculator fetches historical price data from Yahoo Finance, which provides reliable market data for most publicly traded securities worldwide.

Why do I need to specify the timezone?

Stock prices change throughout the trading day. Specifying the timezone ensures we fetch the correct market price for the exact time of your transaction, accounting for different market opening hours around the world.

How is the spread calculated?

The spread is calculated using the typical price formula (high+low+close)/3 for more accurate results. Due to Yahoo Finance API restrictions, we can only fetch 8 days of 1-minute granularity data per request, which limits historical accuracy beyond this timeframe.

Why must the transaction date be within the last 30 days?

The Yahoo Finance API imposes a strict restriction: only data from the last 30 days is accessible with 1-minute granularity. Beyond this period, the API returns a 422 error and the calculation cannot be performed. This limitation is specific to Yahoo Finance and cannot be bypassed.

Can I calculate the spread for older transactions?

No, it is not possible to calculate the spread for transactions older than 30 days with this tool. If you need to analyze older transactions, you will need to use other historical data sources or check your broker statement directly, which may contain spread information provided by your trading platform.

How to retrieve your spreads on Trade Republic?

Why are prices different from the Lang & Schwarz statement?