Dear All,
First of all, thank you for your patience. The release for multi-country support was not smooth. Some decisions had to be undone and new ones made. We apologize for this. Please refer to this previous post for some of the decisions
In short
The new release is on the https://beta.portfolio123.com website
[list=a]
[]It has new “Week Day” functions. For example Close_D, SMA_D, RSI_D, etc
[]It has new weekly functions. For example SMA_W(10) is the average of the past 10 weekly prices (for close is the Friday close price).
[*]Existing TA functions operate on bars. (with few exceptions, see below)
[/list=a]
For users that want functions to operate on ‘bars’ (trading days)
You don’t need to do anything (almost). This is for users that want to design strategies in single country universes where all stocks in the universe stop trading on the same days. All technical functions operate on bars by default. So for example Close(10) is the close 10 trading days ago (typically 2 week span unless there was a holiday)
There’s only one case where you need to intervene: if you use sector and industry series. We chose to create industry and sector time series for the entire North America which meant that the time series had to be based on weekdays and include holidays.
This can cause problems in your strategy if, for example, you like looking for stocks that have outperformed the industry. For that filter to work the period has to be in the same units. You will need to rewrite your formulas using weekday functions. For example if you are looking for stocks that have outperformed the industry like this:
[font=courier new]Close(0)/Close(10) > Close(0,#industry)/Close(20,#industry)[/font]
You should rewrite it using weekday functions since the industry series includes holidays:
[font=courier new]Close_D(0)/Close_D(10) > Close_D(0,#industry)/Close_D(20,#industry)[/font]
New weekday and weekly functions
On the beta website you will have access to several new weekday functions (plus a bonus: weekly functions). You should use these functions if your universe is multi-country so everything lines up, and if you are using industry and sector series.
We have only implemented a subset of the functions at the moment. More are coming so let us know your priorities. For example here are the old and new Simple Moving Average functions:
SMA(bars [,offset,series]) : Simple moving average of a time series. Period is in ‘bars’ or ‘trading days ago’ (can vary depending on the series you choose).
SMA_D(days [,offset,series]) : Simple moving average of a time series. Period is in ‘days’ which include holidays.
SMA_W(weeks [,offset,series]) : Simple moving average of the weekly time series.
We plan to make this beta release in production sometime next week so we can move on to adding European data.
Let us know any questions
Thank You
List of new functions (more to come)
Close_D (days [,series])
Close_W (weeks [,series])
EMA_D (days [,offset,series])
EMA_W (weeks [,offset,series])
Hi_D (days [,series])
Hi_W (weeks [,series])
Low_D (days [,series])
Low_W (weeks [,series])
Open_D (days [,series])
Open_W (weeks [,series])
RSI_D (days [,offset,series])
SMA_D (days [,offset,series])
SMA_W (weeks [,offset,series])
WMA_D (days [,offset,series])