OraFAQ Forum: SQL & PL/SQL » Help in YIELD [Excel Function] formula in PLSQL

Home » SQL & PL/SQL » SQL & PL/SQL » Help in YIELD [Excel Function] formula in PLSQL (Oracle 11 G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help in YIELD [Excel Function] formula in PLSQL [message #666824]

Mon, 27 November 2017 04:57

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.

Report message to a moderator

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666826 is a reply to message #666824]

Mon, 27 November 2017 05:23

John Watson
Messages: 8997
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.

Report message to a moderator

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666832 is a reply to message #666824]

Mon, 27 November 2017 09:45

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

Report message to a moderator

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666833 is a reply to message #666824]

Mon, 27 November 2017 09:50

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

Report message to a moderator

Re: Help in YIELD [Excel Function] formula in PLSQL [message #666834 is a reply to message #666826]

Mon, 27 November 2017 10:08

Barbara Boehmer
Messages: 9106
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

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.

Report message to a moderator

Re: Help in YIELD [Excel Function] formula in PLSQL [message #671531 is a reply to message #671529]

Tue, 04 September 2018 01:14

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 24 18:51:07 CDT 2026