You can now use the following function in several TA functions:
GetSeries(“ticker”)
Use this function in functions that have a ‘series’ parameter. You can use any stock,ETF or index ticker. If you use a stock ticker your function may stop working if the ticker changes.
This functions makes the TA functions more flexible since they were limited to only either the current ticker being tested or the overall benchmark.
It’s located at FUNCTIONS->MISC. See Full Description for the list of index tickers and examples.
Example: to get the closing price of the Nasdaq 100 enter:
One question: What happens when a stock’s ticker gets reused? For example, when Chrysler merged with Diamler, the “C” ticker was immediately adopted by Citibank. I realize Portfolio 123 has some type of internal ID for stocks so that it knows that “C” means Chrysler for some years and Citibank for other years. But GetSeries uses the ticker not the internal ID.
I will mainly be using GetSeries with indexes, but I am curious about how reused tickers are handled.
Thanks again for implementing the GetSeries function. It is much appreciated for use with indexes and ETFs.
Just wanted to add a note of encouragement and a nudge…GetSeries() is potentially very useful, and it’s use doesn’t especially depend on the series being a ticker or something that can be bought. In particular, it would be really great if we could get access to series related to things like the TED spread and other similar indicators.