Rationale of replacement

At the moment, when we give a score to a stock, we these 2 ranking factors: short-term and long-term price change. However, they pose some serious problems.

First of all, to obtain these measurements, we need to download the historical market price of a stock on the day 1 month ago and 5 years ago. Unfortunately, IBKR does not provide an API to download the data on a particular day. Instead, we need to download all data from a particular day to the current day. This adds complexity in API usage and calculation. What's worse, in order to get a precise calculation, we must use a short interval (like 1 day) when downloading data for 5 total years, which results in a huge increase in download time (and might hit usage limit one day).

Secondly, I accidentally found that the calculation of long-term price change is incorrect when compared to Yahoo Finance (#5).

It is better to get rid of these 2 measurements and opt for ones that are already provided by IBKR.

Candidates of replacement

All these measurements are provided by IBKR:

• Exponential Moving Average

Because the whole table is getting too wide.

It might be even better to remove this column entirely. But first, check if other columns have correct data, and search for some other indexes that measure the long-term success of a stock.

Otherwise, the error message at the moment is now intuitive.

This behavior is written in the document already, we just did not notice it.

It is only fair because getting data from some stocks (e.g. Swiss ones) always fails, and I must manually get their data from Yahoo Stocks mobile app, which limits the long-term price change to 5 years.

Also, setting the scope to too long will give some stocks an excessively high score while other stocks will never see the light of day.

• PEMA 200: 0.4
• PEMA 20: 0.3
• P/E: 0.2
• Dividend yield: 0.1