Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Painting Watchlist Columns Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
cjamesee
Posted : Tuesday, July 21, 2009 10:40:53 PM
Registered User
Joined: 4/19/2008
Posts: 21
I'm trying to make a sequence of columns that would change colors (red, yellow and green) as a sector's rating increases or decreases.  Each column is tied to a different time period.  The coloring would depend on criteria such as lower than X will be red, between X1 and X would be yellow, and greater than X1 will be green.  I would like to duplicate the how Percent Change (Watchlist -> right click, load column -> Percent Change) colors each bubble in the column red or green depending on the + or - results.    
Bruce_L
Posted : Wednesday, July 22, 2009 10:04:21 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Without more details, I can only address this in general terms (we'll do our best to provide more assistance if you provide additional clarification about the specifics of the desired Watchlist Column). You will need to create a Block Diagram based Watchlist Column to do this in the current version of StockFinder. Block Diagrams have been de-emphasized in StockFinder but the Your First 3 Block Diagrams video covers creating Block Diagrams.

If you right-click on the Watchlist Column Header of the built in Percent Change Watchlist Column and select Block Diagram, you can see that the Back Color Block is fed by a T/F Color Block. If you want to have more than two possible Background Colors, you will need to put at least one True Color Replace Block between the T/F Color Block and the Back Color Block for each additional Color you wish to add.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cjamesee
Posted : Wednesday, July 22, 2009 3:21:30 PM
Registered User
Joined: 4/19/2008
Posts: 21
Bruce,

Desired watchlist is US Sub Industry Group.  I'm looking to calculate Percent Change for different timeframes with a given period.  Example (pseudo code): price.close(offset) / price.close(offset + period).   I plan to have multiple columns.  Color critieria: red < some % value, some % value < yellow > some % value, green > some % value.  

The built in Percent Change didn't seem to allow an offset.  I want to calculate the percent change for a period of X days starting X bars back.  

Thanks!
Bruce_L
Posted : Wednesday, July 22, 2009 5:02:46 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It is possible to modify the built in Percent Change Column by adding Bar Offset and True Color Replace Blocks to do what I think you want. That said, there isn't a way to save Watchlist Columns on their own in the current version of StockFinder.

You should be able to Open the attached Layout directly into a running copy of StockFinder. You can right-click on the Watchlist Column Header and select Block Diagram to view its Block Diagram and the modifications required.

Attachments:
cjamesee40946.sfLayout - 39 KB, downloaded 677 time(s).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cjamesee
Posted : Thursday, July 23, 2009 4:06:00 PM
Registered User
Joined: 4/19/2008
Posts: 21

Thanks.  The modification you made did exactly what I was trying to accomplish.

Bruce_L
Posted : Thursday, July 23, 2009 4:12:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.