CAGR formula translation

This topic has 10 replies, 4 voices, and was last updated 4 years ago by undefined.

Viewing 11 posts - 1 through 11 (of 11 total)

09/21/2016 at 11:30 AM #13470

Stef

How do I translate this to Probuilder language:

cagr=((equity/startcapital)^(1/nryears))-1

1	cagr=((equity/startcapital)^(1/nryears))-1

PRT does not like the “^” (power of) symbol.

Regards

Stef

Participant

Topics: 20

Replies: 52

Been thanked: 15 times

09/21/2016 at 7:30 PM #13509

Nicolas

I’m sorry, I spent almost 2 hours doing maths formulas to solve the MathPow being not available in math instructions of the platform.. Didn’t solve the formula because of the fractionnal exponent. Seems that I could calculate something if the ‘nryears’ is below 3 but not above.

I have just sent a request to PRT dev team to add the MathPow possibility in the language, as it is not the first time i’m stuck with this! 🙁

If any math genius come here, I’ll be glad to have his opinion 🙂

Nicolas

Keymaster

Topics: 81

Replies: 20828

Been thanked: 4742 times

09/21/2016 at 11:41 PM #13512

JC_Bywan

Ok, I guess I’ve become a PRC-addict, even when I’m away from my trading station I feel the need to come and read what happened since last visit, haha

Assuming nryears is an integer, how about a recursive approach, for which the number of iterations would depend on the required precision in the end by the user?

Let’s say to simplify the formula writing that A=equity/startcapital and n=nryears

and let’s name B = (equity/startcapital)^(1/nryears) = A^(1/n)

so B^n = A = B * B^(n-1)

B = A / B ^(n-1)

and if I use i to rank the iterations from 1 to maximum i desired for sufficient precision and {} for index:

B{rank i+1} = ( B{rank i} + B{rank i} ) / 2

B{rank i+1} = ( B{rank i} + A / (B{rank i} ^(n-1) ) / 2

and a code with 2 loops to use the formula:

something like:

B=1

for i=1 to 10 //(try 20 and 30 and... to see how much is enough for required accuracy in the end)

previousB=B

den=B

for j=2 to nryears-1
den=den*B
next

B=(previousB + (equity/startcapital)/den)/2

next

cagr=B-1

B=1

for i=1 to 10 //(try 20 and 30 and... to see how much is enough for required accuracy in the end)

previousB=B

den=B

for j=2 to nryears-1

den=den*B

B=(previousB + (equity/startcapital)/den)/2

cagr=B-1

However, I can’t launch prt and test it from here, so it’s probably bugged as I often need to make changes to first writing before getting it right… Also, I have never tried a loop inside a loop in PRT before, don’t know if it can handle it.

1 user thanked author for this post.

Nicolas

JC_Bywan

Moderator

Topics: 20

Replies: 2549

Been thanked: 839 times

09/22/2016 at 6:53 AM #13516

Stef

@Nicolas, I could not solve it either. But, I did come up with the following “indicator” – that can be added to the end of any strategy backtesting code.

// yearly and monthly returns
once startcapital=100000 // initial capital amount
once yearstartcap=startcapital // set initial capital for 1st year
once mstartcap=startcapital // set initial capital for 1st month

if day<day[1] and month=1 then // new year
endcapital=startcapital+strategyprofit // ending capital for the year (previous year)
prof=endcapital-yearstartcap // profit for the year (previous year)
yearstartcap=endcapital // set starting capital for the new year
yearreturn=(prof/startcapital)*100 // yearly return as percentage (previous year)
endif

if day<day[1] and month>month[1] then // new month
mendcapital=startcapital+strategyprofit // ending capital for the month (previous month)
mprof=mendcapital-mstartcap // profit for the month (previous month)
mstartcap=mendcapital // set starting capital for the new month
mreturn=(mprof/startcapital)*100 // monthly return as percentage (previous month)
endif


graph 0 coloured(0,0,255) // graph zero line
graph yearreturn coloured(0,200,0) as "Yearly Return %" // graph yearly return (prev year)
graph mreturn coloured(154,0,154) as "Monthly Return %" // graph monthly return (prev month)

// yearly and monthly returns

once startcapital=100000 // initial capital amount

once yearstartcap=startcapital // set initial capital for 1st year

once mstartcap=startcapital // set initial capital for 1st month

if day<day[1] and month=1 then // new year

endcapital=startcapital+strategyprofit // ending capital for the year (previous year)

prof=endcapital-yearstartcap // profit for the year (previous year)

yearstartcap=endcapital // set starting capital for the new year

yearreturn=(prof/startcapital)*100 // yearly return as percentage (previous year)

endif

if day<day[1] and month>month[1] then // new month

mendcapital=startcapital+strategyprofit // ending capital for the month (previous month)

mprof=mendcapital-mstartcap // profit for the month (previous month)

mstartcap=mendcapital // set starting capital for the new month

mreturn=(mprof/startcapital)*100 // monthly return as percentage (previous month)

endif

graph 0 coloured(0,0,255) // graph zero line

graph yearreturn coloured(0,200,0) as "Yearly Return %" // graph yearly return (prev year)

graph mreturn coloured(154,0,154) as "Monthly Return %" // graph monthly return (prev month)

It calculates yearly and monthly returns, and looks like this (see attachment).

I would appreciate any comments or suggestions for improvements.

Regards

Stef

1 user thanked author for this post.

Bard

Stef

Participant

Topics: 20

Replies: 52

Been thanked: 15 times

09/22/2016 at 7:06 AM #13522

Stef

@Noobywan. Tx, will try it.

Stef

Participant

Topics: 20

Replies: 52

Been thanked: 15 times

09/22/2016 at 7:57 AM #13525

Nicolas

@Noobywan

Your code is good. It successfully returned the good value for the Wikipedia example attached.

Here is the code with the same value:

B=1
equity = 13000
startcapital = 9000
nryears = 3

for i=1 to 10 //(try 20 and 30 and... to see how much is enough for required accuracy in the end)

previousB=B

den=B

for j=2 to nryears-1
den=den*B
next

B=(previousB + (equity/startcapital)/den)/2

next

cagr=B-1

RETURN cagr

B=1

equity = 13000

startcapital = 9000

nryears = 3

for i=1 to 10 //(try 20 and 30 and... to see how much is enough for required accuracy in the end)

previousB=B

den=B

for j=2 to nryears-1

den=den*B

B=(previousB + (equity/startcapital)/den)/2

cagr=B-1

RETURN cagr

Well done! Fractional exponent gimme headache yesterday, you desserve a beer again! 🙂 Maybe I’ll add a post in the Blog in your own name.

Nicolas

Keymaster

Topics: 81

Replies: 20828

Been thanked: 4742 times

09/22/2016 at 6:26 PM #13555

Nicolas

@Stef

You add the code about monthly and yearly returns in the Library, but I don’t see any code of ITF file attached to your post. Could you please, gimme here? Thanks.

Nicolas

Keymaster

Topics: 81

Replies: 20828

Been thanked: 4742 times

09/23/2016 at 5:37 AM #13576

Stef

Here you go…

1 user thanked author for this post.

Nicolas

Stef

Participant

Topics: 20

Replies: 52

Been thanked: 15 times

10/01/2016 at 3:06 PM #14037

JC_Bywan

No problem for blog post if you think it can be useful to compensate for the lack of mathpow, with or without my name doesn’t matter, I don’t own the rights to recursivity

I am going to write a “carte de fidélité – bières” with squares to stamp the beers on, in case some day I happen to drive near your headquarters 😉

JC_Bywan

Moderator

Topics: 20

Replies: 2549

Been thanked: 839 times

10/01/2016 at 4:05 PM #14038

Nicolas

Ahaha noobywan, you just have changed my mood from dark to hilarious, thanks a lot. Always got beers at Nicolas’HQ, no worries 😂

Nicolas

Keymaster

Topics: 81

Replies: 20828

Been thanked: 4742 times

05/10/2019 at 8:31 PM #98204

undefined

codeforpower = exp(5*log(2)) // result = 32 = 2^5
codeforlogarithm = log(32) / log (2) // result = 5

1 user thanked author for this post.

Nicolas

undefined

Participant

Topics: 0

Replies: 2

Been thanked: 2 times

Author

Posts

Viewing 11 posts - 1 through 11 (of 11 total)

Find exclusive trading pro-tools on