dtatu
143 posts
msg #159275
- Ignore dtatu
modified |
7/9/2022 8:53:28 AM
Question: is there an easy way to limit the signals to symbols correlated <0.7 to my existing positions?
Let's say I apply it to all NYSE stocks against my watchlist " My LONGS".
Or against a symlist of my positions?
Thanks
|
nibor100
1,031 posts
msg #159277
- Ignore nibor100 |
7/9/2022 6:56:55 PM
An example of the correlation being met and not met would be helpful in answering your question.
Thanks,
Ed S.
|
dtatu
143 posts
msg #159281
- Ignore dtatu |
7/11/2022 4:21:36 PM
show stocks where market is NYSE
weekly close crossed above weekly Wma(20)
add column corr(spy,30,Close) below 0.7
add column corr(spy,60,Close) below 0.7
add column corr(spy,90,Close) below 0.7
simple example:
- I'd like to replace spy with either a Watchlist( ideally), or a symlist (with my open positions in it)
Thanks
|
nibor100
1,031 posts
msg #159286
- Ignore nibor100 |
7/12/2022 9:35:41 AM
No obvious way to do this in SF that I'm aware of.
I have 2 possible ways to get it done but I need 3 more pieces of info:
1. Are all of your watchlist/open positions stocks in market NYSE?
2. How many stocks are in your watchlist/open positions usually?
3. Do you have the SF advanced subscription?
Thanks,
Ed S.
|
dtatu
143 posts
msg #159314
- Ignore dtatu
modified |
7/16/2022 11:38:18 AM
Thanks for looking into it.
1. No: I have stocks and ETF from all over the place
2. In all the accounts concerned I have , at any time between 130-150 positions open( long+ short); I trade only on weekly or monthly signals.
3. No: I do not have the advanced SF subcription , as , so far , not needed, but I definitely change if a solution is possible.
I think I've seen some correlations done on a Matrix on one site.My skills are very limited, though, in programming.I would not know how to do it efficiently
|
nibor100
1,031 posts
msg #159315
- Ignore nibor100 |
7/16/2022 2:00:08 PM
Your answers eliminate my two ideas as workable solutions.
Below is an address to an Edgerater blog on his correlation matrix template which might solve your needs and his sw has weekly and monthly capabilities for charting etc.
Ed S
https://academy.edgerater.com/how-to-find-correlated-stocks-and-alpha-beta-values/
|
dtatu
143 posts
msg #159316
- Ignore dtatu |
7/17/2022 7:19:57 AM
Thanks Ed
|