Registered User
Joined: 10/7/2004
Posts: 79
|
I'm trying to add a column to one of my small-cap backscans, but running into a snag.
What I want it to do is spit out a ratio for each of the symbols in the results list.
Here is what I have thus far:
Column Symbol -> Latest Price -> Divide -> Column Data
I still need to plug in the In1 to the Divide block.
What I am trying to plug in there is Sum For Period which is receiving its Date & Number data from a tool which only has an output of Date & Bar.
The Sum For Period does not connect to the In1 on Divide, perhaps because it is a Date & Number "series"?
I am also unsure how this would work since the disconnected side of the equation has no connector to the Column Symbol.... so how would it know what symbol to reference unless the tool itself is already referencing the current symbol.
So I guess I'm looking for help with how to get the data I want to plug in correctly to the Divide block.
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
I've been trying to punch in whatever other blocks might make sense, or to find something to go in-between, but no luck on my part.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You didn't indicate what it was, but whatever is going into the Sum For Period Block needs to be use Column Symbol or it will not produce different values for each symbol.
Once this is done, you will need to run the output of the Sum For Period Block into a Block that samples one value so it outputs a Number instead of a Date & Number Series. You could use a Last Number in Series or Value for Series Block for example.
I've attached an example that just Sums Price. Please save the following .SGCol file in:
\My Documents\Blocks Files\Tool Parts\Columns
Once there, you can add the column by right-clicking the tab header of the WatchList, choosing load column then My Computer.Attachments:
marcs23855.SGCol - 4 KB, downloaded 375 time(s).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Thanks for the file, and particularly for the filters to apply.
How would I go about setting up the following:
I have half the equation. What I want to plug into this other side is various studies, and at least one indicator which is represented as a BarChart which spits out a Date & Bar Series.
I want to manipulate the data such that it takes the net whole number value of a study based on the same Column Symbol over time frames I select and inputs it to the ratio equation for the column. I want to be able to do this for several studies and charts I've come up with (and/or downloaded) and one of them is the Net Change study you put together for me.
I'm not sure I'm expressing myself as clearly as I would like. Thanks for trying to follow along! LOL
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you already have a Plot, you can copy most of the Blocks in the Plot's Block Diagram and paste them into the Block Diagram for the Column.
Hold down the CTRL key on your keyboard and left click and drag to highlight the portion of the Block Diagram you wish to copy. This will create a box as an outline. The outline will disappear, but the Blocks that were in it will remain highlighted.
Right-click in the highlighted area and select Copy.
You can now paste these copied Blocks someplace else in the Block Diagram or in another Block Diagram entirely.
You can then use a Block that converts Series data into a single result such as a Last Value in Series or Value for Date Block to let you use the result as an input for the Column Data Block.
You will want to make sure that you are linking any Blocks providing data (such as Price and Volume Blocks) to the Column Symbol. If you do not do so, the Column will not display different values for each symbol.
That said, this is not always the most efficient thing to do. Many indicators only require data from one or two days to calculate a value. Calculating the entire series to only get one value uses a lot more resources than actually needed. In these cases it would generally be better to create a completely different Block Diagram that only uses the required data (or at least set an Output Limit on the data being used).
Please save the following .SGCol file in:
\My Documents\Blocks Files\Tool Parts\Columns
Once there, you can add the column by right-clicking the tab header of the WatchList, choosing load column then My Computer.
This Column runs two Rate of Change Blocks through Line Floor Blocks before running them into a Ratio Block. I've used a Value For Date Block in this example to changing things up from the example in my Monday, July 16, 2007 5:14:28 PM ET post. You can edit the settings and view the Block Diagram using QuickEdit.
I've also enabled QuickEdit Replace for most of the Blocks in the Block Diagram using the Library option. This should allow you to replace any Block with any other compatible Block using QuickEdit as well. You can create a lot of different indicators using just this Block Diagram as a result (I'm not saying it will create all of the indicators you want).Attachments:
Morphing Column.SGCol - 5 KB, downloaded 412 time(s).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Hi, Bruce. I'm back from a short break.
"You will want to make sure that you are linking any Blocks providing data (such as Price and Volume Blocks) to the Column Symbol. If you do not do so, the Column will not display different values for each symbol."
I followed your directions and ported in the other blocks formula, but there is still a snag.
As you warned in the above quote, what I have happening now is the column is calculating all the data points against only whichever symbol I have clicked on in my main display.
Is there a way I can contact you by phone or e-mail? Or does the tech support line offer assistance with walking someone through blocks setups?
It seems I'm pretty close to making this work, but am not so good at expressing myself. It's been a few weeks and I'd like to wrap this one up. LOL
Don't worry, my other setups and projects are simpler and more cut/paste than anything else. ;)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Ask a Trainer is only provided in the forums. It is not provided via chat, email or phone.
Drag and Drop Sorting has been added since my Wednesday, July 18, 2007 9:45:20 AM ET post. This makes converting a Plot to a Column much easier:
NEW FEATURE Drag and Drop sorting with Mini-Charts
As far as your existing Columns go, take a look at your Block Diagram. Take a very close look at every "Link From Another Tool" in the Block Diagram (they are normally displayed as blue squares).
If the Link From Another Tool Block is the output of a Plot, chances are, you would need to replace this with the actual Block Diagram for that Plot.
If the Link From Another Tool Block is a Symbol, you would normally want to use Column Symbol instead (unless you specifically want to use another symbol as would be done in something like Relative Strength).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
"If the Link From Another Tool Block is the output of a Plot, chances are, you would need to replace this with the actual Block Diagram for that Plot."
I already punched in the diagram from the other plots. This worked for one side-project.
How do I set it up when the data from another tool is the blue box and it is not a block diagram, but a study? In this case, I have one box which is BarChart zigzag plugging into Sync Dates and another which is BarChart Price History 2 going into Bar Builder... that part of the block diagram is actually some stuff you put together for me previously.
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
If we could forward or post files, I'd attach what I've got to the post for you to make it easier, believe me.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you attach your files to an email sent to my attention at support@worden.com, they will be forwarded. We just don't answer questions via email. The conversion itself will be kept in the forums.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Sent.
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Did it go through? Because I got some silly auto-response asking for my TC2000 codes??
I don't maintain a TC2000 / TCnet / TC2007 account anymore, so I hope I don't need those codes! =P 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I haven't received it yet. E-Support should be able to look up your account using your username (marcs). I would include that in your response (or maybe even reference this topic).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Ok. I'll hang tight then.
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Let me know if I need to re-send it or if there is other data I need to add to the packet.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In looking at the Block Diagram for the Column, I see you have Bar Chart Zig Zag going into Sync Dates and Bar Chart Price History.2 going into Bar Builder.
Do you want to sum the Price Net Changes for Zig Zag or Price History.2?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Net
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I know you want to sum the Net Changes.
I need to know if you want the Net Changes to be for the Zig Zag or Price History.2.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 79
|
Was running out the door before. Zig-Zag, if you please.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please save the following .SGCol file in:
\My Documents\Blocks Files\Tool Parts\Columns
Once there, you can add the column by right-clicking the tab header of the WatchList, choosing load column then My Computer.
You didn't need to have both Zig Zag and Price History.2 to calculate the net changes for Zig Zag. I replaced Zig Zag with the Blocks in its Block Diagram.
The only Link From Another Tool Block remaining in the Block Diagram is Bar Chart Main Timeframe. You could replace this with a Time Frame Block if desired.Attachments:
Zig Zag Sum Price Ratio.SGCol - 5 KB, downloaded 343 time(s).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |