marine2
963 posts
msg #114979
- Ignore marine2 |
8/20/2013 2:21:59 PM
Is there anyone out here that knows how to create a filter that compares two stocks against each other, graphically (chart form), that shows visually their relationship between them. Example showing SPY vs GLD on one chart.
Taking this concept a little deeper, show two equities (stocks or ETF's) where their price lines cross and go in different directions.
Looking for equities that are like oil and water to each other. Can anyone write a filter showing this unique interaction between two equities?
Your help on this is always appreciated.
|
dangreene
229 posts
msg #114980
- Ignore dangreene |
8/20/2013 2:58:37 PM
marine2
This should give you a start.
|
dangreene
229 posts
msg #114981
- Ignore dangreene |
8/20/2013 3:01:58 PM
|
marine2
963 posts
msg #114982
- Ignore marine2 |
8/20/2013 3:03:14 PM
Thank you. I will fiddle with this and see how it works for me.
|
marine2
963 posts
msg #114983
- Ignore marine2 |
8/20/2013 3:16:54 PM
Is there any way to create a filter that would automatically show us opposite in nature equities, showing the two equities on one chart not two individual ones? Or if it couldn't do this graphically maybe it could show us the opposites in list form?
|
yepher
359 posts
msg #114985
- Ignore yepher
modified |
8/20/2013 3:47:48 PM
@marine2
You can display the two on the same chart by doing something like this:
See the "sym1,sym2" graph
I am not 100% sure what you meant by the other part of your question. You cannot automatically scan all stocks to see which ones cross and diverge. You can determine which ones are like oil to a specific water. To do that you need to use the crosses or converges some number of days and and diverging with ind(...). The symbol in "ind(...)" is the water and it will find the oil for you ;)
|
Kevin_in_GA
4,599 posts
msg #114988
- Ignore Kevin_in_GA |
8/20/2013 4:19:41 PM
No surprise here that the inverse etfs for ^SPX are at the top of this list, but there are some toher candidates that might be of interest.
Another thought - within the S&P 500 there are likely to be a top and bottom correlated stock - perhaps these would be a good "oil and water" pair?
Among the highest correlated is GOOG, and among the lowest is AAPL. Here's a chart over the past year:
http://stockcharts.com/h-sc/ui?s=AAPL&p=D&yr=1&mn=0&dy=0&id=p74885195661
|
marine2
963 posts
msg #114990
- Ignore marine2 |
8/20/2013 9:01:33 PM
Thanks to all of you for helping me on this subject. Wishing you good returns on your investment actions.
|