[110] Filters Ignored (> Add Net Profit per M/Y Filter Options)

I recently found the same issue in 3.8.2 but figured better to post it here.
I apply the Filter Avg. Profit Per Month set to Full Sample with condition <= $0 for both Ranking & Filtering and Cross Checks but it is ignored.

You'll need to make sure to document how to set Full Sample, IS or OOS. They get set to IS by default and I only figured out how to change it by accident.
* For anyone wanting to know how to edit Filter settings, you double-click on the Filter after you've added it then you'll get an editing window like the attached image.
Attachments
SQ110 - Edit Filter.png
(20.46 KiB)
SQ110 - Avg Profit Per Month LT0.png
(46.24 KiB)
  • Votes 0
  • Project StrategyQuant X
  • Type Feature
  • Status Moved
  • Priority Normal
  • Assignee Mark Fric
  • Milestone Build 111

History

Ad
#1

drayzen

11.09.2018 05:13

Task created

Ad
#2

drayzen

11.09.2018 05:26

Attachment Filter - Avg Profit Per Month.xml deleted

Ad
#3

drayzen

11.09.2018 05:27

Attachment Filter - Avg Profit Per Month.xml added

I think I had the operator around the wrong way.

Still a little confused given this seems to only be working intermittently, that is provided it's function is what I'm thinking.

My expectation is that setting Avg. Profit Per Month > $0 requires there to be a profit for each and every month in the test period.

If this is just and average of the entire test period then the option is useless along with the Daily and Yearly being redundant because that would mean Per Day x30 = Per Month and Per Month x12 = Per Year.


If that is correct, maybe the 'Avg.' can be removed from these # of Trades and Profit Per d/m/y Filters and make them absolute for the nominated period so they can actually be useful.

MF
#4

Mark Fric

11.09.2018 08:54

Assignee changed from Mark Fric to Mark Fric

Status changed from New to Waiting for information

Milestone changed from None to Build 111

Avg. Profit Per Month is average of all profits, it doesn't guarantee that profit for every moonth will be > 0. 


What you want is a "Minimal profit per month". It is possible to compute statistics like this, but I think this condition will be extremely strict. It would be extremely difficult to find a strategy that will have all months profitable in real trading.

Ad
#5

drayzen

11.09.2018 14:51

Hi Mark,

Yes, that sounds like what I'm after. I realise a monthly application is very strict, but we are chasing the 1/1M after all...  ;)

I'm doing a brute force approach with Random Generation so this suits, and if I can find some with this then, yipee!

Now just waiting for AMD to release a 7nm 64C/128T Threadripper to really put the hurt on those numbers...

This also seems to me a way to apply minimal complexity of filtering to target a high quality outcome.


If you can please add the following in a future build it would be appreciated:

Minimum Profit Per Month

Minimum Profit Per Year


I am still curious about those 'Avg.' filters, is their behaviour as I detailed where they are an average over the entire test period and equivalent by x30 and x12?


p.s. I sent you some Forum messages, did you receive them?

thanks, Al

Ad
#6

drayzen

14.09.2018 00:59

Attachment SQ111 Net Profit per X.png added

Hi Mark,

I was thinking further on this and it would make more sense to align with current naming conventions, so use Net Profit:

  • Net Profit per Month ±
  • Net Profit per Year ±

You'll notice I've added the http://unicode.org/cldr/utility/character.jsp?a=00B1 suffix to indicate the input supports negative values.

The only issue might be some users perceiving that to mean deviation, in which case another way of displaying input options would need to be used.

As you pointed out this would be a strict requirement if the only input option is => 0, if you can enable negative numbers for the input it can be set to e.g. => -12.5% so as to allow for losses while restricting them to a floor level.


thanks, Al

Ad
#7

drayzen

14.09.2018 01:02

Subject changed from [110] Filters Ignored to [110] Filters Ignored (> Add Net Profit per M/Y Filter Options)

Type changed from Bug to Feature

Update Type & Title
MF
#8

Mark Fric

19.09.2018 09:38
Task moved to project SQ Programming, new link to task: https://sq.projectpanel.com/tasks/sqp_0001

Votes: 0

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please