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



Fetcher[
/*
Use SET with COUNT:
1 returned for each line that is TRUE
0 returned for each line that is FALSE
*/

/*FIRST LINE: low crossed above 50 becomes:*/

set{low50, count(low crossed above 50,1)}

/*SECOND LINE: rsi(12) above 60 becomes:*/

set{rs12, count(rsi(12) above 60,1)}

draw rsi(12)
draw low50
draw rs12
add column low50
add column rs12

/*add the set statements*/

set{sum1, low50 + rs12}

/*Only display charts when both lines in filter are TRUE for the displayed day*/

add column sum1 equals 2
]



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,031 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,031 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,031 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

*** 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.