Registered User
Joined: 1/3/2008
Posts: 34
|
I want to create a custom indicator that uses only optionable stocks. I want to calculate the ratio between the volume of advancing issues to the volume of declining issues only using optionable stocks (using all of them together).
The formula would be =
(volume of advancing issues on all optionable stocks) / (volume of declining issues on all optionable stocks)
I have the Platinum real time edition.
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Welcome to the forums. I do not know of a way to do this using TeleChart because the Personal Criteria Formula Language does not have syntax for referencing other symbols or fundamentals.
I would suggest reviewing If you are new to TeleChart READ THIS FIRST! to get a good overview of how you can get the most out of TeleChart.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for your reply. Is it possible to create an indicator that uses the same common stock from the NYSE as T2100 Advance/Decline Line. Using these same common stocks, the indicator would calculate the ratio between the volume of advancing issues to the volume of declining issues.
formula = (volume of advancing issues of NYSE common stock) / (volume of declining issues of NYSE common stock)
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The problem is not the optionable portion of the request. The problem is that you cannot currently create an automated Custom Indicator using data from more than one symbol in TeleChart (this limitation does not exist in Blocks).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Is it possible to create this indicator with only optionable stocks using Blocks?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Let me see if I can clarify this.
In TeleChart it is not possible to create an indicator that includes data pulled from multiple symbols.
Custom Indicators can only be made for one symbol or values manually entered in the formula.
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
Yes, it is possible using Blocks. You would use the Optionable Items Watchlist as the basis of the indicator.
That said, Blocks 2.0 is no longer for sale to new Blocks customers. We are in the middle of the pre-release of Blocks 3.0 (you will get a copy at the class if you attend).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (scastlem) formula = (volume of advancing issues of NYSE common stock) / (volume of declining issues of NYSE common stock)
Scott,
You can plot:
formula = (NYSE Up Volume)/(NYSE Down Volume)
Please bring up the symbol NUVOL and plot Relative Strength vs the symbol NDVOL. You can read the ratio (Relative Strength) in the pointer data window.
The problem is that I do not know the definitions of "NYSE Up Volume" and "NYSE Down Volume". Maybe someone else does.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I want to make sure I understand what you are saying. The reason is that I was told I could do this with Telecharts and went ahead and signed up for it know only to find out that I cannot do it.
Using the new version of Blocks, can I create a ratio with real time data using all of the stocks in the Optionable Stocks Watchlist that compares the cumulative volume of all stocks that have advanced from the previous bar to the cumulative volume of the all stocks that have declined from the previous bar? So, I can change between 5 minute and 10 minute bars and Blocks will compare the prices for all of the stocks in the Optionable Stocks Watchlist from 5 and 10 minutes ago, respectively, to determine if the price is greater than or less than it was on the previous close and then add the volume for that stock to the up volume sum or to the down volume sum before taking the raio?
Can I create the ratio of advancing issues to declining issues as well just for all stocks in the Optionable Stock Watchlist?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
As bustermu has indicated, it is in fact possible to plot the (NYSE Up Volume)/(NYSE Down Volume) without the optionable limitation from within TeleChart using the Relative Strength indicator. I've actually suggested doing this on previous occassions. I'm not sure why I didn't think of it when you asked.
It is possible to plot this ratio for any Watchlist in Blocks. It can therefore be done for either All Stocks or Optionable Stocks. It is fairly trivial to do this on a Daily Chart. The cumulative intraday version suggested in your Tuesday, January 08, 2008 4:14:36 PM ET post can be done as well, but it is more difficult to create (I have a Study that I created for another customer to find the number of stocks with intraday highs and lows for a Watchlist that could be converted rather easily do to this) and far more computationally intensive.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for the information. I am attending the Blocks seminar this weekend. Perhaps you could help me with this code next week.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
You're welcome. I'll be happy to help you create the indicator once you have a copy of Blocks.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Now that I have Blocks and have had time to learn some of its features, would it be possbile for you to create the up/down volume ratio indicator that I can apply to various watchlists.
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
Please start by creating a Custom Code Block as Two Bar Period to Line (Copy and Paste seems to work for this in Firefox, but not in Internet Explorer). If you have not done so already, you may wish to review at least one of the following before attempting to create your own Code Blocks:
VB.Net (code block) to color down Monday red
VB.net exercise to access Quickedit from your codeblock
Hello World! Writing Code Blocks in Visual Basic .Net
Delete everything in the Code Block Editor and replace it with the following:
<WBIGuid("1e940285-862d-408f-963f-e877dc0c14d3"),FriendlyName("Multiply and Add Cumulator")> _
Public Class Multiply_and_Add_Cumulator
Inherits BaseTemplateTwoDBSAndPeriodToDLS
Public Overrides Sub calculate()
Dim line As Double = ParameterValue
Dim first As Integer = System.Math.Max(Input1FirstActualIndex, Input2FirstActualIndex)
Dim last As Integer = System.Math.Min(Input1LastActualIndex, Input2LastActualIndex)
For bar As Integer = first To last
line = line * Input1Last(bar) + Input2Last(bar)
AddToOutput(InputDate(bar),line)
Next
End Sub
End Class
This Custom Code Block is seeded with the Number Input (Period). On the first bar it multiplies this seed by Input1 and then adds Input2. On subsequent bars it multiplies the previous bar by Input1 and then adds Input2.
I made a Layout and shared it for you. Once you have created the Custom Code Block (and not until) please click on SHARE and search for your name (scastlem) under the Layout tab.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for the code. I watched the videos but was not able to get it working. Here are the steps I took:
I created a new chart.
I right clicked on the chart to Create New Indicator from Block Diagram
I then got a New Plot box, which I named and then got a Block Diagram
I right clicked on the diagram to Create Code Block
I selected Two Bar Period to Line
I named the New Block Name, "Multiply and Add Cumulator"
I erased all of the code and replaced it with yours
I compiled and saved
I right clicked on the Block Diagram to Select Block and inserted the Multiply and Add Cumulator under the Blocks heading
It then inserted the picture above the existing diagram.
This is how far I got. I don't know if I took the correct steps.
I do not know if I am suppossed to connect lines within the Block Diagram.
Would you be able to help me with describing the specific steps I need to take to get the indicator working.
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
You seem to have made the Custom Code Block. All that's left is the last paragraph of my Monday, January 28, 2008 4:35:57 PM ET post. I'll restate it in a different form here:
Select Share | Layouts.
Type scastlem in the Search line and select Search.
Select the scastlem28012 Layout.
Select Open.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I think I am still doing something incorrectly.
I followed the steps and have inserted scastlem28012. On the bottom of my chart, I have a blank indicator pane labeled WL Cumulative Intraday Avg Volume Down Ratio. However, nothing is plotted. I want to be able to apply the indicator to different watchlists.
Also, when you say that the Custom Code Block is seeded with the Number Input (period), is this the length of the moving average? Also, is there a way to make the indicator start at zero at the beginning of the trading day?
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (scastlem) On the bottom of my chart, I have a blank indicator pane labeled WL Cumulative Intraday Avg Volume Down Ratio. However, nothing is plotted.
The blank Pane would seem to indicate that the Custom Code Block was not created correctly. Did you replace everything in the Code Block (the WBIGuid must match)? Is the Custom Code Block using VB.Net Block syntax (this is the default when creating a Custom Code Block)? Did you receive any errors when creating or saving the Custom Code Block?
QUOTE (scastlem) I want to be able to apply the indicator to different watchlists.
The indicator will be applied to the Active Watchlist (meaning you can apply it to any Watchlist you want).
QUOTE (scastlem) Also, when you say that the Custom Code Block is seeded with the Number Input (period), is this the length of the moving average?
No. Where would you get that idea? Please keep reading. "... On the first bar it multiplies this seed by Input1 and then adds Input2. On subsequent bars it multiplies the previous bar by Input1 and then adds Input2."
QUOTE (scastlem) Also, is there a way to make the indicator start at zero at the beginning of the trading day?
It does.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I replaced everything in the Code Block exactly as you have it. For Block Syntax, the VB.Net is bulleted. I received no errors when compiling and saving the Custom Code Block.
In the video, the narrator connected the custom code block within the diagram. I did not do this. Perhaps this is the source of the problem. I do not understand how to correctly link the diagram with the component block pictures.
Also, I am not sure how the code block I created (which I called Multiply and Add Cumulator because that was the FriendlyName you gave it) is being accessed through the Share layout. Just to let you know, when I use the scroll down under Indicators, I do not see any indicator block called, "Muliply and Add Cumulator" or "WL Cumulative Intraday Avg Volume"
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
I am still not able to get the indicator working. Would you please provide me with instructions explaining the steps I should take to get the indicator working, including connecting the proper lines within the Block diagram if necessary.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
I have not forgotten you. I have been consulting with others in an attempt to figure out what is happening since, once the Custom Code Block is created, the shared Layout just works without any additional intervention or steps.
Three of the connections for the Multiply and Add Cumulator Block are the same in both the WL Cumulative Intraday Avg Volume and Down Plots. The Open Block goes into Input1, 0.00 goes into the Period and the output goes into the Loop In of the List Average Block.
In the WL Cumulative Intraday Avg Volume Plot, Input2 is fed by Volume. In the Down Plot, Input2 is fed by the Multiply Two DLS Block instead.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for your help. Unfortunately, I am still having trouble creating the block, "Multiply and Add Cumulator". I tried creating both an Indicator from Block Diagram and Indicator in New Pane and neither seems to work. For some reason, "Multiply and Add Cumulator" no longer appears in the list of Blocks under Block Heading when I attempt to insert the block into the diagram. I tried giving it a new Friendly Name and that does not work either. Is there any other way for me to get the indicator of up/down intraday volume you created for me working on my machine without having to create my own block? Is it possible to download this block, for example? I am able to open the block diagrams for WL Cumulative Intraday Avg Volume and for Down if this helps.
I appreciate your helping me with this.
Scott
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
What if the indicator of up/down volume was more like the A/D Ratio, where it used a moving average to smooth the data, and did not reset to zero at the beginning of the trading day. Perhaps then I would not need to create my own Block diagram and I could access what I need through the Shared Files.
Thanks again.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
I have no idea why the Custom Code Block isn't working for you. The Multiply and Add Cumulator Block (and most of the other Blocks in the Block Diagram for that matter) is only required to resets everything to zero at the beginning of the trading day, so eliminating this requirement should allow it to work (fingers crossed).
Select Share | Charts.
Type scastlem in the Search line and select Search.
Select the scastlem28012 Chart.
Select Open.
We can help you adjust it if necessary based on your feedback.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I got the chart on my screen, but I have several questions.
(1) I did NOT create any blocks. Was I supposed to in order for the indcator to work correctly?
(2) I am not sure I understand the indicator values. Could you explain the meaning of WL Cumulative Intradady Avg Volume and Down? When I divide these two numbers I do not get the same number as the ratio reported on the screen . I get the correct digits after the decimal point, but one number higher. For instance, here are some values on my screen: WL Cumulative Intraday Ave Volume 10 of 2508.574 and Down 10 of 747.3272 and Ratio of 2.356729. When I divide these two numbers I get 2508.574/747.3272 = 3.3567278, which has the same decimal part (excpet for possible rounding difference) but the number reported as ratio is 1 less. Could you explain the numbers.
(3) How do I change the underlying instrument on which the indicator is calculated? When I click on the green WL Cumulative Intraday Avg Volume, the edit menu does not let me change the underlying.
Thank you for your help.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (scastlem) I did NOT create any blocks. Was I supposed to in order for the indcator to work correctly?
No. The reason for dropping the reset to zero at the beginning of the trading day was to prevent the need to create a Custom Code Block.
QUOTE (scastlem) WL Cumulative Intradady Avg Volume and Down? When I divide these two numbers I do not get the same number as the ratio reported on the screen . I get the correct digits after the decimal point, but one number higher. For instance, here are some values on my screen: WL Cumulative Intraday Ave Volume 10 of 2508.574 and Down 10 of 747.3272 and Ratio of 2.356729. When I divide these two numbers I get 2508.574/747.3272 = 3.3567278, which has the same decimal part (excpet for possible rounding difference) but the number reported as ratio is 1 less. Could you explain the numbers.
The WL Cumulative Intraday Ave Volume 10 is the 10-Period Exponential Moving Average of Volume (I probably should have removed the Cumulative part of the name). This includes the Volume for both Bars where the Net Change was Negative as well as Positive.
The Down 10 is the 10-Period Exponential Moving Average of Volume where Volume on Bars were the Price Net Change is negative is counted as actual Volume and is otherwise counted as zero.
The reason your division works except for the decimal point is that the Average Up Volume is computed by taking the Total Average Volume and subtracting the Down Average Volume. You are computing:
(Up + Down) / Down
Instead of:
Up / Down
No consideration was given to the possibility that the Bar Net Change could be zero (it is counted as Up Volume)
QUOTE (scastlem) How do I change the underlying instrument on which the indicator is calculated? When I click on the green WL Cumulative Intraday Avg Volume, the edit menu does not let me change the underlying.
The calculations are not for an individual security or trading instrument. The calculations are done on the Active Watchlist. Changing the Watchlist will cause the calculations to be done on the new Active Watchlist.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for your explanation. Just to make sure I understand, ratio is the exponential moving average of up volume to the exponential moving average of down volume. So, if the Avg Period on WL Cumulative Intraday Avg Volume is set to 10 and the Avg Period of Down is set to 10, then ratio is the ratio of the 10 period exponential moving averege of up volume to the 10 period exponential moving average of down volume. So if I make the period 1, then I will get the ratio of up volume to down vollume over the last bar.
Also, since the red bars represent average down volume, the green bars above the red bars respresent up volulme, since they are the difference between the average of up plus down volume (total volume) minus the down volume.
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
It reads like you understand exactly what is happening.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I would like to get the indicator that you made for me working that resets to zero at the beginning of the trading day. I have been reading the manual, trying to learn how to make my own blocks. Could you recommend any videos to help me make my first block in addition to the three you already mentioned. For instance, I read in an earlier correspondence with a client about a video named, Making Your First Three Blocks, but could not find it.
Also, would it be possible for you to send me a picture of what the block I am supposed to make looks like in terms of the blocks and the connections. That would be very helpful.
Thank you again for all your help.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
The video is available in the Archived videos from Blocks 1.x topic:
Your First 3 Block Diagrams
The following Block Diagram is for the WL Cumulative Intraday Avg Volume Plot:
The following Block Diagram is for the Down Plot:
The following Block Diagram is for the Ratio Plot:
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I am having a problem with creating my own Blocks. After saving and compiling the custom code, when I go to insert the Block into my diagram, it is not there under Block Heading. This happens even when I change the name of the block and change the Friendly Name to match the new name. I tried it on my laptop, and when I go to insert the Custom Block, it works fine. However, I cannot work off my laptop because Blocks crashes my computer, probably because I do not have enough memory.
What do you recommend?
Thank you.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
This is a guess, but it sounds like a symptom of a Custom Code Block that won't compile because of an error of some sort in the code. You may want to go load your Custom Code Blocks one by one and edit them in the Code Block Editor to make sure they compile. Another option would be to remove all of your Custom Code Blocks from the Code\My CodeBlocks folder and add them back one at a time, restarting between each new Custom Code Block to find the offending file. Making sure any Custom Code Blocks you are writing actually work before shutting down is the best way to prevent this type of issue.
All of the above said, the Ask a Trainer forum is not technical support (which is not offered in the forums). The best source of this type of support is technical support itself.
All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival. For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I am working on the blocks and have a couple of questions.
(1) Would it be possible for you to resend the two pictures above. I tried blowing up the pictures to see the words but couldn't get them any clearer so I am using a magnifying glass to read the block names.
(2) For both diagrams, you wrote, "The following Block Diagram is for WL Cumulative Intraday Avg Volume Plot". However, I am wondering if you made a mistake and the second diagram is for "Down". Should I also create a separate Custom Block Diagram for "Down" and does this have any corresponding VB.net code?
(3) When I am completed with the two block diagrams, how do I create the ratio?
Thank you for your help (and patience).
Scott
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
2 more questions:
(1) the Volume block will not change from 1 Day to 30 min when I double click on it. How do I change this block to match yours?
(2) the Equal block in your diagram only apears to have 1 input whereas the Equal Block that gets inserted has 2 inputs. I don't know how to handle this.
Thanks.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
I've re-attached larger images to the original post and added an image for the Ratio Block Digram (although it is the same as in the shared Layout since it doesn't have a Custom Code Block).
The second image is the Block Diagram for Down.
The Volume Block gets its Time Frame from the Chart.
The equal Block only appears to have one input because both of its inputs come from the Time Frame Bar Builder Block and appear to overlap as a result.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
Thank you for the information. I was able to create the block diagrams. I then clicked on SHARE and opened up the chart that you created for me.
I would like to know if you would be able to make a modification to the indicator that you created for me that displays the average of the up/down volume (the one that does not reset to zero at the beginning of the day and that I accessed through the Charts tab). Would it be possible to adjust the indicator so that it only shows two lines: the average of the up/down volume ratio together with a new line that shows the average of the down/up volume ratio. These would be the only two lines on the chart -- so there would be no bars showing the average up volume in green and average down volume in red. It would also be helpful if I could adjust the average length used in the two ratios. Also, would it also be possible to give this chart a different name from WL Cumulative Intraday Avg Volume so that I do not confuse it with the other charts.
Thank you very much for your help.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
Please try the following:
Select Share | Charts.
Type scastlem28012lines in the Search line and select Search.
Select the scastlem28012lines Chart.
Select Open.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
I want to go over several issues regarding the indicator, scastlem28012lines.
(1) It appears that the green color for Volume UD Ratio is for down and the red color for DU Ratio is for up. Shouldn't it be the opposite -- the green for up and the red for down?
(2) The scaling about the x-axis is visually hard to follow. Even though the values are different, the picture is equidistant above and below the x-axis.
(2) I cannot change the lines to bars.
Thank you for your help.
Scott
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
scastlem,
If you don't like the colors, you can change them. Left click on the indicator name (or the indicator itself) to bring up QuickEdit. You can then select the .. to the right of the color to select what you want.
You can also use QuickEdit to change the Lines to Bars by changing the Style from Line to Bar (although this would not work with the Logarithmic Scaling method currently used). It should probably be noted that these Bars will start from Zero however and cover each other up (the starting from zero part is why Logarithmic Scaling doesn't work with Bars).
You can change the scaling Method from Logarithmic to Arithmetic by right-clicking on the indicator name (or the indicator itself) and selecting Scaling Method | Arithmetic.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/3/2008
Posts: 34
|
Bruce,
It is not that I do not like the colors, I want to check with you that indicator is coded correctly and the output is correct. It appears from reading the values on the chart that the ratios are backwards -- the value for Volume UD Ratio (green color) seems to represent the ratio of down / up volume and the DU Ratio (red color) seems to represent the ratio of up / down volume. I believe that it should be the other way around. That is, the Volume UD Ratio should be the ratio of up / down volume (U for up and D for down), and the DU Ratio should be the ratio of the down / up volume (D for down and U for up).
Thank you for your help with this matter.
Scott
|
|
|
Guest-1 |