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: 5
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: 8922
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: 88
Registered: September 2017
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: 26766
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 messageGo to next message
Barbara Boehmer
Messages: 9077
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

Re: Help in YIELD [Excel Function] formula in PLSQL [message #671529 is a reply to message #666834] Tue, 04 September 2018 01:04 Go to previous messageGo to next message
SATHISHENU
Messages: 5
Registered: November 2017
Junior Member
Thanks to all for your reply..

Any one has OPEN Source code for YIELD Excel Financial Function. I tried my best but not working out. Thanks in advance.
Re: Help in YIELD [Excel Function] formula in PLSQL [message #671531 is a reply to message #671529] Tue, 04 September 2018 01:14 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is your problem in implementing the formula BlackSwan pointed you to?
What is the problem? What did you try? If you don't post the code you tried we can't help debugging it.

[Updated on: Tue, 04 September 2018 10:03]

Report message to a moderator

Previous Topic: Urgent : SQL Queries
Next Topic: update column on same table using database trigger
Goto Forum:
  


Current Time: Thu Mar 28 04:34:40 CDT 2024