Excel VBA: Price() and Yield() functions with monthly frequency (frequency = 12)

Closed

I need Excel VBA functions for Yield() and Price() that allow monthly frequency. Instead? of having a "frequency" argument, frequency would be assumed to be 12 (monthly).

In all other respects, these functions should be like Excel's Yield() and Price() functions. Please see Excel's online help for details about them.

## Deliverables

===================================

IMPORTANT NOTE!

Some of the bidders seem to be under the impression that this job is a simple matter of wrapping Excel's built-in Price() and Yield() functions to hard-code "12" as the frequency argument.

NO!!! That won't work!!!

Excel's built-in Price() and Yield() functions do NOT accept 12 as the frequency argument. Sending "12" to Excel's built-in Price() and Yield() functions as the frequency argument results in an ERROR.

PLEASE ENSURE THAT YOU UNDERSTAND THAT BEFORE BIDDING. I WILL HAVE NO PATIENCE FOR PROGRAMMERS WHO TRY TO DELIVER A SIMPLE WRAPPER THAT RETURNS AN ERROR.

I am a longtime VBA programmer too, and if that's all it took, I would have done it in a fraction of the time than it took to submit this bid request. The reason I'm asking for help on this is because the math is more than I have time to work out right now, especially for Price().

===================================

The function headers should be similar to these:

Function YieldMonthly(settlement as double, maturity as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? rate as double, pr as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? redemption as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Optional basis as integer) As Double

Function PriceMonthly(settlement as double, maturity as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? rate as double,? yld as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? redemption as double, _

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Optional basis as integer) As Double

Also -- please note the "Legal" section of this bid, where items 1 - 5 are custom items I wrote:

1) The deliverable must return accurate results according the formulas and descriptions in Excel's online help for the Yield() and Price() functions.

2) The deliverable must not call any code libraries not normally available in a default installation of Windows and Excel.

3) The deliverable must be in the form of plain? text or as an Excel workbook with a VBA code module.

4) If delivered as an Excel workbook, the deliverable must use only one standard vba code module, and must NOT use any class modules.

5) If delivered as an Excel workbook, there must be no password protection of any kind in the workbook. I must have full access to the source code in the VBA module.

I do NOT want an add-in. I want plain text, or an Excel workbook with the functions in a single standard VBA code module.

* * *This broadcast message was sent to all bidders on Thursday Dec 11, 2008 9:43:46 PM:

Hello Bidders, Please review the clarifications in the bid request and let me know if you are still interested. Thanks, Greg

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Software Architecture, Software Testing, Word

See more: monthly yield excel, math yield excel vba, excel yield monthly frequency, vba work, vba for programmers, vba excel programmer job, vba excel programmer, programmers on call, programmers excel, programmer excel vba, price for vba for excel, price engineering, out there monthly, online job math, online job for c programmers, online help with excel, online help for excel, online engineering job, on call programmers, note online for programmer, need of excel programmer, math rate, math programmer, i need excel help, i need a vba programmer

Project ID: #3462602

Awarded to:

kevneth

See private message.

$42.5 USD in 19 days
(37 Reviews)
5.5

5 freelancers are bidding on average $61 for this job

vw6908296vw

See private message.

$168.3 USD in 19 days
(83 Reviews)
5.2
JackWorm

See private message.

$6.8 USD in 19 days
(9 Reviews)
3.7
gts1928

See private message.

$12.75 USD in 19 days
(8 Reviews)
2.1
pearlveera1

See private message.

$72.25 USD in 19 days
(0 Reviews)
0.0