Field guideHomies Research · Field guide

AI market reports for realtors, built from live Canadian real estate stats.

Stop screenshotting last month's PDF. One prompt turns the latest CREA, TRREB and Bank of Canada data into a branded, interactive market report for any market in Canada — with a lead-capture gate and Instagram assets if you want them.

Daniel FochSeptember 15, 2026 11 min read

Live data

104 CREA markets, 41 GTA municipalities and 222 economic series, loaded the day each release drops. Free, no API key.

Interactive

Charts you can hover and zoom, embedded in your report — not images of charts.

One prompt

Copy, paste into Homies, answer four questions. The report, the email and the carousel come back for approval.

Share Post LinkedIn Email

Definition

What an AI market report is — and what it isn't

Every realtor sends a market update. Most are built the same way: wait for the board PDF, screenshot two charts, drop them into a template, write three paragraphs that could have been written last month, and send. Market report software automates the template step and charges a subscription for it, but the output is the same object — a static page or PDF of last month’s numbers that every agent on the platform is also sending.

An AI market reportstarts from the other end. An assistant reads the live data feed for your market — the CREA release that came out this morning, the TRREB Market Watch from last week, the Bank of Canada’s current rate — computes the year-over-year changes itself, writes the narrative for the audience you name, and embeds charts that readers can hover and zoom. The report is different for a first-time buyer in Halifax than for an investor in Calgary, because you told it who it was for. It takes about four minutes, and the data underneath it is free.

This guide shows a finished one, walks through the Canadian real estate stats it draws on, compares it honestly with the software category, and gives you the prompt.

Worked example

A finished one: Canada, August 2026

CREA published its August statistics on September 15. The same morning, the release was in the feed and this report was live: Two Canadas, in charts you can touch . Eleven charts, each with the stat to notice and the line to say. Three of them are embedded here — they are the actual live views, not screenshots, so what you see is current as you read this.

Provinces, indexed to January 2022

Ontario 78 · Alberta 118 · New Brunswick 132 · Newfoundland 137

The single chart every Canadian buyer should see before reading a national headline. Drag the brush to zoom.

/stats/compareOpen full screen

Sales and new listings on one chart

Sales −7% yr/yr · listings −3% · ratio 49.1%

Two measures, two axes, tooltips on hover — the kind of chart a PDF cannot be.

/stats/exploreOpen full screen

Sales against the 5-year mortgage rate, inverted

Posted 5-year 6.09% · overnight 2.25%

Housing data next to Bank of Canada data on the same timeline, from the same feed.

/stats/macroOpen full screen

The GTA version — built from TRREB’s Market Watch with municipality-level detail and home-type splits — is here: Toronto’s August, in charts you can touch . Both pages carry the prompt that produced them.

The feed

The Canadian real estate stats underneath

The reports draw on Homies Stats, a public housing-data feed we maintain for the Homies AI team and for any realtor who wants it. Every series is plain JSON with no API key, refreshed on release day, and rendered on demand as interactive embeds or brandable chart images. It is, as far as we know, the most complete free set of Canadian housing statistics available in one place:

CREA board statistics

104 markets — 91 real estate boards, 12 provinces and territories, and the national series — monthly average price, sales, new and active listings, sales-to-new-listings ratio and months of inventory. Boards reach back to 1980; the national average price series starts in 1993.

TRREB Market Watch

41 GTA regions and municipalities, five home types, every month since 2011 — plus the MLS® HPI composite benchmark — parsed from every Market Watch release.

Bank of Canada & StatCan

222 macro series: policy and mortgage rates, CPI and its components, the Labour Force Survey, EI claims, GDP by industry, population and migration, mortgage originations and the variable-rate share.

CMHC, OSB and the LTB

Housing starts, rents and vacancy by CMA; consumer insolvencies; and Ontario Landlord and Tenant Board order counts — the datasets a market report usually has to skip.

Because the housing and macro series share one timeline, a report can put your board’s sales next to the 5-year mortgage rate, or a province’s prices next to its unemployment rate, without exporting anything. Explore it directly at homiesai.com/stats , or hand the feed to any AI with the housing-data prompt .

Comparison

Market report software vs. a prompt

The software category is not bad; it is built for a world where the data arrived as a PDF once a month and charts were images. Here is where the two approaches actually differ:

	Typical market report software	AI market report in Homies
Data freshness	Last month's numbers, refreshed on the vendor's schedule	Loaded the day CREA and TRREB publish — the August release was live within hours
Charts	Static images in a PDF or a templated page	Live embeds: hover for values, zoom any window, toggle series
Coverage	Your board, sometimes your province	Every Canadian board, province, GTA municipality and home type, plus rates and inflation on the same timeline
Branding	Logo and colours in a fixed template	Your name, brokerage and palette on every chart; the report reads in your voice for your audience
Lead capture	Usually a separate tool	A gated preview with the Homies lead-capture form built in
Social	Not included	Instagram carousel or story generated from the same charts, staged for approval
Cost	A monthly subscription	The data and charts are free; the report is one prompt in Homies

The honest caveat: an AI report is only as good as the feed and the prompt behind it. That is why the prompt below names its data sources by endpoint, forbids invented numbers, and requires the live embeds rather than letting the assistant draw its own charts — every rule in it was added after a real run went wrong.

The prompt

How to make one in four minutes

The prompt is complete. It carries the route map for every Canadian market, the data endpoints, the embed recipes, the two-tier lead funnel and the Instagram steps. The walkthrough below runs the GTA version end to end; the national version is the same flow with a different market.

Watch it run4 min · start to published report

1
Copy the prompt
It's complete — market list, data endpoints, chart embeds, funnel and social steps are all in it.
2
Paste it into Homies
Or any AI assistant with web access. It fetches the live feed, then asks four questions and waits.
3
Answer four questions
Your market, your audience, open or gated, and whether you want Instagram assets.
4
Review, then publish
You get the report with live charts, the email teaser and the social assets — nothing is sent or posted until you say so.

The prompt · v1 — September 15, 2026

MONTHLY MARKET REPORT FROM LIVE DATA (powered by homiesAI.com). You will build me
(a realtor) a personalized, SEO-optimized housing market report with LIVE EMBEDDED
charts for any Canadian market — national, provincial, or one of 100+ real estate
boards — using real numbers from the Homies Stats data feed. Optionally add a
lead-capture funnel and Instagram assets. Never invent a number — every figure
must come from the feed.

URL BASE — read this first. Everywhere below, {BASE} means:
  https + :// + homiesai.com + /stats   (join the four parts, no spaces)
Spelled out in case a chat app stripped it: homiesai dot com slash stats, over
https. Example: {BASE}/data/manifest.json means the manifest URL on that base.
Chat apps sometimes delete or relocate full URLs — if anything below looks like
it's missing a link, rebuild it from {BASE}. Use no other host.

ROUTE MAP — two datasets, never cross them:
  A. CREA (all of Canada). Slugs come from {BASE}/data/manifest.json — national
     is canada-computed; provinces are ontario, british-columbia, alberta,
     quebec, saskatchewan, manitoba, nova-scotia, new-brunswick,
     newfoundland-and-labrador, prince-edward-island; boards include toronto,
     greater-vancouver, fraser-valley, victoria, calgary, edmonton, ottawa,
     winnipeg, halifax-dartmouth, hamilton-burlington, kitchener-waterloo,
     london-and-st-thomas, regina, saskatoon and ~80 more.
     Measures: ap (average price), us (unit sales), nl (new listings),
     al (active listings), snlr, moi. Routes: {BASE}/explore, /compare,
     /overlay, /yoy, /macro, /balance, /seasonality, /leaderboard.
  B. TRREB (GTA municipalities only): {BASE}/trreb with its own slugs
     (all-trreb-areas, mississauga, vaughan…) and measures (sales, ap, nl…).
Resolve every slug from the manifest before using it. If a chart renders an
empty "Loading series…" shell, your slug, route or measure key is wrong —
FIX THE URL. Never fall back to drawing a chart.

STEP 1 — ASK ME FOUR QUESTIONS (then wait):
1. Which market? Canada, a province, or a board (any from the manifest). If I
   don't answer, default to Canada (canada-computed).
2. Who is the report for? first-time buyers · investors · move-up families ·
   downsizers · sellers · general audience. Default: general.
3. Lead capture: one open report, or a two-tier funnel — a public PREVIEW
   (about the first 30%) ending in a "sign up to read the full report" box that
   gates the complete version? Default: open.
4. Promotion: Instagram carousel, Instagram story, both, or none? Default: none.

STEP 2 — GET THE DATA. Points are [yyyymm, value] arrays. Try in this order:
1. Your web/URL-fetch tool (NOT code execution — some AI sandboxes block outside
   domains from code; the web-fetch tool usually works even when code can't).
2. Code GET only if your sandbox has open internet access.
3. If neither works, use the {BASE}/api/chart image URLs from STEP 4 and read
   the headline numbers I paste to you.
4. Last resort: ask me to open a URL in my browser and paste the JSON here.
Endpoints (all on {BASE}):
- {BASE}/data/manifest.json — every geography with slug, name, level, and the
  latest month (a "preliminary" flag means the newest month came from CREA's
  press release ahead of the full package).
- {BASE}/data/{slug}.json — series keyed "res.act.ap", "res.act.us",
  "res.act.nl", "res.act.al", "res.act.snlr", "res.act.moi" (residential,
  actual / not seasonally adjusted — the same basis as CREA's board tables).
- {BASE}/data/measure/res.act.ap.json — one measure for every geography at
  once, for rankings.
- {BASE}/data/macro/all.json — rate-mortgage5y, rate-overnight, cpi,
  unemp-canada, ei-canada, mortgage-originations-variable-share.
Compute: latest month's sales, average price, new listings + year-over-year %
for each; SNLR and months of inventory; where the average price sits vs the
market's peak (find the max and its date); and the price INDEXED to January
2022 = 100 (latest ÷ Jan-2022 × 100) — that single number tells the whole
post-peak story for any market.

STEP 3 — WRITE THE REPORT (blog post, 700-1000 words, SEO-optimized):
- H1: "{Market} Housing Market Report — {Month Year}". Meta description ≤155
  chars with the market name, month, and one headline stat.
- Big KPI statements as H2 headings, plain English: "Prices are down 3.1% from
  last year", "Sales fell 7% while listings rose", "Still 19% below the peak".
  Every number from STEP 2.
- One paragraph placing my market against the country: is it one of the
  markets still above its 2022 level, or one still repairing? (Use the indexed
  number and the leaderboard embed.)
- Tailor the narrative to my audience (Q2): what this month means for THEM,
  what to do next, one honest risk. Factual — no hype.
- Close with a 3-question FAQ answered with the data ("Is {market} a buyer's
  market right now?").

STEP 4 — EMBED THE LIVE CHARTS. NON-NEGOTIABLE:
- The published report MUST use these live embeds. NEVER hand-draw charts — no
  SVG, no CSS bars, no canvas, no image generation. A hand-drawn chart is
  stale the day it ships and fails this task.
- Before publishing, fetch one embed URL and confirm it returns the chart page;
  if not, fix the URL (ROUTE MAP). If a chart truly cannot be embedded, use
  the {BASE}/api/chart PNG for it and tell me which one and why.
Swap {slug} for my market; append &embed=1 to every one:
<iframe src="{BASE}/explore?g={slug}&m=us,nl&from=201901&embed=1" style="width:100%;height:440px;border:0"></iframe>
<iframe src="{BASE}/compare?g={slug},canada-computed&m=ap&base=202201&embed=1" style="width:100%;height:440px;border:0"></iframe>
<iframe src="{BASE}/overlay?g={slug}&m=us&embed=1" style="width:100%;height:440px;border:0"></iframe>
<iframe src="{BASE}/macro?g={slug}&m=us&x=rate-mortgage5y&inv=1&mode=dual&from=201501&embed=1" style="width:100%;height:440px;border:0"></iframe>
<iframe src="{BASE}/yoy?g={slug}&m=ap&from=202001&s=line&embed=1" style="width:100%;height:440px;border:0"></iframe>
Optional extras: {BASE}/leaderboard?m=ap&mode=yoy&prov=1&embed=1 (every
market ranked by price change), {BASE}/explore?g={slug}&m=moi&from=200501&embed=1
(months of inventory), and for GTA municipalities {BASE}/trreb?v=trend&g={trreb-slug}&m=ap&m2=sales&embed=1.
For email or social use static images:
{BASE}/api/chart?view=explore&g={slug}&m=ap&from=201501&credit={my name}

STEP 5 — TWO-TIER LEAD FUNNEL (only if I chose it in Q3): publish TWO pages.
(a) The FULL report at its own URL. Never post or DM this link publicly.
(b) A PREVIEW page: the hook KPI, the FIRST LIVE EMBED and the first section —
    about 30% of the report — ending in a "Sign up to read the full report" box
    built with the Homies built-in lead-capture form (name, email, phone). Do
    NOT wire any external forms API. If the form supports a success redirect,
    send subscribers straight to the full report; if not, be honest about the
    gate — reveal the full-report link in the form's post-submit state, never
    before.
Distribute ONLY the preview URL. Report back: both URLs, the form name/ID,
which gate path you used, and confirmation that leads land in my Homies lead
warehouse.

STEP 6 — INSTAGRAM ASSETS (only if I chose them in Q4).
SIZING — never block on this: use whatever aspect ratio your image renderer
supports. Prefer portrait (4:5, 3:4 or 2:3); square is fine. If a ratio is
refused, retry with the next supported one and tell me which you used — never
hold, skip or postpone the assets over sizing. Keep every slide the SAME ratio.
Design: one flat background, ONE accent color, giant plain-English stat
headline, my name + brokerage + handle small in a corner, charts pulled from
the feed as {BASE}/api/chart images with credit={my name} — never hand-drawn.
Full numbers (37,504 — not 37.5K). Attribution on every asset:
"Data: CREA · Bank of Canada | homiesAI.com".
- CAROUSEL (4-6 slides): slide 1 = hook stat in huge type, middle slides = one
  chart + one-line takeaway each, final slide = "Want the full breakdown?
  Comment REPORT or tap the link in bio" + my contact.
- STORY (portrait): top third headline, chart middle, link-sticker placeholder
  pointing at the report at the bottom.
Both link to the report — the PREVIEW URL if gated, the report URL otherwise.
Caption: hook first line, ≤5 hashtags, CTA to the link. Show me everything and
WAIT for my approval before posting anything.

STEP 7 — DELIVER: the finished report (title, meta description, body with the
live embeds in place), the funnel URLs and form details if gated, the Instagram
assets and caption if requested, and a 3-sentence email teaser linking to the
report. Attribution line on the report, exactly: "Data: CREA · Bank of Canada
| homiesAI.com". Then ask me what to do next: publish, send the email, post the
carousel/story, or adapt it for another market.

Timing

When Canadian housing stats come out

A market report is only current if it is sent after the data lands. These are the releases that move the feed; build your sending schedule around them.

CREA national statistics

Around the 15th of each month

The next package is scheduled for October 16, 2026.

TRREB Market Watch

The first week of each month

August's release came September 3.

Bank of Canada rate decisions

Eight scheduled dates a year

Announcements move the mortgage-rate series the same day.

Statistics Canada CPI

Mid-month

Feeds the inflation series and the real-rate story.

Labour Force Survey

Early each month

Employment and unemployment by province, the demand-side backdrop.

Questions

Frequently asked

What is an AI market report for real estate?

A market report written and assembled by an AI assistant from a live housing-data feed rather than from a template and last month's PDF. In Homies, one prompt pulls the latest CREA, TRREB and Bank of Canada figures for your market, writes the narrative for your audience, embeds interactive charts, and can add a lead-capture gate and Instagram assets.

Is the Canadian real estate data free?

Yes. Homies Stats serves every series as plain JSON with no API key — 104 CREA markets, 41 TRREB regions, and 222 macro series — plus rendered chart images you can brand with a credit line. Board-level figures remain subject to CREA's data licensing for republication.

Which markets are covered?

All of Canada at the board level (91 boards), every province and territory, the national series, and the Greater Toronto Area by municipality and home type. If you can name the board, the prompt can build the report.

How is this different from market report software?

Market report software typically renders last month's numbers into a fixed template as a static PDF or page, for a monthly subscription. An AI market report is generated on request from live data, uses interactive charts, and is tailored to a specific audience — first-time buyers, investors, sellers — in your own voice.

Can I brand the charts?

Yes. Every embed carries your credit line, and the chart-image API accepts a credit parameter and a palette so social assets match your brokerage colours.

Does it capture leads?

If you choose the two-tier option, the prompt publishes a public preview — roughly the first 30% of the report — ending in a sign-up box built with the Homies lead-capture form. Leads land in your Homies warehouse before the full report is revealed.

Planning and legal notice

Data sourced from CREA aggregate statistics, TRREB Market Watch, the Bank of Canada and Statistics Canada, visualized by Homies Stats — an independent tool not affiliated with or endorsed by CREA or TRREB. MLS® and the associated logos are trademarks of the Canadian Real Estate Association. Information, not investment advice.