| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Platinum Customer
Joined: 3/31/2006
Posts: 3,207
|
Bruce
Can you also write a PCF that would plot the number of the days the company has been public.
I need to plot this as a column and we can stop the count at 126 bc I am only interested in those that have been public for less than 126 and I like to sort this list from those that are newer ipo's the shortest to the longest
thx
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
I can't think of any way to do that. It's easy to find stocks with less than 126 days of data using CountTrue(C=C,126). This will return Null for stocks with less than 126 days but no way to show the exact number of days for all under 126.
|
|
Platinum Customer
Joined: 3/31/2006
Posts: 3,207
|
Ok can you pls show me how to create an easyscan that would only screen if the stock has less than 126 trading days
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
You can't scan but you could create a condition column for C = C126 and sort. Any stock with less than 126 days of data would show a blank column. All other would show a check mark for True.
|
|
Registered User
Joined: 5/23/2006
Posts: 75
|
Try this:
How to create an IPO column in TC2000
|
|
Registered User
Joined: 9/17/2010
Posts: 484
|
Wouldn't C126=C126 work better?
|
|
Platinum Customer
Joined: 3/31/2006
Posts: 3,207
|
It would be better if we can do it as a scan because I am trying to apply other rules to the IPO list so I like to create an easyscan that filters only the IPO's that are liquid and then I have multiple buy signal rules which I have as column headers that I sort by on a daily basis.
To have this as a column header doesn't help me
I am confused why we can't have this as a rule in an easy scan?
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Becuase there's no way to scan for a stock with only x days of data. You can filter out stocks that don't have at least x days of data, but not the other way around.
|
|
Platinum Customer
Joined: 3/31/2006
Posts: 3,207
|
So you are saying I can create a rule that will screen for stocks that have at least 126 trading days but I can NOT create a rule to scan for those that have less?
Am I understanding this correctly
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Yes, you can scan for stocks that have at least 126 days using C126 > 0. To pass, the stock has to have a price 126 bars back to calculate the formula. If the stock has less than 126 days of data, then the formula cannot be calculated so the stock would not pass the condition.
But you could use the same condition in a watchlist column and sort by that column. Stock with no check mark have less than 126 days of data. If you do this on the US Common Stocks list you could flag all of the symbols that don't pass and copy them to their own watchlist and the use that list for scanning.
|
|
|
Guest-1 |