A Wisesheets Alternative for Point-in-Time Fundamentals and Excel

Wisesheets solves a practical problem: getting financial data into Excel and Google Sheets without building a data pipeline first. That spreadsheet-native delivery can be a real advantage. Tradevo Data does not offer an Excel add-in or native spreadsheet formulas.

But if your spreadsheet feeds a historical screen, factor model, or backtest, delivery is only half the problem. You also need to know what information was public on the date being modeled.

A formula that refreshes to the latest revised fundamental can silently rewrite historical inputs. Your workbook may still show a clean series, while a model supposedly run last year is now using values that became available later. That is a form of lookahead bias.

Tradevo Data is an API-first alternative for researchers who prioritize point-in-time controls over spreadsheet convenience. It provides US equity fundamentals sourced from public-domain SEC EDGAR filings, with filing availability dates, original values, current revisions, restatement labels, QA statuses, and server-side as_of filtering.

The core difference: convenient retrieval versus time-aware retrieval

Spreadsheet integrations are useful because they put data where analysts already work. You can build tables, charts, valuation models, and monitoring sheets without maintaining ingestion code.

That convenience may be the correct priority. It does not automatically establish that every returned historical value is point-in-time safe, however. Researchers should verify how any provider handles filing dates, amendments, restatements, and historical revisions before using refreshed formulas in a backtest.

Tradevo Data is designed around a narrower question:

What fundamental value had become public by a specified date?

Its fundamentals endpoint accepts a ticker and as_of date, with optional concept and period filters:

/v1/fundamentals?ticker&as_of[&concept][&period=annual|quarterly]

The server applies first_filed <= as_of, including filings made on the specified date. Annual data is the default.

Each row includes:

• first_filed: the date the value became public
• original_value: the first-reported, point-in-time-safe value
• latest_value: the current revision
• restated: a flag for same-tag changes greater than 0.5%, including amendments
• qa_status: a quality-assurance status

This structure lets you choose deliberately between an original point-in-time value and the latest known revision instead of letting a refresh make that decision implicitly.

For more detail on the failure mode, see https://tradevodata.com/blog/lookahead-bias-fundamental-backtests?utm_content=alt-wisesheets. A broader explanation of point-in-time data is at https://tradevodata.com/blog/point-in-time-fundamentals-data?utm_content=alt-wisesheets.

Wisesheets versus Tradevo Data

This is not a claim that one product is universally better. They serve overlapping users but optimize for different workflows.

See the lookahead leak on real filings — five companies, 225 rows, CC0, no signup. Three minutes in a notebook, before you decide anything.

Competitor features and terms can change. Review Wisesheets’ current documentation and pricing page before deciding.

Why refreshed spreadsheet formulas can alter a historical model

Suppose you built a workbook that ranks companies using revenue and operating income as they appeared at a prior rebalance date. Later, an issuer files an amendment or restates a figure.

If the workbook formula now returns only the latest value, reopening or refreshing the file can replace the earlier observation. The formulas remain valid and the cells may look ordinary, yet the historical model has changed.

That creates several problems:

1. The backtest may know more than the strategy knew. A later revision can enter an earlier simulated decision.
2. Results become difficult to reproduce. Two refresh dates may produce different historical inputs.
3. Audit trails weaken. Without availability dates and revision states, it is hard to explain why a signal changed.
4. Live and researched processes diverge. The live model acts on first-available information, while the backtest may use corrected hindsight.

Point-in-time data does not make a strategy profitable, nor does it eliminate every research error. It addresses one specific source of temporal leakage.

On reliable-filing rows in Tradevo Data’s five-company public proof pack, the measured mean lookahead was 35.2 days and the maximum was 48 days. These measurements apply only to those proof-pack rows, not to the full dataset.

You can inspect the sample, methodology, and rows without signing up at https://github.com/christianpichichero-max/pit-fundamentals. The pack contains five companies, their latest three fiscal years, and 225 rows.

What Tradevo Data includes

Tradevo Data includes 632,466 annual point-in-time rows across 5,168 US companies, with up to 12 fiscal years and 16 annual concepts. It also includes 1,089,635 quarterly rows across 5,382 companies and seven quarterly concepts. Q4 is reported where tagged or derived and labeled where supported.

There are important boundaries:

• No derived Q4 EPS or share counts
• No TTM calculations
• No non-US coverage
• No delisted-company coverage
• Parquet format is not included

The dataset includes 37,804 labeled restatements. The 16 annual concepts are Revenue, NetIncome, Assets, StockholdersEquity, OperatingCashFlow, EPSDiluted, DilutedShares, GrossProfit, OperatingIncome, PretaxIncome, IncomeTaxExpense, CapitalExpenditures, CashAndCashEquivalents, CurrentAssets, CurrentLiabilities, and NetPPE.

The $29-per-month Pro plan includes complete available history, 5,000 requests per day, and bulk access through /v1/download and /v1/snapshot?as_of. Both bulk endpoints support period=annual|quarterly.

The card-backed seven-day free trial covers 10 companies, a rolling three-year history, and 100 requests per day. Bulk access is not included during the trial. It renews at $29 per month unless canceled. Documentation is available at https://tradevodata.com/docs?utm_content=alt-wisesheets.

Using point-in-time data with Excel

Choosing an API does not mean abandoning Excel. It means separating data retrieval from workbook logic.

A practical workflow is:

1. Request or download a snapshot for the research date.
2. Save that response with the model run.
3. Import the resulting data into Excel with Power Query, Python, or your preferred ETL step.
4. Build spreadsheet calculations against the saved snapshot rather than live, refreshing formulas.
5. Record the as_of date and whether the model used original_value or latest_value.

This requires more setup than a native add-in. In return, the input boundary is explicit and easier to reproduce. For recurring work, a script can fetch snapshots and prepare data for Excel.

When Wisesheets wins

Wisesheets may be the better option when:

• Your primary goal is to pull data directly into Excel or Google Sheets.
• You want spreadsheet formulas rather than an API integration.
• Your work emphasizes current analysis, dashboards, or valuation models rather than historical simulation.
• You prefer spreadsheet convenience over maintaining a separate ingestion step.
• Its current coverage, methodology, and revision handling meet your requirements after review.

That is not a minor advantage. Native spreadsheet delivery can reduce friction, especially for analysts who do not want to write code or operate data infrastructure.

Before using any spreadsheet-fed history in a backtest, ask the provider whether historical values are preserved as originally reported, how amendments are exposed, and whether you can request data as known on a past date.

When Tradevo Data is the better fit

Tradevo Data may fit better when:

• Your research requires a server-enforced as_of cutoff.
• You need both first-reported and latest revised values.
• You want restatement labels and filing availability dates attached to each row.
• You need bulk snapshots for reproducible research.
• US EDGAR fundamentals are sufficient for your universe.
• You can import API or bulk output into your own spreadsheet, database, or research stack.

It is positioned as an honest budget tier of research-grade point-in-time data, not as the only affordable option. Sharadar, Tiingo, QuantConnect, and other credible providers may also deserve evaluation. See their respective pricing pages and documentation for current terms.

When to build it yourself

Building directly from SEC EDGAR can be rational if your universe is small, your concepts are narrow, and you need complete methodological control.

You will need to handle XBRL tag variation, filing and amendment chronology, fiscal periods, duplicate facts, units, annual-versus-quarterly interpretation, Q4 derivation rules, restatements, validation, and repeatable snapshots. EDGAR filings are public domain, but transforming them into a stable point-in-time panel is engineering work.

Build it yourself when that pipeline is part of your research advantage, when you require concepts or rules not offered here, or when internal governance demands full ownership. Buy a service when maintaining that normalization layer is a distraction from the analysis you want to perform.

Verify first, then choose the delivery model

If you are evaluating a Wisesheets alternative for point-in-time fundamentals in Excel, start with evidence rather than a checkout page.

Inspect the public proof pack, methodology, filing dates, original values, revisions, and QA fields at https://github.com/christianpichichero-max/pit-fundamentals.

If the structure fits your process, the card-backed seven-day free trial is available at https://tradevodata.com/?utm_content=alt-wisesheets. It renews at $29 per month unless canceled.

Choose spreadsheet-native convenience when that is the binding constraint; choose explicit point-in-time snapshots when historical reproducibility matters more.

Not investment advice. Verify competitor features, methodology, coverage, and pricing directly.