I think Excel is a great tool for the type of ideas we have bounced back and forth.
I rely heavily on the AnalyzerXL add-in that I started working with years ago. They have a suite of products (each at a cost). But I rely only use the BulkQuotesXL Pro but it is $75
http://www.analyzerxl.com/products/data-download-tools/bulkquotesxl-pro
It allows you to set up multiple symbol portfolios and then update at anytime with a single click. I use two files in Excel on a weekly basis. One to keep and update the raw data and one to do the sorting. The sorting file I have created some simple macros to sort at different time frames.
I would call myself an above average Excel user, but in no way an advanced user.
There is a highly active yahoo group for the smf-addin. This addin does essentially the same function but it really takes up a lot more time to learn and to keep up with updates. The users love it. Randy Harmelink is the moderator.
Too much time for me so I stay with AnalyzerXL.
Also beware of changes that happened with Yahoo quotes servers a couple of months ago. It threw EVERYBODY off of center. Everyone from Analyzer XL to the smf-addin group was down. AnalyzerXL for almost two months. Randy found a workaround in two or three weeks. All seems stable again. Just be careful of any downloader sites that isn't dated within the last month or so.
Here's one of the Sector Surfer play portfolios that I set up to watch as of last Friday. It's got a history of 34% over three years, 25% over 10 years and 23% over 29 years. But not very safe and a 49% MDD (ouch). Just playing...
I rely heavily on the AnalyzerXL add-in that I started working with years ago. They have a suite of products (each at a cost). But I rely only use the BulkQuotesXL Pro but it is $75
http://www.analyzerxl.com/products/data-download-tools/bulkquotesxl-pro
It allows you to set up multiple symbol portfolios and then update at anytime with a single click. I use two files in Excel on a weekly basis. One to keep and update the raw data and one to do the sorting. The sorting file I have created some simple macros to sort at different time frames.
I would call myself an above average Excel user, but in no way an advanced user.
There is a highly active yahoo group for the smf-addin. This addin does essentially the same function but it really takes up a lot more time to learn and to keep up with updates. The users love it. Randy Harmelink is the moderator.
Too much time for me so I stay with AnalyzerXL.
Also beware of changes that happened with Yahoo quotes servers a couple of months ago. It threw EVERYBODY off of center. Everyone from Analyzer XL to the smf-addin group was down. AnalyzerXL for almost two months. Randy found a workaround in two or three weeks. All seems stable again. Just be careful of any downloader sites that isn't dated within the last month or so.
Here's one of the Sector Surfer play portfolios that I set up to watch as of last Friday. It's got a history of 34% over three years, 25% over 10 years and 23% over 29 years. But not very safe and a 49% MDD (ouch). Just playing...
Join the InvestorsHub Community
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
