Importing prices - vingerha/gazpar_2_mqtt GitHub Wiki

Gazpar2mqtt can ingest your own energy prices to estimate your costs. Download and complete the sample file prices.csv using the following format :

• PCE : your PCE id
• startDate : starting date of the price
• endDate : end date of the price (put a far far end date at the last row of the file, ie : 2999-12-31)
• kwhPrice : the price per kWh (don't forget to apply the TVA to this cost, and to add the french energy tax per kwh)
• fixPrice : the fix price per day (it corresponds for example to the price of your subscription with your gas provider, don't forget to apply the TVA)

pce;startDate;endDate;kwhPrice;fixPrice
XXXX;2019-11-28;2020-12-27;0.03713;0.25
XXXX;2020-12-28;2021-01-25;0.03472;0.30
XXXX;2021-01-26;2099-12-31;0.03733;0.35

Important: proper location of the file

• For docker/container (not HAOS): place your prices.csv in the path defined for /data (same location as your gazpar2mqtt.sqlite database)
• For HAOS: place your prices.csv in the confg/gazpar_2_mqtt folder (same location as your config.yaml)