Brian:

I have been looking at several methods (in the Worden forum) for finding IPOs in TC2000.

------------------------------------------

From what I can gather, here is the most likely scenario:

1.  Create a condition:  (monthly, c6=c6)         - should find IPOs that are 6 months or less old.

2. Make a new column in a watchlist with the above condition.

3. Run an 'all u.s. and bb and otc stocks' scan.

4. Sort on symbol.

5. Sort on the new column, so unchecked items appear first (the IPOs).

--------------------------------------------------------

Is this a valid way to get the IPOs that I need?

For IPOs less than 1 month, would I need to have a new condition (monthly, c1 = c1)??

And a new column with tat condition???

-----------------------------------------------------------

Is there a better way to find these IPOs?  Please say "Yes".

Thank you in advance.

Ken.

Bruce:

Sorry - I addressed the wrong person.

Is there a way to edit my posts, after they are posted?

Thanks.

Ken.

Nasdaq.com has IPO listings by month.

Recently priced IPOs

I am looking to TC2000 to display the list automatically.  IPOs can be from many different sources.

Can you help with the TC2000 coding, please.

Thanks.

Ken.

IPOs are not identified in any way in TC2000.  I'll see if this is something that can be added.

There isn't a way to edit your posts after they are created.

There also isn't a better way to find these IPOs using TC2000, at least from a conceptual standpoint.

No indicators can be made to return the number of bars of data available in the WatchList. A Custom PCF Cumulative Indicator can be made to do so on the chart, but it won't display in the WatchList.

This means you need to have something that requires at least a certain amount of data to calculate and way to check that it isn't calculating when there isn't enough data.

Doing something like C6 = C6 as a formula will check for the right amount of data but so would something useful like a 6-Period Price Percent Change formula:

100 * (C / C6 - 1)

Which leads to a method which doesn't require creating a formula at all. You could create a Custom Date Sort to check for items that returned ... in the WatchList Column instead of returning a value. Conceptually it as the same thing as creating a formula, but it might be a bit quicker and easier to do.

Bruce:

I took your advice and created SIX PCFs:

IPOs < 24 Months Old   ->  C24=c24 (monthly)

IPOs < 12 Months Old   ->  C12=c12 (monthly)

IPOs < 6 Months Old -> C6=c6 (monthly)

IPOs < 2 Months Old -> C2=c2 (monthly)

IPOs < 1 Months Old -> C1=C1(monthly)

IPOs < 1 Week Old -> C1=C1(weekly)

-----------------------------------

I added all 6 as new columns on a watchlist.  My watchlist contains 'all US stocks'.

I then click on ONE of the columns at a time and look for non-checked tickers.

I click from the longest time frame ("< 24 Months") and proceed to the shortest time frame ("Less than One Week").  I simply click on the column header - It shows the tickers in descending order.

--------------------------------------

It appears that most tickers behave rationally.  However...

Example Issue: Ticker SCHSQ shows as " IPOS Less Than 1 Month Old / Less than 6 Months old Less Than 24 Months Old" (unchecked boxes).

It shows checked boxes for "< 12 Months / < 6 Months / less than 1 Month old".   

TC2000 shows this ticker as being an IPO ineither early Feb or late Jan. 

---------------------------------------

Example 2: TC2000 shows EBODF as being around since 2008.  None of the boxes have checkmarks.  That would indicate that this ticker is newer than one week old.

--------------------------------------

Can you please look at this and let me know what may be happening?

Thank you.

Ken.

PS: If the Programming department can implement the use of a boolean if data does NOT exist at a particular time, then these watchlists would be much more user-friendly.  As it is, I must look for 'unchecked' boxes on large watchlists. 

The boolean "True if data exists, False if data does not exist" will help with finding IPOs and probably many other tasks.  Thanks.

There was an issue affecting the history of both SCHSQ and EBODF. The symbols have been corrected in the database. You may have to restart TC2000 to get the changes.

You can edit the WatchList Columns for your Conditions and change them to do something when false instead of doing something when true.

Bruce:

I found the 'Edit Columns' dialog box. 

On the assumption that reversing the visual confirmations would place checkmarks in IPOs and 'no checkmarks' in non-IPO tickers,  I changed the following.....

'When True' was changed to 'do nothing'. 

'When False' was changed to 'Show Check'.

------------------------------

Yes, what was checked is no longer checked.  But...

No, What was originally not checked (because of data errors - data was unavailable), did not become checked.  I think that, because no data was available (per the PCF date), there was not a 'zero' to be posted and, therefore,

The opposite of a 'zero' (blank box) would become 'one', and a checkmark should show.

There is NO OPPOSITE of data that is unavailable (our IPO criteria).  Therefore, TC2000 cannot recognize the data, and cannot change the 'blank' space to checkmarked spaces.

----------------------------

If this is the case, then the Programming Department should change 'Data Unavailable' errors into 'zeros' instead.  Then, the program can have real data to deal with and be used to manipulate column properties.

Thanks.

Ken.

PS: Thank you for your support with my issues! 

I get exactly the opposite results of what you report in my testing.

When I add to copies of your IPOs < 1 Months Old Condition Formula as WatchList Columns and set one to Show Check when True and Do Nothing when False and the other set to Do Nothing when True and Show Check when False, they are in fact exact opposites of each other. The Show Check when false does in fact show a check when false even though there is not enough data available for the calculation. 

On further testing, the scenario appears to be working OK.  I cannot explain why the discrepancy existed.

1)

For my own sanity, can you please let me know if there are any IPOs that meet either (C=C, monthly) or (C=C, weekly).  I show NO tickers that meet those criteria.

Logically, there should be at least one 'US Common Stock' that meets at least one of the criteria.

----------------------------------

2)

In the recent past, I have had to request that Worden add tickers to TC2000.  (they may have been BB or Pinks).

Also, I suggested that Worden run a daily scan of the stocks listed in TC2000 against the stocks supplied by the various stock data vendors, and automatically add them to TC2000, instead of the customer having to request the addition and then waiting for it to happen.

Can you please suggest that the Programming Department run these simple scans to assist the customers and ease their burden??? 

Thanks again.

Ken.

Logically there should not be any symbols where C = C is not true in every single time frame if we only add symbols once we have some data. All that has to exist is a current price on a single bar in that time frame which can even still be forming. So if there are any prices at all in our database for the symbol, then C = C should be true.

You need to go to C1 = C1 to check for a previous bar for there to logically be any chance for the formula to not be true if there any prices. This formula should only be true when there are at least two bars in the time frame.

Sorry - I meant "C1=C1, weekly" and "C1=C1, monthly".

This produces NO tickers for me. 

What am I missing? 

Thanks.

Ken.

When I combine as many of the WatchLists as I can find into a single Personal WatchList containing all of their symbols, I currently end up with 57430 symbols in the WatchList.

Of those, 3268 do not have enough data for C1 = C1 to be true on a Monthly time frame and 3228 do not have enough data for C1 = C1 to be true on a Weekly time frame, but 3197 of those do not yet have any data available at all.

So there are 71 symbols with data in my huge Personal WatchList that do not return true for C1 = C1 on a Monthly time frame and 31 of those do not return true for C1 = C1 on a Weekly time frame either.

Today, IPO "XOOM" was released.  After manually typing in the ticker, TC2000 shows it as a NASDAQ stock with 2.1M shares traded (currenty).   

But, it still does not show in the 'C1=C1, weekly/monthly/etc.'

I found the real issue!  Even after refreshing the "U.S. Common Stocks", XOOM is NOT among the tickers.  Therefore, TC2000 has not reloaded their own pre-loaded tables!

Perhaps this is why (probably) more than one ticker may not show in my scan.

----------------------

1)

Recommend that the Programming department refresh the TC2000 pre-defined tables with current data that is located in a main database somewhere at Worden!  Do it daily!

2)

Additionally, please ask Programming to write a simple program to scan tickers from Worden data providers (whoever supplies NASDAQ/FOREX/etc.), daily, and add new tickers to TC2000 database.

As it stands, available data is not making its way to the proper tables at Worden.

3)

After the "U.S. Common Stock" table has been refreshed, can you please recheck that our scans work against the new data?  Thank you.

Thanks.

Ken. 

XOOM is in the US Common Stocks WatchList already. It shows up as not returning true for me for C1 = C1 in both a Weekly and Monthly time frame.