12-Month Projected Dividend Cash Flow Schedule

Expected cash arrival by month with exact REIT payout distributions.

Weekly Cash Flow Velocity How cash hits your account across the month

Federal Reserve FOMC & High-Impact US Macro Calendar

Live streaming institutional feed of Fed meetings, interest rate decisions, inflation gauges (CPI/PCE), nonfarm payrolls, and Treasury auctions.

Embedded Financial Modeling Engine: =REITWAVE(...)

Turn REITwave into an integral underwriting engine inside your Excel and Google Sheets financial models. Pull live AFFO yields, consensus NAVs, implied cap rates, occupancy, and debt multiples across 207 US REITs directly into your spreadsheet cells with zero copy-pasting.

1. Open any spreadsheet in Google Sheets.
2. Click Extensions → Apps Script in the top menu.
3. Paste the REITwave JavaScript code below and click Save (Ctrl+S).
4. Type =REITWAVE("O", "AFFO_YIELD") in any cell!

function REITWAVE(ticker, metric, apiKey) {
  if (!ticker || !metric) return "#N/A: Missing ticker or metric";
  var cleanTicker = ticker.toString().trim().toUpperCase();
  var cleanMetric = metric.toString().trim().toUpperCase();
  var cache = CacheService.getScriptCache();
  var cacheKey = "rw_" + cleanTicker + "_" + cleanMetric;
  var cachedVal = cache.get(cacheKey);
  if (cachedVal !== null) {
    var num = Number(cachedVal);
    return isNaN(num) ? cachedVal : num;
  }
  var url = "https://reitwave.com/api/sheets/quote?ticker=" + encodeURIComponent(cleanTicker) + 
            "&metric=" + encodeURIComponent(cleanMetric) +
            (apiKey ? "&api_key=" + encodeURIComponent(apiKey) : "");
  try {
    var response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
    if (response.getResponseCode() !== 200) {
      return "#ERROR: " + response.getContentText();
    }
    var data = JSON.parse(response.getContentText());
    cache.put(cacheKey, data.value.toString(), 600);
    var num = Number(data.value);
    return isNaN(num) ? data.value : num;
  } catch (err) {
    return "#ERR: Connection failed";
  }
}

1. Download the REITwave Excel Manifest (.xml).
2. Open Excel Online or Excel Desktop → Click Insert → Add-ins.
3. Select Upload My Add-in and select the downloaded manifest.xml file.
4. In any workbook cell, enter =REITWAVE("PLD", "PRICE")!

Multi-dimensional institutional matrix plotting debt rollover risk across commercial real estate sectors and maturity vintages.

Continuous stream visualizing how REIT sectors flow, expand, and contract over multi-year macroeconomic cycles (Data Centers & Logistics vs Office/Malls).

Five-number statistical distribution (Min, Q1, Median, Q3, Max & Outliers) calculated dynamically across all 207 US REITs and 2,443 commercial assets.