glgene
613 posts
msg #102711
- Ignore glgene |
9/25/2011 10:48:46 PM
9/25/2011 10:44:03 PM
Is there a way of combining the pricing of, say, the value of 2 stock symbols? Such as VTI and JJC.
I tried this script, and it didn't work. Said I needed to debug it.
If this doable, I would then add other info to the script. In essence, I would like to use the combined value in MA and other indicator calculations. But first...is it doable? If so, how would I rewrite the script above to get the combined value of VTI and JJC?
Many thanks in advance.
Gene
|
four
5,087 posts
msg #102714
- Ignore four |
9/26/2011 12:05:06 AM
|
glgene
613 posts
msg #102717
- Ignore glgene |
9/26/2011 9:03:53 AM
four,
Yup, that does it. Thanks! But could you tell me the significance of IND in your script? I have looked it up in Help, and am not quite sure. Could you put it (IND) in a simple English statement, that even my mother would understand?
Gene
|
Kevin_in_GA
4,599 posts
msg #102718
- Ignore Kevin_in_GA |
9/26/2011 9:09:03 AM
IND = indicator
IND will return the value for a specific stock or index. The typical syntax looks like these examples:
IND(^spx,close) = returns the clsosing value for the S&P 500 index
IND(AAPL, rsi(2)) = returns the rsi(2) value for Apple
You can also create custom user variables, then have them referred to within IND:
set{ophi, open / high}
ind(APPL, ophi)
Useful bit of code - more people should be aware of it and how it can be used.
|
glgene
613 posts
msg #102719
- Ignore glgene |
9/26/2011 9:46:22 AM
Thanks, Kevin.
So....I added this line to four's script (above) and I don't think I got the right answer. Seems too low
set{d, ind(c,ema(20))}
add column d
What I am after is the EMA(20) of c (the combined value of VTI + JJC).
???
|
glgene
613 posts
msg #102727
- Ignore glgene |
9/26/2011 1:29:45 PM
Here is my attempted script (using four's original idea, and trying to add an EMA(20) to the mix. My addition can't be correct, based on the results.
This line must be wrong:
set{d, ind(c,ema(20))}
My objective is to print (and draw) the combined EMA(20) of VTI+JJC.
Any help here? The acid test is the result of the combined EMA(20) of VTI + JJC. My resulting number can't be correct (it is way too low), considering the EMA(20) of VTI and JJC (as shown in the column output).
???
Why am I attempting this? Because I have read that the action of copper (JJC as my proxy) is a precursor for the broad market. Rather than accepting that statement completely, I would like to merge JJC and VTI to get a combined result. Thus, I'm not relying soley on JJC or VTI, but combining the two and measuring that combined price against its combined EMA(20).
Any help on fixing my one line of script (as shown above) would be appreciated. Thanks.
Gene
|
four
5,087 posts
msg #102734
- Ignore four |
9/26/2011 9:19:06 PM
|
glgene
613 posts
msg #102735
- Ignore glgene |
9/26/2011 9:45:27 PM
four,
Bingo! You corrected my mistake. Thank you.
Based on your suggested revised script, here are my most recent findings to test my "logic" of using JJC as part of the barometer of the overall market. That is, VTI+JJC. That combined field got you an EMA(20) crossover on 4/29/11 (sell). Since that date VTI is -16.03%. What a time to be in cash (or short).
Using strictly a VTI EMA(20) crossover, it would have generated a 'sell' on 5/5/11, after which there has been a 14.09% drop in VTI.
I realize that just one testing period does not constitute ample testing. But it's a start. I'll do more testing and post my results here.
By the way, after looking at your output, I think I should have averaged (instead of added) VTI and JJC values. The crossovers should be identical. An average value just looks more realistic. Do you agree or disagree?
Gene
|
glgene
613 posts
msg #102769
- Ignore glgene |
9/29/2011 2:24:30 PM
The link below was included in the 9-28-2011 WSJ online service, regarding Copper and its comparative chart with SP:
http://blogs.wsj.com/marketbeat/2011/09/28/dr-coppers-diagnosis-still-dire/?mod=google_news_blog
Using the SF script initially thought by me (but edited correctly by 'four'), one would use the combined price of VTI and JJC and compare that to the combined EMA(20) of those two symbols. If the combined price > combined EMA(20) that would signal a buy (for the broad mkt.). Less, a sell. Right now (1:10 pm, 9-29-11), that would not favor a long position (price is 93.4% of EMA).
Maybe, or maybe not, the EMA(20) is the best parameter. I haven't tried any other number.
FWIW,
Gene
|
glgene
613 posts
msg #102770
- Ignore glgene |
9/29/2011 6:42:25 PM
There are addt'l changes to my script for this message, basically to show the "bottom line" result of dividing the duo price of VTI + JJC by the duo EMA(20) of VTI + JJC. Shows it in % form.
For example, close of day, 9-29-2011shows a Duo price of $101.72 / Duo EMA(20) of $107.80, which = 93.71%. Anything less than 100% would indicate NOT to be long in VTI (or other broad-based, equity-type ETF if you used this Duo indicator as a barometer for an overall buy-sell signal.
I'm still not showing one thing, though, in the Chart view, that I would like to display: the Price/EMA crossover lines --- not only for the Duo result, but also the original VTI and JJC price/EMA crossovers. I must have faulty draw commands. ??
Any help would be appreciated. Thanks.
Gene
|