Did you come across this guaranteed 2000% strategy all on your own, or did Bernie Madoff give you a hand?

<r>IF DCFC's suggestions have not resolved your issue, try running Rob Bovey's Code Cleaner on your file. It may help, as Excel's garbage cleanup is not ideal. <URL url="http://www.appspro.com/Utilities/CodeCleaner.htmI">http://www.appspro.com/Utilities/CodeCleaner.htmI</URL> seem to remember runnin...

<r>QuoteOriginally posted by: kaikowIt seems that there were accuracy issues in version 1.1 of Calc.Any info on whether things have improved in more recent versions of Calc?How does Calc compare with Excel in numerical accuracy?I don't remember what versions I was using when I looked at some of the ...

What version? Never used 2007, but if you have 2003 or earlier, go to Options > Edit tab > Uncheck the Fixed Decimal option.

<t>QuoteOriginally posted by: OHi Guys!Is there anyone who can explain to me how the Mersenne Twister works, or has got an easily understood algorithm?I can’t find an algorithm for VBA, does anyone know where to find one?I have looked at the Mersenne Twister home page, but it’s a little too “hardcor...

<t>1. Is the Dates() array dimensioned as a date? Is the Lookup column 33 (AG) a list of dates as well? If so, Excel will use the Long Integer representation. Coercing the lookup value to long worked for me...x = Application.VLookup(CLng(Dates(i)), Worksheets("XMKT").Range(Cells(8, 33), Cells(1007, ...

Check out the following site. FastExcel is designed for this purpose. http://www.decisionmodels.com/

<t>Make it simpler:Suppose at time t=0, you fund a portfolio with 100 and instantaneously go long 100 and short -100. In period 1, both the long and short positions appreciate 10%. Assume also that your cash return is 5%, no leverage is used and no additional flows occurred during the period (broker...

See if the functions in the attached file help you. Please test thoroughly and report any problems. EDIT: I tried to upload just the .bas file, but it wasn't supported. I loaded a workbook with no data, only the module.

<t>Wouldn't the correct answer be to pay down the highest interest rate card first, subject to the minimum payments on the others? That is, I assume you have a fixed amount you plan to pay each month. Pay off the minimum on all the cards except the highest one, which gets the rest of the amount.I ha...

<t>Let Px_0 represent the price per unit at the end of period 0Px_1 represent the price per unit at the end of period 1Mult_0 represent the pricing factor/consideration constant at end of period 0Mult_1 represent the pricing factor/consideration constant at end of period 1(Note that the valuation mu...

<t>Try the VBA Round function rather than INT. Also, please note that VBA Round behaves differently than does the =ROUND(...) worksheet function (uses round to even vs. round up when the critical digit is 5).''''''''''''''''''''Sub test() Debug.Print (2 / 0.2 * 0.5) & " " & Int(2 / 0.2 * 0.5...

<t>Lepperbe is correct. Get the expected value first and then calculate the return rather than calculating the individual component returns and creating an composite from their respective probabilities.The correct expected return for the given situation is:Periodic/Annualized =SQRT((150*0.5+200*0.5)...

Thanks for the responses. Of course, in the situation I was in, I mouthed off. It was years of getting the shaft and I kept mouting off. It was a vicious cycle downward.Next time, I will definitely take more of the advice in this thread and that of others and just shut up.

<r>QuoteOriginally posted by: terrorbytere: Politics. It is more prevalent in some organizations than others.I find if I keep my head down, arse up and keep producing good stuff, the politics flies around me but not too me. Everyone now and then you might have to deal with some crap but if you make ...