Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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.
|
|
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
|
|
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!
|
|
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
|
|
Registered User Joined: 4/19/2008 Posts: 21
|
Thanks. The modification you made did exactly what I was trying to accomplish.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |