Q-Alpha
Calculate a Risk Score From Your Own Price Data: Preparing the Series
How to prepare a clean daily price and volume series before scoring it, why short histories make dispersion measures unstable, and what Q-Alpha's Your-Data Risk Index form accepts. A research tool, not financial advice.
When you need to score your own series
Most risk screens work from a list of symbols that a data provider covers. If the asset you care about is not on that list, you are left with a spreadsheet: a column of daily closing prices and a column of daily volumes, exported from wherever you track it. That is a reasonable starting point, and it is also where most of the avoidable mistakes happen. A score is only a summary of the series behind it, so the preparation matters at least as much as the calculation.
This page covers how to prepare such a series and what to watch for, and then describes the one form in Q-Alpha built for it. Nothing here is financial advice, and no score can tell you what to do with your money.
Preparing a clean daily series
A few habits prevent most problems.
- One price and one volume per day, in the same order. The price column and the volume column describe the same days. If one list has a day the other lacks, every later pair is shifted and the score describes a series that never existed. Equal length is the minimum check; matching dates is the real one.
- No gaps you cannot explain. Missing days can be genuine, such as weekends and market holidays, or they can be export errors. Decide which, and treat a stray blank or a placeholder text value deliberately rather than letting it be dropped silently.
- Consistent units. Do not mix prices quoted in different currencies, or volumes counted in shares for some days and in contracts or currency value for others. A unit change in the middle of a column looks like a sudden jump to any measure of dispersion.
- Adjust for known events. Splits, redenominations and similar changes can make a price appear to collapse overnight. If the source does not adjust for them, you may need to do it yourself, or at least know it happened.
- Non-negative numbers only. Prices and volumes below zero are not meaningful for this purpose, and Q-Alpha's form rejects them.
- Enough history to mean something. See the next section.
Why short series make dispersion measures unstable
Volatility, in the plain sense, is how widely returns scatter around their average. With only a handful of observations, one unusual day can dominate that picture. Drop it, or add one more ordinary day, and the answer moves a lot. The same is true of momentum and trend readings: a short window can show a clear direction that a longer one would reveal as noise.
There is no magic length at which this stops. A longer series is steadier, but it also reaches further back into conditions that may no longer apply. The practical lesson is to treat a result from a short series as rough, to try the calculation on slightly different windows, and to be suspicious if the answer changes sharply when you do. A score that is only stable on one particular window is telling you about that window.
What Q-Alpha's Your-Data Risk Index form accepts
Q-Alpha is a web application for market and portfolio research. Alongside its symbol-based Risk Index it has a form titled Your-Data Risk Index, reached from the Risk Index screen. It works like this:
- An optional label names the asset.
- You paste daily prices and daily volumes into two boxes. Values can be separated by commas, spaces or line breaks.
- The form needs at least twenty values in each list, both lists of equal length, and no negative numbers. If the input does not meet those checks, it shows a short hint instead of computing.
- The result shows an overall score out of 100 together with volatility, momentum, liquidity and trend sub-scores, and a note that it was computed from your data.
Two limits are worth stating plainly. The form checks the shape of your input, not its quality: it cannot tell whether your dates line up, whether your units are consistent or whether a split has been adjusted. And this page does not describe how the sub-scores are calculated or how they are scaled, because that logic runs in Q-Alpha's backend and is not covered here. Read the result as a description of the series you supplied, not as a statement about the underlying asset.
For how the symbol-based screen differs, including its data-source label and its five-axis breakdown, see what a single risk number can and cannot tell you.
Reading the result sensibly
- Compare your asset with itself over different windows before comparing it with anything else.
- Compare scores only within one tool. A different calculator may define its scale differently.
- Remember that a score built from prices and volumes alone cannot see events that have not yet reached the price, and it knows nothing about your own position or circumstances.
- Treat the result as one input to your own research. It describes past behaviour; it does not weigh your situation.
Access
The form lives inside the signed-in dashboard, so you need a Q-Alpha account to use it. You can create one. On the free tier, the number of symbol lookups on the Risk Index screen per day is limited; the pricing page lists what each plan includes.
Q-Alpha does not provide financial, investment, tax or legal advice, and nothing on this page is a recommendation to buy, sell or hold any asset.
Create a Q-Alpha account to paste your own daily prices and volumes into the Your-Data Risk Index form. Research tool only, not financial advice.
Get started