Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
price and yield functions
How do you use the price and yield functions in code? I tried:
Sub testyield() Cells(1, 1) = Application.yield(Cells(2, 1), Cells(3, 1), Cells(4, 1), Cells(5, 1), 100, 2, 0) End Sub obviously, the inputs are settlement, maturity, rate, price, etc. that work on spreadsheet. Do I have to activate these functions somehow? I do have to enable analysis tool pak in order to use functions such as these on a spreadsheet, but what about code? Thanks, Mike Allen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
price list changes using conditional functions? | Excel Worksheet Functions | |||
Excel slow due to Yield and Duration Functions | Excel Discussion (Misc queries) | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions |