finance functions not available
 

Hello,

I have added the analysis toolpack in my excel 2003, but some of the finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

finance functions not available
 

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

finance functions not available
 

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

finance functions not available
 

So what do you get in the cell? Just the text string of the formula? If
that's the case,
change the format of the cell to general, double click the cell (or press
F2) and press enter


--
Regards,

Peo Sjoblom

"Ivanl" wrote in message
...
August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating
to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed
but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions.
In
other words, when I type =coupdays( excel does not see it as a
function.

what could the problem be?

Thanks.

I.

finance functions not available
 

That is the behaviour of the ATP functions......................no tool tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:56:03 -0700, Ivanl
wrote:

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

finance functions not available
 

hello Peo and Gord,

Thanks for the help.

"Gord Dibben" wrote:

That is the behaviour of the ATP functions......................no tool tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:56:03 -0700, Ivanl
wrote:

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

finance functions not available
 

Another way:

CTRL SHIFT A

Start typing the formula:

=COUPDAYS(

After you type in the "(" then use the key combo of CTRL SHIFT A and the
arguments will show. It doesn't work like the regular function tooltips,
though! In fact, it seems like a pita but at least it'll show you what the
arguments are supposed to be.

--
Biff
Microsoft Excel MVP


"Ivanl" wrote in message
...
hello Peo and Gord,

Thanks for the help.

"Gord Dibben" wrote:

That is the behaviour of the ATP functions......................no tool
tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to
fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:56:03 -0700, Ivanl

wrote:

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it
does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating
to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed,
it
can be a nuisance at times to fix this when Excel thinks it is
installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions.
In
other words, when I type =coupdays( excel does not see it as a
function.

what could the problem be?

Thanks.

I.

finance functions not available
 

nice tip.

"T. Valko" wrote:

Another way:

CTRL SHIFT A

Start typing the formula:

=COUPDAYS(

After you type in the "(" then use the key combo of CTRL SHIFT A and the
arguments will show. It doesn't work like the regular function tooltips,
though! In fact, it seems like a pita but at least it'll show you what the
arguments are supposed to be.

--
Biff
Microsoft Excel MVP


"Ivanl" wrote in message
...
hello Peo and Gord,

Thanks for the help.

"Gord Dibben" wrote:

That is the behaviour of the ATP functions......................no tool
tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to
fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:56:03 -0700, Ivanl

wrote:

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it
does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating
to
fixed income right now.

"Peo Sjoblom" wrote:

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed,
it
can be a nuisance at times to fix this when Excel thinks it is
installed but
it doesn't work


--
Regards,

Peo Sjoblom





"Ivanl" wrote in message
...
Hello,

I have added the analysis toolpack in my excel 2003, but some of the
finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions.
In
other words, when I type =coupdays( excel does not see it as a
function.

what could the problem be?

Thanks.

I.

finance functions not available
 

Good trick Biff

Not knowing that one before now.


Gord

On Tue, 24 Jul 2007 13:56:22 -0400, "T. Valko" wrote:

Another way:

CTRL SHIFT A

Start typing the formula:

=COUPDAYS(

After you type in the "(" then use the key combo of CTRL SHIFT A and the
arguments will show. It doesn't work like the regular function tooltips,
though! In fact, it seems like a pita but at least it'll show you what the
arguments are supposed to be.