Because googlefinance() keeps breaking my spreadsheets.
- 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
- 01/2026 use NAV instead of close
- http://localhost:8080
- http://ignc.dev:8080
- https port:8081
| 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} |
- 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")
| Function | url endpoint |
|---|---|
| Add new fund | /addfund |
| Add historical price record | /addpricerecord |