Financial Price formula

[Haokun]

hi All,

I am using excel formula "Price" to return the price per 1$00 face value of a security that pays periodic interest, may i know what will be formula in Alteryx?

I tried to find but there is no such formula available at the moment...

thanks.

[Luke_C]

At first glance this seems to be one of the functions not yet in Alteryx. You can post an idea for it to be added.

Here's a microsoft page that outlines the mechanics of how the function works, so you can recreate it

https://support.microsoft.com/en-us/office/price-function-3ea9deac-8dfa-436f-a7c8-17ea02c21b0a

[Matt_D]

If anyone wants to create a macro, the information about the syntax is here - https://support.microsoft.com/en-gb/office/price-function-3ea9deac-8dfa-436f-a7c8-17ea02c21b0a

My GCSE grade D in maths doesn't cut it! 😂

[Haokun]

emm........after i look at the machanics functioned ...i don't think i can create that in Alteryx...