A price tracking spreadsheet for a single product needs six columns: date, store, price, delivery, total and notes, plus one cell holding your target price. Check the price once a week, add a row, and let a formula tell you whether the total is at or below target. After eight weeks you will know the usual range and can buy with confidence instead of hunches.
Which columns should the sheet have?
- Date: a real date, one row per check.
- Store: the seller or site, in plain words.
- Price: the listed price in rupees, numbers only.
- Delivery: the delivery fee shown for your pin code, or 0.
- Total: Price plus Delivery, which is the figure that matters.
- Notes: variant, colour, a visible discount or a bank offer that changed the price.
Keep the same variant throughout. A different colour, size or warranty pack is a different product, and mixing them makes the history meaningless. Put your target price in a labelled cell, such as H1, with the label Target in G1.
What does eight weeks of a made-up product look like?
Say you are watching an air fryer and have decided ₹4,500 is a fair price for you. The prices below are invented.
| Date | Price | Delivery | Total | Against target |
|---|---|---|---|---|
| 18 Sep | ₹4,999 | ₹0 | ₹4,999 | Wait |
| 25 Sep | ₹4,999 | ₹0 | ₹4,999 | Wait |
| 2 Oct | ₹5,199 | ₹99 | ₹5,298 | Wait |
| 9 Oct | ₹4,799 | ₹0 | ₹4,799 | Wait |
| 16 Oct | ₹4,799 | ₹0 | ₹4,799 | Wait |
| 23 Oct | ₹4,599 | ₹0 | ₹4,599 | Wait |
| 30 Oct | ₹4,899 | ₹99 | ₹4,998 | Wait |
| 6 Nov | ₹4,699 | ₹0 | ₹4,699 | Wait |
In the Total column, enter =C2+D2 and copy it down. In the last column, enter =IF(E2<=$H$1,"Buy","Wait"). Every row says Wait, because the lowest total in the eight weeks, ₹4,599, is still ₹99 above the ₹4,500 target.
What should you read from the history?
Three quick numbers help. The lowest total is =MIN(E2:E9), which gives ₹4,599. The highest is =MAX(E2:E9), which gives ₹5,298. The gap between them is ₹5,298 − ₹4,599 = ₹699, so the price moved by around ₹700 in two months.
Latest total is ₹4,699, which is ₹199 above your target. If the trend is drifting down, waiting a few more weeks might get you there. If you need the item soon, you can compare the cost of waiting with the cost of paying ₹199 more.
Is my target price realistic?
A target pulled from nowhere can leave you waiting forever. Set it after you have two or three weeks of entries, not before, and set it inside the range you have seen. Here the lowest was ₹4,599. A target of ₹4,500 asks for a price that has not appeared yet, so it might never come. If you would be happy at ₹4,600, change H1 and the sheet recalculates.
Can you chart the history?
Yes. Select the Date and Total columns and insert a line chart. If the dates are real dates and not text, the axis will space them correctly. A flat line with brief spikes tells you the price is stable and the spikes are delivery fees or short promotions. A downward slope suggests waiting may help.
Where does an expense tracker fit?
Once you buy, the price sheet has done its job. The purchase itself goes into your expense tracker at the amount you paid, whether from an imported statement or a hand entry, and you can attach the receipt so the warranty proof sits with the transaction. SpendixAI keeps receipts with their transactions, which is useful when you need the invoice a year later.
- Weekly: add a row.
- After eight weeks: set or revise the target.
- On purchase: note the final total and archive the tab.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


