| StockFetcher Forums · General Discussion · Probably a dumb question | << 1 2 >>Post Follow-up |
| JoeyVinyl 125 posts msg #140497 - Ignore JoeyVinyl |
12/30/2017 11:53:44 AM I'm trying to see if there's a way to show how many days a stock has shown up on a filter other than downloading a .csv file and putting it into a spreadsheet (which is not difficult but why do it that way if I don't have to, right?). I was looking at the Days Since indicator but I don't think that would work for this purpose. Has anyone else tried to put this in a filter, and if you were able to, would you be willing to share how? Thanks. |
| four 5,087 posts msg #140504 - Ignore four modified |
12/30/2017 3:33:47 PM Visually 1. run filter 2. click historical (found under stock name) CB - Chubb Limited 3m, 6m, 1y, 2y, historical 3. chart displays an indicator (triangle) each time the stock matched the target filter over the last year. |
| Lapre506 48 posts msg #140507 - Ignore Lapre506 |
12/30/2017 7:15:34 PM Four.. kinda related. Is there a way to get a CSV of say the past month of hits on a filter all in one file so I can import them into a spreadsheet? Basically I manually backtest my filters entry by entry day by day. The CSV is great for one days worth of data but is there a trick to get a mass period of time together in one CSV? |
| four 5,087 posts msg #140508 - Ignore four modified |
12/30/2017 10:40:27 PM Visually by chart  |
| four 5,087 posts msg #140509 - Ignore four modified |
12/30/2017 10:42:48 PM Lapre506 Is there a way to get a CSV of say the past month of hits on a filter all in one file -- I don't believe it is possible in StockFetcher. |
| karennma 8,057 posts msg #140511 - Ignore karennma |
12/31/2017 7:23:16 AM four 4,030 posts msg #140504 - Ignore four modified 12/30/2017 3:33:47 PM Visually 1. run filter 2. click historical (found under stock name) ========================================== Re: "click historical" Uhhhh .. Historical? Did you skip a step? Where is that? |
| nibor100 1,010 posts msg #140513 - Ignore nibor100 |
12/31/2017 11:22:28 AM Only see historical in chart display mode after u run filter. Does not show in table mode Ed S. |
| nibor100 1,010 posts msg #140514 - Ignore nibor100 |
12/31/2017 11:48:02 AM I should have stated we only see "historical" as Four described it when we are in chart mode. In table mode, if you have 'Quick Links' activated you'll see historical to the far right, if you don't have Quick Links activated you have to click on the Settings icon to the far right for each stock. Hope this is clearer, Ed S. |
| nibor100 1,010 posts msg #140517 - Ignore nibor100 |
12/31/2017 12:30:00 PM @Lapre506, I believe if you add the following line to Four's latest example filter you will get a table column showing the total count for all of the times a given stock which meets his filter today, has met that same filter in the past year. add column count(sum1 equals 2, 252) If you want the count for a month, replace the 252 by the # of trading days in the past month. It appears that Count will only go back 252 days when used in this manner. Ed S. |
| Lapre506 48 posts msg #140518 - Ignore Lapre506 |
12/31/2017 1:57:50 PM Thanks for the reply. But that's not really what I am trying to accomplish. Basically I wanted to know if there was a way to download a CSV of the hits over the past 1-2 months of a filter so I could import it into a spreadsheet with 1 CSV file. Currently when you you click download CSV you only get the entries for that one day in a file. I wanted the past 2 months consolidated into one file so when I go to backtest my filter in a spreadsheet I'd already have all the entries. But doesn't look like there is a way. So back to manually entering all the data :( |
| StockFetcher Forums · General Discussion · Probably a dumb question | << 1 2 >>Post Follow-up |