Home » SQL & PL/SQL » SQL & PL/SQL » Help in YIELD [Excel Function] formula in PLSQL (Oracle 11 G)
Help in YIELD [Excel Function] formula in PLSQL [message #666824] Mon, 27 November 2017 04:57 Go to next message
SATHISHENU
Messages: 1
Registered: November 2017
Junior Member
Dear Friends,

Need help in getting Source in PLSQL for Bond YIELD output which is derived in Excel =YIELD(...)..Please help.. Thanks in advance.

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666826 is a reply to message #666824] Mon, 27 November 2017 05:23 Go to previous messageGo to next message
John Watson
Messages: 7183
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

If you post the formula that this YIELD function calculates, perhaps someone can help. Or you can write the code yourself. Or perhaps there is a built-in function that does it, Oracle does include many financial calculation functions.

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666832 is a reply to message #666824] Mon, 27 November 2017 09:45 Go to previous messageGo to next message
JPBoileau
Messages: 11
Registered: September 2017
Junior Member
SATHISHENU wrote on Mon, 27 November 2017 04:57
Need help in getting Source in PLSQL for Bond YIELD output which is derived in Excel =YIELD(...)..Please help.. Thanks in advance.
Yield is a financial function that (to the best of my knowledge), Oracle doesn't have. I suggest that you write a PL/SQL function for that.

JP
Re: Help in YIELD [Excel Function] formula in PLSQL [message #666833 is a reply to message #666824] Mon, 27 November 2017 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
SATHISHENU wrote on Mon, 27 November 2017 02:57
Dear Friends,

Need help in getting Source in PLSQL for Bond YIELD output which is derived in Excel =YIELD(...)..Please help.. Thanks in advance.


implement the formula shown in URL below

https://support.office.com/en-us/article/YIELD-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe
Re: Help in YIELD [Excel Function] formula in PLSQL [message #666834 is a reply to message #666826] Mon, 27 November 2017 10:08 Go to previous message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
Oracle's Hyperion Calculation Manager has financial functions, including various yield types, including CalcMgrExcelYIELD.

https://docs.oracle.com/cd/E57185_01/CALDH/financial_functions.htm#CALDH-cmgr_mvf_635

[Updated on: Mon, 27 November 2017 10:15]

Report message to a moderator

Previous Topic: Packages
Next Topic: trigger impacting performance
Goto Forum:
  


Current Time: Wed Dec 13 11:45:44 CST 2017

Total time taken to generate the page: 0.01964 seconds