Serving the Quantitative Finance Community

Search found 34 matches

by Demyan
May 26th, 2010, 6:09 am
Forum: Programming and Software Forum
Topic: Anatomy of XIRR
Replies: 3
Views: 30702

Anatomy of XIRR

(The formula is at the bottom of the MS page. Day count is fixed, at 365). Thanks a lot!
by Demyan
May 25th, 2010, 7:13 pm
Forum: Programming and Software Forum
Topic: Anatomy of XIRR
Replies: 3
Views: 30702

Anatomy of XIRR

Two dates, two cashflows:01/01/2010 -10001/07/2010 120Result of XIRR formula: 0.444358128What equation does the number satisfy?Thanks!(Yes, I have consulted Excel docs and Google).
by Demyan
July 24th, 2009, 1:27 pm
Forum: Programming and Software Forum
Topic: simple question on SAS
Replies: 5
Views: 37889

simple question on SAS

Your best bet is (browsing the archives and) asking the question on SAS-L.http://www.listserv.uga.edu/archives/sas-l.html
by Demyan
July 23rd, 2009, 11:42 pm
Forum: Programming and Software Forum
Topic: C# beginner
Replies: 5
Views: 37906

C# beginner

by Demyan
July 14th, 2009, 8:35 pm
Forum: Programming and Software Forum
Topic: More on C# in Front Office - Feedbacks
Replies: 9
Views: 38969

More on C# in Front Office - Feedbacks

<t>Xing, thank you for the book, and if I may volunteer a few suggestions for the next edition.1. Hire a proof-reader, better yet an editor. 2. Update the material: is it possible that some important things changed since Excel 2002 and .NET 2.0? What about VSTO? XlwDotNet, naturally, ought to get so...
by Demyan
May 26th, 2009, 7:58 pm
Forum: Brainteaser Forum
Topic: Reading a newspaper
Replies: 0
Views: 39875

Reading a newspaper

<t>This won't take any prizes in a brainteaser pageant, but..You are visiting the former Soviet republic of Krakozia, and need to get some local currency, the kapusta. Entering a local bank branch, you see a prominent sign displaying current exchange rates. With some surprise, you notice that the sa...
by Demyan
March 16th, 2009, 1:51 pm
Forum: Programming and Software Forum
Topic: How do I return a string from a DLL to Excel?
Replies: 13
Views: 44702

How do I return a string from a DLL to Excel?

Ouch! Thank you very much, Dave.
by Demyan
March 14th, 2009, 5:31 pm
Forum: Programming and Software Forum
Topic: A C++ vs. Matlab speed test
Replies: 11
Views: 52076

A C++ vs. Matlab speed test

Aha! 0.4 s. Thanks a lot!
by Demyan
March 14th, 2009, 2:07 pm
Forum: Programming and Software Forum
Topic: How do I return a string from a DLL to Excel?
Replies: 13
Views: 44702

How do I return a string from a DLL to Excel?

.. And the quest for a working piece of C++/VBA code printing out "Hello world" in a spreadsheet cell goes on.
by Demyan
March 14th, 2009, 10:37 am
Forum: Programming and Software Forum
Topic: "Can't add specified file" when pointing to a DLL from Excel
Replies: 1
Views: 42174

"Can't add specified file" when pointing to a DLL from Excel

.. Dalton's book suggests the simple answer: because it's a DLL, not an XLL.
by Demyan
March 14th, 2009, 10:35 am
Forum: Programming and Software Forum
Topic: How do I return a string from a DLL to Excel?
Replies: 13
Views: 44702

How do I return a string from a DLL to Excel?

<t>Build succeeds (hooray!), but when I go to Excel (2007) and enter, say, "=foo(A1)", where cell A1 contains a string, the formula cell remains empty. I tried ByVal and ByRef, no effect.XLSM:Declare Function foo Lib "C:\Documents and Settings\Demyan\My Documents\Visual Studio 2008\Projects\Dave\Rel...
by Demyan
March 13th, 2009, 10:16 pm
Forum: Programming and Software Forum
Topic: How do I return a string from a DLL to Excel?
Replies: 13
Views: 44702

How do I return a string from a DLL to Excel?

<t>Thanks, David! Now I get:Error 2 error C2039: 'al' : is not a member of 'xloper' c:\..\dave.cpp 14 DaveError 3 error C2228: left of '.str' must have class/struct/union c:\..\dave.cpp 14 DaveError 4 error C2039: 'ltype' : is not a member of 'xloper' c:\..\dave.cpp 15 Dave#include "stdafx.h"#includ...
by Demyan
March 13th, 2009, 7:17 pm
Forum: Programming and Software Forum
Topic: How do I return a string from a DLL to Excel?
Replies: 13
Views: 44702

How do I return a string from a DLL to Excel?

<t>Thank you very much, Dave, but I am afraid I need a little more spoon-feeding: building a DLL project with (slightly modified) code below - in the CPP; there is a DEF, of course - fails in VS 2008. An immediate question is: what should I "include" to make VS 2008 recognize LPXLOPER?Thanks again.#...
by Demyan
March 13th, 2009, 6:55 pm
Forum: Programming and Software Forum
Topic: A C++ vs. Matlab speed test
Replies: 11
Views: 52076

A C++ vs. Matlab speed test

<t>Oh, interesting! Could you please tell me how to enable optimization? I see 'Whole Program Optimization" among VS 2008 Project Properties. Changing the setting from "No Whole Program Optimization" to "Use Link Time Code Generation" makes little difference to speed, and other settings, e.g. "Profi...
by Demyan
March 12th, 2009, 4:40 pm
Forum: Programming and Software Forum
Topic: How to create Dll in VC2008 and use it in Excel. 10 simple steps.
Replies: 19
Views: 54974

How to create Dll in VC2008 and use it in Excel. 10 simple steps.

Oh, thanks! PS. I see these are older versions of Excel and VS: with Excel 2007 and VS 2008, I did not need steps 8 and 9. (The VS screen in step 9 changed, and "Calling convention" is no longer present).