| =LATAVIS.PC.IMPAIRMENT_SCORE(deal_id, [facility_type]) | Impairment score for a private credit borrower: the chance a BDC lender first files its loan on non-accrual within two quarters (PCSC, real data, not validated; not a probability of default). Returns: score (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.PD(deal_id, [facility_type]) | Alias of PC.IMPAIRMENT_SCORE (the same score; kept so existing workbooks keep working). Not a probability of default. Returns: score (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.LGD(deal_id, [facility_type]) | Loss given default for a private credit facility. Returns: fraction (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.EXPECTED_LOSS(deal_id, [facility_type]) | Impairment-weighted loss in $mm (score x LGD x exposure) — illustrative, not a loss estimate (ENG2-001). Returns: USD millions. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.DSCR(deal_id, [facility_type]) | Debt service coverage ratio. Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.UW_PD(spread_bps, [facility_type], [principal_mm]) | Disclosed-impairment score for a deal you are underwriting now (scores features, not a panel entity). Concurrent classification, no forward window; it is not a probability of default. Returns: score (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.UW_LGD([facility_type]) | Loss given default implied by a facility type's lien seniority. Returns: fraction (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.UW_EXPECTED_LOSS(spread_bps, [facility_type], [principal_mm], [facility_size_mm]) | Impairment-weighted loss ($MM, score x LGD x facility) on a deal you are underwriting now — illustrative, not a loss estimate (ENG2-001). Returns: USD millions. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.LENDER_MARK_SPREAD(borrower) | Spread between the BDC lenders' marks on a borrower, latest quarter (SEC BDC Data Sets; no accuracy claim). Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.LENDER_COUNT(borrower) | BDC lenders marking a borrower, latest quarter (SEC BDC Data Sets). Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.COLENDER_TEST_RATIO() | Pre-registered co-lender gap forecast: error vs no change (failed: >1). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.NONACCRUAL_LENDERS(borrower) | BDC lenders carrying a borrower on non-accrual, each at its latest parsed 10-K/10-Q (SEC EDGAR). Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.NONACCRUAL_FIRST_QUARTER(borrower) | First quarter-end any BDC lender carried a borrower on non-accrual (YYYYMMDD). Returns: date. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.BELOW90_NONACCRUAL_15M() | Share of BDC debt positions first marked below 90 of par that reach non-accrual within 15 months (every filer whose status is read). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.FORECAST_BELOW80(borrower) | Probability a BDC borrower is marked below 80% of cost within two quarters (claim PCMD); passing out of sample (L3), not graded live before deploy; a stale input returns '— check, not a forecast — inputs end <date>'. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PC.CLAIM_RECORD(claim, [field]) | A registered private credit claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.ESG_SCORE(country) | Country ESG composite — NOT SERVED: no licensable country ESG source is loaded, so the cell returns an error naming why (never a number). Returns: score 0-100. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.GDP_GROWTH(country) | Real GDP growth, year on year (latest observation). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.INFLATION(country) | Consumer price inflation, year on year (latest). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.UNEMPLOYMENT(country) | Unemployment rate (latest). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.POLICY_RATE(country) | Central-bank policy rate (latest). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.TAYLOR_RATE(country) | Taylor (1993) rule policy rate on real inputs. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.TAYLOR_GAP(country) | Policy rate minus Taylor-rule rate (pp). Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.DEBT_GDP(country) | General government gross debt, % of GDP (IMF WEO actual). Returns: % of GDP. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.R_MINUS_G(country) | Interest rate minus nominal GDP growth (pp). Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.FISCAL_GAP(country) | Primary balance minus debt-stabilising balance (pp of GDP). Returns: pp of GDP. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.CURRENT_ACCOUNT(country) | Current-account balance, % of GDP (latest). Returns: % of GDP. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.SANCTIONS_EXPOSURE(country) | OFAC SDN listings under sanctions programmes named for the country. Returns: listings. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.GHGRP_FACILITIES(company) | US facilities reporting to EPA GHGRP under a parent company. Returns: facilities. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.CB_TONE_CHANGE(bank) | Change in central-bank statement tone since the previous statement (US / EA). Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.CB_TONE_NEXT_MOVE_HIT_RATE(bank) | Pre-registered test: statement tone sign vs the next meeting's move (US / EA). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MA.CLAIM_RECORD(claim, [field]) | A registered macro esg claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.FAIR_VALUE(code) | Fair value price for a commodity (NOT SERVED: needs a licensed futures curve and EIA/USDA balance sheets — returns a blank with the reason). Returns: price. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.SPOT(code) | Latest real reference price: EIA daily spot for CL/BZ/NG/NGF (the energy reader Energy uses); World Bank Pink Sheet monthly average otherwise - the cell's reference_kind and unit say which. Returns: price. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.MISALIGNMENT(code) | Price misalignment vs fair value (NOT SERVED: depends on fair value). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.SEASONAL_PROB_UP(code) | P(next month's average price > this month's) — seasonal base rate, walk-forward gated per market. Returns: probability (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.COT_PROB_UP(code) | COT positioning P(price up, next month) — served only for gauntlet-validated markets. Returns: probability (0-1). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.SEASONAL_80_HIT_RATE() | Out-of-sample hit rate of '80%-reliable' 15-year seasonal calls, pooled since 1990. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.SEASONAL_MARKET_HIT_RATE(market) | A market's out-of-sample hit rate of its 80%-reliable 15-year seasonal calls. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.FORECAST_MOVE_SIZE(market) | Next month's move size of a commodity market, 1 s.d. of the log price change (claim CMVOL, CM-MOVE-SIZE-1M); FAILED its one pre-registered re-run on 2026-11-03 (VERT-CM D-2125): no accuracy claim, so the cell refuses with the record's verdict - no number. Returns: % (1 s.d.). L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CM.CLAIM_RECORD(claim, [field]) | A registered commodities claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.SPOT(pair) | Spot rate, quote currency per base (ECB reference rate). Returns: rate. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.POLICY_RATE_DIFF(pair) | Carry: base minus quote central-bank policy rate (BIS), pp. Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.REALIZED_VOL(pair) | 3-month realised volatility, annualised (ECB spot). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.VOL_PERCENTILE(pair) | Today's 3-month realised vol vs its own 10-year history (percentile). Returns: percentile 0-100. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.REER_MISALIGNMENT(pair) | Real misalignment: base minus quote BIS REER deviation from 10-year means, pp (valuation context; reversion tested, does not beat a random walk). Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.PPP_RATE(pair) | PPP rate from World Bank WDI PPP conversion factors. Returns: rate. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.PPP_GAP(pair) | Spot vs PPP, % (+ = base dear at purchasing-power parity). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.COT_LEV_NET(pair) | CFTC leveraged-funds net position in the pair's CME future (contracts). Returns: contracts. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.COT_Z(pair) | CFTC leveraged-funds net vs its last 3 years (z-score). Returns: z. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.IMPLIED_VOL(pair) | ATM implied volatility — NOT SERVED: no option-vol feed is loaded, so the cell returns an error naming why (never a number). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.COMPOSITE(currency) | Positioning x carry x value composite vs USD (pre-registered; honest negative, no accuracy claim). Returns: z. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.FORECAST_VOLATILITY(currency) | Next month's realised volatility of a G10 currency against the US dollar, annualised (claim FXVOL, FX-RVOL-1M); passing out of sample (L3), not graded live before deploy; a stale input returns '— check, not a forecast — inputs end <date>'. Returns: % a year. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FX.CLAIM_RECORD(claim, [field]) | A registered fx claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.FAIR_VALUE(ticker) | Residual-income value per share from the latest SEC filings (book value + PV of excess return on equity; a model valuation, not a price target). Returns: price per share. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.UPSIDE(ticker) | Value vs today's price — NOT SERVED: no licensed price feed, so the cell returns an error naming why (never a number). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.BETA(ticker) | Market beta — NOT SERVED: needs a daily price history, which no licensed feed provides; the cell returns an error naming why. Returns: beta. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.EARNINGS_POWER(ticker) | Earnings power value per share (TTM diluted EPS / cost of equity). Returns: price per share. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.BOOK_VALUE_PS(ticker) | Book value per share (latest balance sheet). Returns: USD per share. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.ROE(ticker) | Return on equity, trailing 12 months. Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.EPS(ticker) | Diluted EPS, trailing 12 months (10-K + 10-Q year to date). Returns: USD per share. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.REVENUE(ticker) | Revenue, trailing 12 months. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.FILED_PRICE(ticker) | Quarter-end price reported in 13F filings (median value/shares across filers; dated, not live). Returns: USD per share. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.INST_OWNERSHIP(ticker) | Shares held by 13F institutional filers / shares outstanding. Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.FAILS_TO_DELIVER(ticker) | Fails to deliver, latest day in the SEC file. Returns: shares. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.COST_OF_EQUITY(ticker) | Cost of equity: 10-year Treasury + 5% equity risk premium at beta 1 (stated parameters). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.CROWDING_FILER_CHANGE(security) | Change in 13F filers holding a security between the two newest periods (amendments applied). Returns: filers. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.CROWDING_FAILS_BPS(security) | Mean daily SEC fails as basis points of 13F-held shares. Returns: bps. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EQ.CLAIM_RECORD(claim, [field]) | A registered equities claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.PAR_YIELD(tenor) | Treasury par yield at a tenor (latest published). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.YTM(tenor) | Yield to maturity of the par Treasury at a tenor (= its par yield). The pre-2026-10-20 ISIN form read fictional sample bonds and is refused. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.ZERO_RATE(tenor) | Zero-coupon rate from the fitted Treasury curve (1Y/2Y/5Y/10Y/30Y). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.FORWARD_5Y5Y() | 5-year Treasury rate 5 years forward, implied by the fitted curve. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.SLOPE_2S10S() | Treasury curve slope, 10Y minus 2Y par yield. Returns: basis points. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.DURATION(tenor) | Modified duration of the par Treasury at a tenor. Returns: years. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.CONVEXITY(tenor) | Convexity of the par Treasury at a tenor. Returns: years^2. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.DV01(tenor) | DV01 of $1mm face of the par Treasury at a tenor. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.VAR_99(tenor) | 1-day 99% historical VaR of $1mm face of the par Treasury at a tenor. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.OAS(index) | Rating-bucket option-adjusted spread (IG, BBB, HY, CCC) - NOT SERVED: the only daily source (ICE BofA) is licence-blocked and no licence-clear one exists; the cell returns an error naming why. Licence-clear: FI.GZ_SPREAD, FI.CMDI. Returns: basis points. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.OAS_PERCENTILE(index) | Where a rating-bucket OAS sits in its own history - NOT SERVED (no licence-clear source; the cell returns an error naming why). Licence-clear: FI.CMDI_PERCENTILE. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.GZ_SPREAD() | Corporate bond credit spread, Federal Reserve Board Gilchrist-Zakrajsek (monthly, all ratings, senior unsecured non-financial bonds) - not a rating-bucket OAS. Returns: basis points. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.EXCESS_BOND_PREMIUM() | Excess bond premium, Federal Reserve Board: the part of the GZ spread not explained by expected default risk (monthly). Returns: basis points. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.CMDI(index) | Corporate bond market distress, New York Fed CMDI (0-1, higher = more distress; weekly): MARKET, IG or HY - a market-functioning index, not a spread. Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.CMDI_PERCENTILE(index) | Where the New York Fed CMDI (MARKET, IG or HY) sits in its own weekly history (percentile). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.BREAKEVEN(tenor) | TIPS breakeven inflation at a tenor (5Y, 7Y, 10Y, 20Y, 30Y). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.REAL_YIELD(tenor) | TIPS real par yield at a tenor (5Y, 7Y, 10Y, 20Y, 30Y). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.SWAP_RATE(tenor) | SOFR swap rate at a tenor — computed from public SDR prints; returns an error naming why while the source licence is unresolved. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.MORTGAGE_RATE() | 30-year fixed mortgage rate (Freddie Mac PMMS via FRED). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.LEVERAGE(issuer) | Issuer total liabilities / total assets (SEC XBRL, latest filing). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.EBIT_TO_ASSETS(issuer) | Issuer last-fiscal-year EBIT / total assets (Altman X3). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.ALTMAN_Z(issuer) | Altman Z-score — returns an error naming the XBRL tags not yet loaded (working capital, retained earnings); never a number without them. Returns: score. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.MERTON_PD(issuer) | Merton 1-year default probability (risk-neutral) from 13F quarter-end prices, SEC XBRL shares and liabilities and the 1-year Treasury; an error naming why when an input is missing. Returns: probability. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.VAR_COVERAGE_FICC_WINDOW(tenor) | Share of days the 1-day 99% VaR held over FICC's disclosure window (2025-07-01 to 2026-06-30). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.VAR_EXCEPTIONS_250D(tenor) | 1-day 99% VaR exceptions in the last 250 business days (Basel zone). Returns: days. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.FORECAST_YIELD_VOLATILITY(tenor) | Next month's realised volatility of the 10-year Treasury yield in basis points, the square root of the sum of squared daily changes (claim FITVOL, FI-TVOL-1M, INTEL-4); passing out of sample (L3), not graded live before deploy; a stale input returns '— check, not a forecast — inputs end <date>'. Returns: bp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.FI.CLAIM_RECORD(claim, [field]) | A registered fixed income claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.LCOE(technology) | Levelized cost of electricity, 2025, without tax credits (NREL ATB 2025, Moderate, 30-yr). Returns: USD/MWh. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.LCOE_2030(technology) | Levelized cost of electricity, 2030 projection published by NREL ATB 2025 (no tax credits). Returns: USD/MWh. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.SPOT(fuel) | Latest EIA spot price for a fuel / hub (World Bank monthly for NG_EUROPE, LNG_JAPAN, COAL_AUSTRALIA). Returns: price. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.CRACK_321([crack]) | 3-2-1 crack spread from same-day EIA spot prices, $/bbl (observed margin; reversion tested, does not beat a random walk). Returns: USD/bbl. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.DEMAND(ba) | Electricity demand on the latest complete day (EIA-930), MWh. Returns: MWh. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.GAS_SHARE(ba) | Natural-gas share of generation, last 30 days (EIA-930), %. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.RENEWABLE_SHARE(ba) | Wind + solar + hydro share of generation, last 30 days (EIA-930), %. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.GAS_FUEL_COST() | Gas-fired fuel cost at today's Henry Hub x the EIA-923 gas heat rate, $/MWh (merit-order input, not a power price). Returns: USD/MWh. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.STORAGE_VS_5Y() | Lower-48 working gas vs its 5-year same-week average, % (context; storage signal tested, honest negative). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.PRICE_DECK([fuel]) | SEC reserves price deck: 12-month first-day-of-month average (WTI or HH). Returns: price. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.POWER_PRICE(ba) | Wholesale power price (LMP) — NOT SERVED: no licensed ISO/vendor price feed is loaded, so the cell returns an error naming why (never a number). Returns: USD/MWh. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.NET_LOAD_RAMP(balancing_authority) | Median daily 3-hour net-load ramp, last 90 days (EIA-930). Returns: MW. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.RAMP_GAS_SHARE(balancing_authority) | Share of the daily net-load ramp met by natural gas, median day (EIA-930). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.FORECAST_RAMP(ba) | Probability tomorrow's max 3-hour net-load ramp is above its 30-day median (claim ENRP); passing out of sample (L3), not graded live before deploy; a stale input returns '— check, not a forecast — inputs end <date>'. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.EN.CLAIM_RECORD(claim, [field]) | A registered energy claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.TSI_FREIGHT() | BTS Transportation Services Index, freight (latest month). Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.TSI_FREIGHT_YOY() | TSI freight, % change on the same month a year earlier. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.TSI_FREIGHT_NEXT() | TSI freight next month: median of the 80% band. Backtest FAILS (no accuracy claim, L1); a band whose target month is already published is labelled a check. Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.MODE_VOLUME(mode) | BTS freight volume index for a mode (TSI component). Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.MODE_VOLUME_YOY(mode) | Mode volume index, % change on a year earlier. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.TRUCK_EMPLOYMENT() | Truck transportation employment, thousands (BLS CES). Returns: thousand jobs. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.WAREHOUSE_EMPLOYMENT() | Warehousing & storage employment, thousands (BLS CES). Returns: thousand jobs. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.SUPPLY_CHAIN_PRESSURE() | NY Fed Global Supply Chain Pressure Index (attributed). Returns: std dev. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.PORT_TEU(port) | US port loaded international container throughput (imports + exports, no empties), TEU, latest calendar year (BTS). Returns: TEU. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.PORT_TEU_YOY(port) | US port loaded international container throughput, % change on the prior year (BTS). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.PORT_HURRICANE_FREQ(port) | Share of 1991-2025 seasons with a hurricane within 150 km of the port (NOAA HURDAT2) — a historical frequency, not a forecast. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.OPERATING_RATIO(carrier) | Carrier operating ratio, latest fiscal year (SEC XBRL; error naming the gap when revenue is not tagged for that year). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.PEER_OPERATING_RATIO(carrier) | Median operating ratio of the carrier's mode peers (SEC XBRL). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.SPOT_RATE() | Truckload dry-van spot rate — returns an error naming why (no licensed rate series; DAT / Truckstop are paid). Returns: USD/mile. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.OCEAN_RATE() | Container spot rate Shanghai-USWC — returns an error naming why (no licensed series). Returns: USD/FEU. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.HURRICANE_TONNAGE_GAP() | Tonnage change in hurricane-passage years minus other years, all ports (BTS x HURDAT2). Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.BTS_EXPOSURE_RANK_CORR() | Rank correlation of BTS's port hurricane exposure with observed passages. Returns: rho. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.HURRICANE_GAP_BTS_EXPOSED() | Tonnage change in passage years minus other years at the ports BTS rates most exposed. Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.LG.CLAIM_RECORD(claim, [field]) | A registered logistics claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.FORMD_NEW_FUNDS() | New private-equity fund offerings (SEC Form D), trailing 12 months to the latest filing. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.FORMD_CAPITAL_SOLD() | Capital reported sold by those new PE fund offerings (Form D). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.FORMD_YOY() | New PE fund offerings vs the prior 12 months (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.SBIC_LICENSEES() | SBA SBIC licensees on the roster. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.SBIC_CAPITAL() | Combined fund size of SBIC licensees. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.COST_OF_DEBT() | Market cost of sponsor-backed first-lien debt (SOFR + median BDC first-lien spread). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.BDC_MARK([scope]) | First-lien debt marked at, % of cost, in the latest BDC 10-Q schedules. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.NONACCRUAL([scope]) | Debt on non-accrual, % of cost, in the latest BDC 10-Q schedules. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.MARKED_DOWN([scope]) | Share of sponsor-backed borrowers marked below 90% of cost. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.DEBT_CAPACITY(company) | LBO debt capacity at 2.0x EBIT interest cover and today's market cost of sponsor debt. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.EBIT_MARGIN(company) | EBIT margin, last fiscal year (SEC XBRL). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.REVENUE_GROWTH(company) | Revenue growth, last fiscal year (SEC XBRL). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.LEVERAGE(company) | Long-term debt / EBIT, leverage turns (SEC XBRL). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.SPONSOR_CAPITAL(sponsor) | Capital reported sold across a listed sponsor's Form D fund vehicles. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.SPONSOR_13F(sponsor) | A listed sponsor's reported 13F holdings value (latest quarter). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.FUND_RAISED(fund) | Capital a fund reports sold to date on its latest Form D. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.TVPI(fund) | TVPI — a BDC ticker returns one share's TVPI over about five years (real holding period printed; year-to-date distributions differenced to the quarter); a Form D fund a public pension reports returns that LP's own TVPI (CalPERS, CalSTRS, Oregon PERF or WSIB, strict same-fund name match, the newest report); any other fund returns an error naming why. Returns: multiple. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.PME(fund) | Kaplan-Schoar PME vs the S&P 500 total return (Vanguard 500 Index Fund, SEC N-PORT) — a BDC ticker's over about five years; a Form D fund a public pension reports in two or more quarterly reports gets a WINDOW PME of that LP's position (differenced quarterly flows, not since inception); any other fund returns an error naming why. Returns: multiple. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.FAIR_VALUE(company) | Equity fair value of a company — returns an error naming why (no transaction or market price is loaded; an assumed price would be invented). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.IRR(fund) | Net IRR of a fund — the IRR a public pension LP reports for it (strict same-fund name match; CalPERS, CalSTRS, Oregon PERF, WSIB); otherwise an error naming why. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.ENTRY_MULTIPLE(company) | EV / EBITDA of a company — returns an error naming why (no share price or D&A loaded). Returns: multiple. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.GROUP_MARKED_DOWN(industry_group) | BDC positions marked below 90% of cost in an industry group, latest quarter (every reporting BDC). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.PE.CLAIM_RECORD(claim, [field]) | A registered private equity claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.RATE_BASE(owner) | Net plant in service at fiscal year end — for a regulated utility the published rate-base proxy (not the rate base), for other owners an asset-base proxy (SEC 10-K XBRL). Returns: USD bn. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.EARNED_RETURN(owner) | Consolidated operating return on net plant: operating income of all segments / average net plant, pre-tax — not the regulator's earned or allowed ROE (SEC 10-K XBRL). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.RETURN_SPREAD(owner) | Operating return on plant minus today's BBB corporate yield (FRED), bp. Returns: bp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.COST_OF_DEBT(owner) | Embedded cost of debt: interest / average total debt (SEC 10-K XBRL). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.DSCR(owner) | Cash debt-service cover, issuer level (includes refinancing): (operating cash flow + interest paid) / (interest paid + all debt repaid in the year), fiscal year — not a project-finance DSCR (SEC 10-K XBRL). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.SCHEDULED_DSCR(owner) | Scheduled debt-service cover, issuer level: (operating cash flow + interest paid) / (interest paid + long-term principal due in the next 12 months per the filed maturity ladder) (SEC 10-K XBRL). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.INTEREST_COVER(owner) | Cash interest cover: (operating cash flow + interest paid) / interest paid (SEC 10-K XBRL). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.NET_DEBT_EBITDA(owner) | Net debt / (operating income + depreciation & amortisation) (SEC 10-K XBRL). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.LLCR(owner) | Loan-life cover ratio — NOT SERVED: needs a projected project cash-flow schedule issuers do not publish; the cell returns an error naming why (never a number). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.ALLOWED_ROE(owner) | Allowed return on equity of the newest approved rate order, as the utility tags it in its 10-K (SEC Financial Statement & Notes); where it is not tagged, or two same-date orders differ, the cell returns an error naming why (never a number). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.BBB_YIELD() | BBB corporate yield (10-year Treasury + BBB OAS) - NOT SERVED: the BBB OAS is ICE BofA's (licence-blocked) and no licence-clear BBB spread exists; the cell returns an error naming why. Licence-clear: IF.CORP_BOND_YIELD. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.CORP_BOND_YIELD() | Corporate bond yield today: 10-year Treasury + Federal Reserve Board GZ spread (all ratings; not a BBB yield). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.VMT() | US vehicle-miles travelled, last 12 months (FHWA Traffic Volume Trends), bn miles. Returns: bn miles. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.VMT_NOWCAST() | IF2 nowcast of US vehicle-miles for the next unpublished month (FHWA), bn miles — L1, no accuracy claim: beats seasonal naive (MAE -31%) but not a rolling AR(1) on YoY growth (+5% worse, DM p 0.73; re-graded 2026-10-22). Returns: bn miles. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.PUBLIC_CONSTRUCTION() | US public construction spending, latest month, SAAR (Census), $bn/yr. Returns: USD bn/yr. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.AIRPORT_PAX(airport) | Passengers boarding at an airport, last 12 months (BTS T-100). Returns: passengers. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.AIRPORT_VS_2019(airport) | Airport passengers, last 12 months as % of calendar 2019 (BTS T-100). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.TRANSIT_TRIPS(agency) | Transit agency unlinked passenger trips, last 12 months (FTA NTD). Returns: trips. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.TRANSIT_VS_2019(agency) | Transit ridership, last 12 months as % of calendar 2019 (FTA NTD). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.NRI_RISK(place) | FEMA National Risk Index score, 0-100 (context — the ranking claim was tested and is an honest negative). Returns: score. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.LOSS_RATE(place) | Expected annual building loss / building value, bp/yr (FEMA NRI). Returns: bp/yr. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.SEA_LEVEL_TREND(county) | Relative sea-level trend at the county's NOAA tide gauges, mm/yr. Returns: mm/yr. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.HURRICANES(county) | Hurricanes passing within 100 km since 1980 (NHC HURDAT2). Returns: storms. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.DISASTERS_10Y(county) | FEMA major-disaster declarations covering the county, last 10 years. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.LEASE_MONTHS_LEFT(lease) | Months from today to a federal lease's expiration; an expired lease returns an error naming the date (GSA IOLP). Returns: months. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.BTS_VMT_ESTIMATE() | BTS's preliminary VMT estimate for the month our nowcast targets. Returns: bn miles. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.VMT_VS_BTS_ERROR_GAP() | Our absolute % error minus BTS's, over the settled head-to-head months. Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IF.CLAIM_RECORD(claim, [field]) | A registered infrastructure claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.LOSS_RATIO(ticker) | Loss and LAE ratio, latest fiscal year (10-K XBRL), %. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.COMBINED_RATIO(ticker) | GAAP combined ratio (loss + underwriting expense), latest fiscal year, % — an error naming why when the carrier does not tag both expense lines. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.RESERVES(ticker) | Gross loss and LAE reserves at the latest fiscal year-end (10-K XBRL), USD. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.RESERVES_TO_PREMIUM(ticker) | Gross reserves / net premiums earned, latest fiscal year, x. Returns: x. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.INVESTMENT_YIELD(ticker) | Net investment income / average invested assets, latest fiscal year, %. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.PREMIUM_LEVERAGE(ticker) | Net premiums written / GAAP equity (not statutory surplus), x. Returns: x. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CAT_AAL(state) | Average annual reported storm damage in a state, NOAA Storm Events 1996.., CPI-adjusted USD. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CAT_1IN10(state) | 1-in-10-year annual NWS-recorded storm damage in a state (empirical; not an insured loss; calibration tested, no accuracy claim), USD. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CAT_1IN100(state) | 1-in-100-year annual reported storm damage (Pareto tail; refused in words when the tail is too heavy for the record), USD. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.NRI_EAL(fips) | FEMA National Risk Index expected annual loss, all hazards, for a county - FEMA's total: buildings + agriculture + people at a value of statistical life, USD. Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.FEMA_DISASTERS(fips) | FEMA major-disaster declarations naming a county since 1953. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.TREASURY([years]) | US Treasury constant-maturity yield (1, 2, 5, 10 or 30 years), %. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.ANNUITY_FACTOR([sex]) | Whole-life annuity-due factor at 65 (SSA 2023 period table, 10-year Treasury yield), x annual payment. Returns: x. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CATBOND_SPREAD() | Cat-bond spread — NOT SERVED: the ILS funds' Form N-PORT filings report principal, fair value and coupon, not spreads, and the Artemis list is licence-BLOCKED, so the cell returns an error naming why (never a number). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CATBOND_MARKS() | Cat-bond fund-reported marks index: principal-weighted price per 100 of the cat bonds the registered ILS interval funds hold, from their SEC Form N-PORT filings (the funds' own fair values, not trades). Returns: price. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.RBC_RATIO(ticker) | NAIC risk-based capital ratio — NOT SERVED: statutory data is not licensed, so the cell returns an error naming why (never a number). Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.REALISED_TO_MODELLED(state) | NOAA-recorded / FEMA NRI modelled annual loss, weather perils. Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.IL.CLAIM_RECORD(claim, [field]) | A registered insurance ils claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.TIER1_LEVERAGE(bank) | Tier 1 leverage ratio of a bank, latest call report (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.TOTAL_CAPITAL_RATIO(bank) | Total risk-based capital ratio of a bank (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.CET1_RATIO(bank) | Common equity tier 1 ratio of a bank (FFIEC RC-R, %). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.NPL_RATIO(bank) | Noncurrent loans as a share of loans (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.ROA(bank) | Return on assets, year-to-date annualised (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.NIM(bank) | Net interest margin, year-to-date annualised (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.EFFICIENCY_RATIO(bank) | Non-interest expense / revenue (FFIEC RI, %). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.LOANS_TO_DEPOSITS(bank) | Loans / deposits (FFIEC RC-C over RC, %). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.DEPOSIT_GROWTH(bank) | Deposit growth over four quarters (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.CRE_CONCENTRATION(bank) | CRE loans / total risk-based capital, supervisory definition (%; the guide is 300%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.CONSTRUCTION_CONCENTRATION(bank) | Construction & land loans / total risk-based capital (%; the guide is 100%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.FAILURE_RISK(bank) | Failure-risk screen: probability (%) the FDIC closes the bank within 12 months after its latest quarter is known (verification level as earned; see /accuracy). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.COST_OF_FUNDS(bank) | Interest expense / deposits, annualised (FFIEC RI, %). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.NIM_PASSTHROUGH(bank) | Net interest margin change per 1 pp of fed funds change since 2021-12-31 (FDIC + FRED). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.UNINSURED_SHARE(bank) | Uninsured deposits share — returns an error naming why (RC-O is not in the loaded file). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.BRANCHES(bank) | Offices of a bank in the FDIC Summary of Deposits. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.MARKET_OFFICE_HHI(market) | Office concentration (HHI on office shares) in a deposit market. Returns: index. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.INDUSTRY_NPL() | Noncurrent loans / loans, all US insured banks (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.INDUSTRY_ROA() | Return on assets, all US insured banks (%). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.EXPECTED_FAILURES() | Expected US bank failures over the screen's 12-month window. Returns: banks. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.FAILURES_12M() | US bank failures in the 12 months to the latest failure (FDIC). Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.FAILED_PROFILE_MATCHES(bank) | Measures (of 7) on which the bank is closer to the failed-bank median than to all banks. Returns: count. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.FAILED_PROFILE_BANKS() | US banks matching the failed-bank profile on at least 5 of 7 measures. Returns: banks. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.FORECAST_NPA_RISE(bank) | Probability a bank's nonperforming-assets ratio rises >= 0.25 pp next quarter (claim BKNP); passing out of sample (L3), not graded live before deploy; a stale input returns '— check, not a forecast — inputs end <date>'. Returns: %. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.BK.CLAIM_RECORD(claim, [field]) | A registered banking claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.PRICE(asset) | On-chain price (Uniswap v3 pool vs USDC, stated block) for BTC (WBTC) or ETH (WETH); other assets return an error naming why (no licensed price source). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.NETWORK_VALUE([asset]) | Bitcoin network value: on-chain price x protocol-scheduled supply (BTC only; other assets return an error naming why). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.HASHRATE() | Bitcoin network hash rate implied by difficulty and the last 2,016 blocks. Returns: EH/s. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.DIFFICULTY() | Bitcoin mining difficulty at the tip. Returns: difficulty. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.NEXT_DIFFICULTY() | Next Bitcoin difficulty adjustment, % (median of the 80% band; the vertical's one forward claim — its backtest grade is in the figure's level). Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.SUPPLY() | Bitcoin issued by the protocol schedule through the tip block. Returns: BTC. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.FEAR_GREED() | Crypto Fear & Greed Index (Alternative.me — attribution required). Returns: 0-100. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.COT_OI(market) | Futures open interest (CFTC Traders in Financial Futures). Returns: contracts. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.COT_LEV_NET(market) | Leveraged funds net futures position (CFTC TFF). Returns: contracts. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.COT_ASSET_MGR_NET(market) | Asset managers net futures position (CFTC TFF). Returns: contracts. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.STABLE_SUPPLY(token) | Stablecoin total supply on Ethereum (ERC-20 totalSupply, stated block). Returns: tokens. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.HOLDINGS(ticker) | Crypto assets held at fair value, latest balance sheet (SEC XBRL). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.HOLDINGS_UNITS(ticker) | Crypto assets held, units as filed (SEC XBRL). Returns: units. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.MVRV(asset) | MVRV — returns an error naming why (Coin Metrics data is CC BY-NC, BLOCKED for a paid product). Returns: ratio. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.TVL(protocol) | DeFi protocol total value locked — returns an error naming why (DefiLlama terms: non-commercial). Returns: USD. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.DIFFICULTY_BAND_COVERAGE() | Share of past difficulty adjustments inside the served 80% band. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.DIFFICULTY_BAND_COVERAGE_504() | Share of past difficulty adjustments inside the 80% band served at block 504. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.HRI_RULE_COVERAGE() | Hashrate Index's +/-5 pp rule (stated ~90%) scored on the same epochs: share inside. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.HRI_EARLY_BAND_COVERAGE() | Hashrate Index's early band (+/-10 pp, stated 95% at block 576) scored at block 504 on the same epochs: share inside. Returns: percent. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.CR.CLAIM_RECORD(claim, [field]) | A registered crypto claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MF.NOWCAST_MAE() | MF7 INDPRO nowcast: out-of-sample mean absolute error, % m/m. Returns: pp. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MF.NOWCAST_DM_P_SEASONAL() | MF7 vs seasonal naive: Diebold-Mariano p. Returns: p. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|
| =LATAVIS.MF.CLAIM_RECORD(claim, [field]) | A registered manufacturing claim's record from the public validation record: verdict (default), n, p, level, status, result, accuracy_claim, tested_on or horizon; honest negatives included, nothing graded live before deploy. Returns: verdict / n / p / level. L0/synthetic or level-less results return a labeled string, never a bare number; pair with LATAVIS.LEVEL / LATAVIS.PROVENANCE. |
|---|