Help, friends. Is there a better way to implement this data model?

Help, friends. Is there a better way to implement this data model?

My English level is not good, now use translation tools, if you have not understand the place, welcome to leave a message oh.

I built a data model to measure the return rate of the stock market. The data sources include [Date], [Opening], [Lowest], [Maximum], [Close],

The following data is a function I wrote：

[Entrustment buy price] and [Entrustment sell price] for the next trading day

Entrustment buy price = [Close ]*(1-parameter)

Entrustment sell price = [Close ]*(1+parameter)

Successful device purchase when [Entrustment Buy price] > [Lowest] of next trading day;

Successful consignment sale occurs when [Entrustment sell price] is < [Maximum] on the next trading day

;

I wrote the judgment company as follows:

[Entrustment buy result] =

var _minnext = MINX(FILTER('table',[Date]>EARLIER('table'[Date]) ),[Date])

var _weimai = AVERAGEX(FILTER('table',[Date]=_minnext ),[Lowest])

return IF(_weimai<[Entrustment buy price],"Successful entrusted purchase","")

[Entrustment sell result] =

var _minnext = MINX(FILTER('table',[Date]>EARLIER('table'[Date]) ),[Date])

var _weimai = AVERAGEX(FILTER('table',[Date]=_minnext ),[Maximum])

return IF(_weimai>[Entrustment sell price],"Successful consignment sale","")

When Successful discrepancy purchase, only Successful consignment sale can continue to buy stocks;

[Position to judge] indicates whether it is available for purchase.

Position to judge =

var _wmjsjmax = MAXX(FILTER('table', [Date]

var _wmcsjmax = MAXX(FILTER('table',[Date]sale" ),[Date])

return

If (_wmcsjmax < _wmjsjmax, 1, 0)

[Position the results] represents the time node of (Successful discrepancy purchase) or (Successful consignment sale),

Position the results =

var _datemin = minx(FILTER('table', [Date]>EARLIER('FILTER'[Date])),[Date])

var _val = SUMX(FILTER('table', [Date]=_datemin),Position to judge])

return [Position to judge]-_val

Cost of purchase = ROUND( if([Position the results]=-1,[Entrustment buy price],BLANK()),2)

Sell price = ROUND( if([Position the results]=1,[Entrustment sell price],BLANK()),2)

Trading profit =

var _maxdate = MAXX(FILTER('table', [Date]BLANK()),[Date])

var _val = SUMX(FILTER('table', [Date] = _maxdate),[Cost of purchase])

return IF([Sell price]=BLANK(),BLANK(),DIVIDE([Sell price]-_val,_val))

_________________________________________________________________________________________

The calculated value of [Entrustment buy price] and [Entrustment sell price] is calculated through (parameters), but not through (create measures). Therefore, (parameter) can only be manually adjusted.

I hope to know different (parameters). When the value of (parameters) is what, Trading profit can be maximized.

And what better way to implement this data model?

Thank you for your help