Closed

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

This project was awarded to kevneth for $42.5 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $5000 USD
Total Bids
5
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online