<t>Be careful with not getting out-stop-lossed. E.g. when you buy a stock at 11€, and analysts say a stop-loss is @ 10€, and the stock drops by some cents. Then a very powerful shortseller drives the stockprice under 10€, stop losses are executed dropping the share to 9.50, and then he buys his shor...

Try WorksheetFunction.normsist, maybe this is faster.hth, Flex

I'm too lazy to look how arrays are defined in Excel,but a easier way would be

<r>KMV Kredit Monitor delivers Assetvalue time series, though they are a bit hidden <E>:-)</E>. Add the companies neededto a set, and then click on SETs and UDAs. There you will find timeseries of 5 years for equity value, liabilities andasset value, and you can save them in a file. Be careful thoug...

<t>Britannia, you chose yourself a difficult task. First of all, as jabairu said, equity correlationsare a first hint in the right direction. I think creditmetrics uses equity correlations as proxyfor asset correlations, but they use a factor-regression before.If we talk further, we have to clarify ...

<t>Thx for your answer, aaron, i to thought that current yield was of limited use. So if i havea bond and a risk free interest rate, i have to calculate ytm to gainspreads. So 1) What is the easiest way to calculate this? Generally said, it is to solve the equationall cash flows discounted at yield ...

<t>Since i got some strange results, i wanna check if i'm prolly false .Yield:When i got bond with let's say 6% coupon and a principle of 100, and a marketvalue of 95, current yieldwould be 6.316 ( 6*100/95 ). Yield to maturity would be more complicated, solving for a a rate, for whichall future cas...

<t>I can just rely on my memory of c and other programming languages:There a list consists of a record, which consists of a data part and a pointer to such a record, and a root, which points to the first element of a list.Whenever you add a new element to that list, you iterate the list from the roo...

<t>But imo, if i have asset value time series, the std of the logreturns (e.g for the last 3 yrs or for whatever period)should equal those sigma's, or shouldn't they?From what i saw KMV uses non-constant debt for their estimation of asset value time series. But if youdo this (from my own experience ...

No, i luckily never had the feeling before that money lies in such amount on the street. So i just started to invest last week, though i followed the market for several years now.

I suggest google + orthogonal regression, maybe add some excel to it too.[hint] Maybe you even find some post in this forum, which gives you the intentionthat you could have even used the search-function of this forum [/hint]

I said the market was to low for the whole past month. Finally the market realized i'm right (j/k)

<t>Someone knows how KMV calculates their firm sigma's (std of asset value log-returns)?Because i had the possibility to have a look at their asset value time series, and the sigma'sobtained from them didn't matched the KMV sigma's (as they should?). In fact, since theseAsset value time series conta...

For my thesis i'd like to throw a look into Peter Hecht's paper "The Cross-section of Expected Firm (not equity) Returns"Haven't found it in the net, maybe somebody posesses a copy.Thx in advance, Flex

Menu->tools-> Internet options. Just play some with all security/advanced options, until it works...