price-web-api

Because googlefinance() keeps breaking my spreadsheets.

Features

• localhost only endpoint to add (httpPOST) fund & pricing data
• remote open endpoint to fetch (httpGET) pricing information (to be used in googlespreadsheet)
• XML output supported IMPORTXML
• Ready for containerization

Quick start

Run using Docker

docker build --pull --rm -f "Dockerfile" -t pricewebapi:latest .
docker run -d -p 8080:8080 --name pricewebapi pricewebapi:latest

API @ localhost:8080

Example integration in python

Remote GET api

• http://localhost:8080
• http://ignc.dev:8080

Function	url endpoint
Get ETF/ETC details from ticker	/funds/{ticker}
Get all daily data for a ticker	/prices/{ticker}
Get daily data record	/pricerecord/{ticker}/{date}
Get daily data record in XML	/pricerecord.xml/{ticker}/{date}

Googlesheets example

• TICKERCELL being a ticker e.g: V3AA
• DATECELL being a date, YYYY-MM-DD format e.g: 2025-12-31
• returned floats according to "en_US" (dot as comma) standard

=IMPORTXML("http://ignc.dev:8080/pricerecord.xml/" & TICKERCELL & "/" & text(DATECELL;"YYYY-MM-DD");"/PriceRecord/close"; "en_US")

Localhost only POST api

Function	url endpoint
Add new fund	/addfund
Add historical price record	/addpricerecord