| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 4/3/2005
Posts: 41
|
Is it possible, even if it means exporting data to Excel, to create an Up/Down volume ratio (for the major indexes) and an Advance/Decline ratio? Reason for asking is due to research by others.
For instance, Mark Boucher has tested that when 5 day moving avg of Up Volume over Total Volume exceeds 77% the S&P returns 25.3% annualized over the next 3 months.
For advance/decline, when the ratio of the 11 day moving avg of advances over 11 day moving avg of decliners exceeds 1.9 a similar type of move as above occurs.
Tim
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
5-day Up Volume as a % of Total 5-day volume:
((((C>C1)*V)+((C1>C2)*V1)+((C2>C3)*V2)+((C3>C4)*V3)+((C4>C5)*V4))*-1)/(AVGV5*5)*100
Up volume/down volume ratio 11-day
((((C>C1)*V)+((C1>C2)*V1)+((C2>C3)*V2)+((C3>C4)*V3)+((C4>C5)*V4)+((C5>C6)*V5)+((C6>C7)*V5)+((C7>C8)*V7)+((C8>C9)*V8)+((C9>C10)*V9)+((C10>C11)*V10))+1)/((((C<C1)*V)+((C1<C2)*V1)+((C2<C3)*V2)+((C3<C4)*V3)+((C4<C5)*V4)+((C5<C6)*V5)+((C6<C7)*V5)+((C7<C8)*V7)+((C8<C9)*V8)+((C9<C10)*V9)+((C10<C11)*V10))+1)
- Craig
Here to Help!
|
|
 Gold Customer
Joined: 11/17/2007
Posts: 28
|
In TC2000 12.4 Platinum, is it possible to stream watchlist data into Excel for live analysis? End of day data would be fine too if can't do live.
If so how can it be done?
Ken D
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It is not possible to stream data into Excel from any version of TC2000. You can export only one symbol at a time in TC2000 version 12.4. If you want to export an entire WatchList of data at a time, you would need to use TC2000 version 7.
Exporting data to text format - comma, space or tab delimited
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/3/2013
Posts: 57
|
Please help w/ a Up/Down Volume Ratio PCF.
Thesis: Up/Down Volume Ratio = ratio of toatal volume on up-closing days, divided by the total volume on down-closing days, over 50 trading sessions.
A value of >1 usually indicates more buying than selling interest, & a value <1 indicates greater selling. Accumulation/Distribution
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Indicator Formula.
(V * (C > C1) + V1 * (C1 > C2) + V2 * (C2 > C3) + V3 * (C3 > C4) + V4 * (C4 > C5) + V5 * (C5 > C6) + V6 * (C6 > C7) + V7 * (C7 > C8) + V8 * (C8 > C9) + V9 * (C9 > C10) + V10 * (C10 > C11) + V11 * (C11 > C12) + V12 * (C12 > C13) + V13 * (C13 > C14) + V14 * (C14 > C15) + V15 * (C15 > C16) + V16 * (C16 > C17) + V17 * (C17 > C18) + V18 * (C18 > C19) + V19 * (C19 > C20) + V20 * (C20 > C21) + V21 * (C21 > C22) + V22 * (C22 > C23) + V23 * (C23 > C24) + V24 * (C24 > C25) + V25 * (C25 > C26) + V26 * (C26 > C27) + V27 * (C27 > C28) + V28 * (C28 > C29) + V29 * (C29 > C30) + V30 * (C30 > C31) + V31 * (C31 > C32) + V32 * (C32 > C33) + V33 * (C33 > C34) + V34 * (C34 > C35) + V35 * (C35 > C36) + V36 * (C36 > C37) + V37 * (C37 > C38) + V38 * (C38 > C39) + V39 * (C39 > C40) + V40 * (C40 > C41) + V41 * (C41 > C42) + V42 * (C42 > C43) + V43 * (C43 > C44) + V44 * (C44 > C45) + V45 * (C45 > C46) + V46 * (C46 > C47) + V47 * (C47 > C48) + V48 * (C48 > C49) + V49 * (C49 > C50)) / (V * (C < C1) + V1 * (C1 < C2) + V2 * (C2 < C3) + V3 * (C3 < C4) + V4 * (C4 < C5) + V5 * (C5 < C6) + V6 * (C6 < C7) + V7 * (C7 < C8) + V8 * (C8 < C9) + V9 * (C9 < C10) + V10 * (C10 < C11) + V11 * (C11 < C12) + V12 * (C12 < C13) + V13 * (C13 < C14) + V14 * (C14 < C15) + V15 * (C15 < C16) + V16 * (C16 < C17) + V17 * (C17 < C18) + V18 * (C18 < C19) + V19 * (C19 < C20) + V20 * (C20 < C21) + V21 * (C21 < C22) + V22 * (C22 < C23) + V23 * (C23 < C24) + V24 * (C24 < C25) + V25 * (C25 < C26) + V26 * (C26 < C27) + V27 * (C27 < C28) + V28 * (C28 < C29) + V29 * (C29 < C30) + V30 * (C30 < C31) + V31 * (C31 < C32) + V32 * (C32 < C33) + V33 * (C33 < C34) + V34 * (C34 < C35) + V35 * (C35 < C36) + V36 * (C36 < C37) + V37 * (C37 < C38) + V38 * (C38 < C39) + V39 * (C39 < C40) + V40 * (C40 < C41) + V41 * (C41 < C42) + V42 * (C42 < C43) + V43 * (C43 < C44) + V44 * (C44 < C45) + V45 * (C45 < C46) + V46 * (C46 < C47) + V47 * (C47 < C48) + V48 * (C48 < C49) + V49 * (C49 < C50))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/3/2013
Posts: 57
|
Bruce,
I like it & thank you for the PCF!
For a period < 50 bars, I would just take off both sides of the formula? For example, if I wanted a 49 day period I would eliminate the following:
+V49 * (C49 < C50)
+ V49 * (C49 > C50)
Thank you again!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
That is exactly what you would need to do to shorten the formula. if it gets too short, you might want to add some sort of term to the denominator (like + .00001) to avoid division by zero issues.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |