A spreadsheet that already has the data in it.

What you get

• Columns over market fields — open, high, low, close, volume and returns — per bar
• Formula columns using the same 126-function expression language as the indicator builder
• A formula column can reference columns declared before it, so a calculation can be built in stages
• Templates to start from, or a sheet declared entirely by you
• No API keys, no CSV export and re-import, no refresh button to remember

Why this is usually paid for

The usual way to get market data into a spreadsheet is an API key, a script, and a refresh that breaks quietly when a rate limit changes. The spreadsheet is the easy part; the plumbing is what costs the afternoon.

Here the data is already in the browser because the chart loaded it, so a sheet is a different view of the same window rather than a separate integration to maintain.

How to use it

1. 1

   Start from the question, not the columns

   A sheet is worth building when you want to see several numbers side by side across bars — range against average range, volume against its own mean, return against a benchmark. Decide the comparison first and the columns follow.

2. 2

   Build a calculation in stages

   A formula column can reference earlier columns, so intermediate steps can each be a column. That is easier to check than one long expression, and the intermediate values are visible when something looks wrong.

3. 3

   Keep the window in mind

   Columns compute over the loaded window, not over all history. A hundred-bar average on a chart showing eighty bars is not what you meant, and the sheet will show it as such.

4. 4

   Move a column that works into the screener

   The expression language is shared. A formula that turned out to be the useful one in a sheet can become a screener condition without being rewritten, which is usually the point of having worked it out.

Questions

Also free