nibor100
1,046 posts
msg #140521
- Ignore nibor100 |
12/31/2017 3:22:55 PM
@Lapre506,
Sorry, I was answering the same question as Four about " show how many days a stock has shown up on a filter" but apparently that is not what you really wanted.
SF users can probably help save you time and some manual data entry if you can provide more concise clues as to what data you actually want in Excel and what you are doing with it in Excel.
Best I can tell from your more recent posts you now want either 1 or 2 months of your filter results data for all stocks loaded into Excel, apparently to do backtesting you can't accomplish in SF, or you want 1 or 2 months of data in Excel for a single stock only on past days it had a filter hit, to do the backtesting in Excel.
If you use Four's suggested approach you will be able to see clearly which days in the past any stock has met your filter as long as it meets the filter on the day you run it, so then you will know which specific days to manually load CSV files which should save you some time.
Plus, if you copy all of your downloaded CSV spreadsheets into separate tabs of the first downloaded CSV spreadsheet, For the Same Stock, you should be able to use workbook formulas across multiple spreadsheet tabs to more easily process the data.
Another approach would be to set up your filter to have its results sent to you nightly, already structured as a CSV file, so from now on all you have to do is open it and copy to your master spreadsheet in Excel. There is 1,000 symbol limit on that approach. (Personally, I use the HTML email format and just copy the data I want into Excel without messing with a CSV).
There may even be some backtest type of analysis that can be done using SF capabilities that you haven't tried but that would require some additional info from you on what kind of backtesting you are using Excel for.
Hope this helps some,
Ed S.
|