# fonfiyat.com.tr

> Free, keyless daily prices and returns for all Turkish mutual funds (TEFAS) and pension funds (BEFAS), formatted for Google Sheets, Excel and programs. Source: tefas.gov.tr public data. Not investment advice.

Last price date: 2026-09-30. Funds: 2443. Updated every business day around 11:30 Europe/Istanbul.

## How to use in Google Sheets
- Price of one fund: =IMPORTDATA("https://fonfiyat.com.tr/fiyat/AFA";";")  (replace AFA with the fund code; the ";" delimiter argument is required)
- Price + period returns as a one-row table: =IMPORTHTML("https://fonfiyat.com.tr/fon/AFA";"table";1)
- One field: =IMPORTXML("https://fonfiyat.com.tr/fon/AFA";"//*[@id='getiri-1y']")
- All funds: =IMPORTDATA("https://fonfiyat.com.tr/v1/funds.csv";";")

## Pages
- https://fonfiyat.com.tr/fon/<CODE>: fund page (price, daily and 1m/3m/6m/ytd/1y/3y/5y returns, AUM, investors, 30-day history, portfolio allocation)
- https://fonfiyat.com.tr/fonlar: all investment funds
- https://fonfiyat.com.tr/emeklilik-fonlari: all pension funds
- https://fonfiyat.com.tr/kategoriler: fund categories (e.g. hisse senedi, para piyasası, altın) and founders; each links to a list page
- https://fonfiyat.com.tr/kategori/<slug>, https://fonfiyat.com.tr/kurucu/<CODE>: funds by category / by asset management company
- https://fonfiyat.com.tr/rehber/google-sheets: Google Sheets guide (Turkish)
- https://fonfiyat.com.tr/rehber/excel: Excel Power Query guide (Turkish)
- https://fonfiyat.com.tr/api: API reference
- https://fonfiyat.com.tr/blog: articles (Turkish) — why scraping tefas.gov.tr stopped working in 2026, portfolio tracking in Sheets, how to read fund returns

## API (no key, no rate limit, 1h cache)
- GET /v1/funds.json  | GET /v1/funds.csv?locale=tr|en&tip=YAT|EMK|all
- GET /v1/funds/<CODE>.json
- GET /v1/funds/<CODE>/history.csv?from=YYYY-MM-DD
- GET /fiyat/<CODE>  (plain-text price; ?locale=en for dot decimal)

Numbers default to Turkish format (decimal comma, ";" CSV separator); add ?locale=en for dot decimal.