StockFetcher Forums · General Discussion · Correlation analysis<< >>Post Follow-up
dtatu
134 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
938 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
134 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
938 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
134 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
938 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
134 posts
msg #159316
Ignore dtatu
7/17/2022 7:19:57 AM

Thanks Ed

StockFetcher Forums · General Discussion · Correlation analysis<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.