I just posted another EMail problem on this site but have had nothing but problems with EMail and SQL Server - Even using all Microsoft products. I don't recall...

Figured it out - finally !!!

My factor percentages SHOULD have been entered in the table like this:

1) .275

2) .55

but I had them as full percentages like this:

1) 27.5

2) 55

So..

A "DOMAIN...

Heh- here's a new one...

If I replace the "@FactorNum" variable in the calling routing with its actual value from the table ( a hardcoded .275) - all works fine.

So instead...

Thanks 5409045121009...

There's no need to test the UDF - why you ask? Because I've been using the UDF in Production for over 2 months now with no problems.

Problems ONLY...

OK -U asked for it...

Further testing reveals that the UDF works fine as standalone(and has for months) but called from a cursor fails. If I remove the @PortfolioPct in...

Thanks guys - I guess using CAST will just just be part of the game regardless.

I wish I could include pictures in here but here it goes...

If you open the...

Worrying 99% about accuracy of performance calcs.

The performance thing is only a sideline thinking about the future and things like 10 year performance etc...

1) Must work

2) Must work accurately

3) Must...

Reaction time does not matter as their other tecnologies act on a lag that my Grandmother couldn't stand - so it's free form.

However, My current system runs like the wind...

Sharpe and Treynor = huh?

I can only code the specs I'm given and one of the senior guys here has me using not the NAV, but the daily performance percentage...

Heh-

You've got me pegged !

It seems that using a Beginning versus ending NAV is satisfactory but we'll be using every days data to find the geometric mean using the SUM(LOG())...

Thanks Frank-

I'm working on basic, internally calculated performance for a set of Mutual Funds and their underlying Managers. Problems arise when attempting to run geometric performance on a daily...

Ouch-

It may look complex but it's really not.

At it's core it's a result set based on several correlated subqueries. I have one chunk of SQL (in a UDF called...

Sorry...

I am doing an outer select because the inner select actually contains 3 similar select statements which are UNIONed together. And, they need to be sorted with a dynamic...

My general rules are as follows:

1) NOONE hits tables directly from ANY application. Security is applied both to the SProx and to the Application.

2) Since ADO seems to easily...

Ugh-

I may be back to storing and not dynamically calculating.

Why? Because:

1) The perfomance dates are sparse - holidays, weekends etc.

2) I have mutiple entities which have performance in the same...