Finance Formula: YIELD

[caltang]

Reviving an old post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Using-Yield-Formula-From-Excel...

Has anyone managed to calculate the yield formula from excel into Alteryx? 

I am avoiding Python due to internal policies. I was thinking of making a formula in Alteryx like “=YIELD(x, y, z…)” and then output it to Excel. 

At least the formula then interacts with Excel as if it was running… any thoughts are welcomed!

[Qiu · Accepted solution]

@caltang 
I can see an Idea is raised for this function.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/PRICE-and-YIELD-formulas-from-Excel/...
and here are some discussion.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Using-Yield-Formula-From-Excel...

[caltang]

I think it’ll take a few cycles before Alteryx implements more finance formulas from Excel. Thanks @Qiu - I guess I’ll go with the formula to force a formula to exist in the excel output.

[apathetichell · Accepted solution]

I assume R isn't ok? jrvFinance?

https://cran.r-project.org/web/packages/jrvFinance/index.html

I think the no Python is funny - I'm sure your upstream data teams use it all the time.

[caltang]

Well the thing is… we cannot really use R or Python anymore due to an internal requirement with regards to the Server. 

If we use R or Python on desktop, eventually we will move to the Server. To be consistent, we are stripping any use of those two tools entirely just to be safe.

[aatalai]

@caltang could you not replicate the Yield formula using the formula tool?

[caltang · Accepted solution]

I’m not a finance professional but some of them were telling me it’s not so straightforward as the formula may suggest especially with regards to dates in the calculations. 

Something about the precision as well. But using the formula =ABS(YIELD(….)) in Alteryx and then outputting to Excel seems to do the trick and the end users are happy. 

Though I much prefer if the formula was maintained more properly on Alteryx itself rather than excel hacking this way…