A Google Sheet that tracks twelve comparable listings against your own rate, night by night, and flags the nights you sit above the street. Yours to copy and keep.
Copy the sheet
Or download as Excel
No signup. No email. The file opens in one click.
180 nights of rows, pre-dated
Twelve comparable listings side by side
Automatic gap column against the median
An events tab you can paste dates into
Conditional formatting already set up
pricing-tracker.xlsx
Date
Event
Your rate
Comp median
Gap
Fri 28 Aug
—
$210
$224
−$14
Sat 29 Aug
—
$210
$238
−$28
Sun 30 Aug
—
$210
$186
+$24
Mon 31 Aug
—
$190
$172
+$18
Fri 4 Sep
Labor Day
$210
$268
−$58
Sat 5 Sep
Labor Day
$210
$291
−$81
Sun 6 Sep
Labor Day
$210
$254
−$44
Fri 18 Sep
Design Festival
$210
$312
−$102
Sat 19 Sep
Design Festival
$210
$341
−$131
Sheet 1 of 3 · Nightly · Comps · Events180 rows
How to use it in ten minutes
01
Copy the sheet
File → Make a copy. Nothing to install, nothing to sign up for.
02
Paste twelve rivals
Same bedroom count, same neighbourhood, the ones a guest is actually choosing between.
03
Fill it once a week
Twenty minutes on a Sunday keeps the gap column honest for the whole week.
Where the sheet is enough
One listing in one neighbourhood
A quiet month where prices barely move
Learning what your comparables actually do
Where it stops
Event weekends, where rates move daily
More than one property
Any month you do not have two spare hours
Filling 180 rows by hand takes about two hours a month. A scan does the same thing nightly.
Skip the manual version
First scan free, no card. Same comparison, filled in for you on every scan, with events already matched.