Serving the Quantitative Finance Community

Search found 69 matches

by PiotrW
March 17th, 2012, 12:40 am
Forum: Programming and Software Forum
Topic: Calling non-registered COM .dll's from Excel VBA
Replies: 10
Views: 147656

Calling non-registered COM .dll's from Excel VBA

<r>Crisky,i tried to call from vba Excel a non-registered COM-dll built by Matlab, but failed.But here below I share the method of making use of it after registering.If you want to use a Matlab built functions in Excel through vba and dll, you do not have to encapsulate them into .xla.1. Matlab Comp...
by PiotrW
November 12th, 2010, 1:34 pm
Forum: Technical Forum
Topic: Quanto vs Composite Options
Replies: 9
Views: 70789

Quanto vs Composite Options

<r>Hello,Both of them pay out in a diffrent cur from the cur the asset is qouted in.1.quanto also known as "Fixed Exchange Rate on Foreign Asset Option":strike in qoute cur; Qt0 i.e. exchange rate is specified in a TradeDate E. G. Haug, The Complete Guide to Option Pricing Formulas, MCGraw-Hill 1998...
by PiotrW
May 10th, 2010, 8:00 am
Forum: Numerical Methods Forum
Topic: Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)
Replies: 3
Views: 33170

Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)

<r>Hello,additional information for those interested in the matter:There you can find Exact Fourier Lévy formulae by Prof. Klaus Schmitz:<URL url="http://www.performancetrading.it/Documents/KsStrong/KsS_Exact.htmand"><LINK_TEXT text="http://www.performancetrading.it/Docume ... act.htmand">http://www...
by PiotrW
May 3rd, 2010, 8:45 pm
Forum: Programming and Software Forum
Topic: OnLine Calculator on webpage www.
Replies: 10
Views: 29316

OnLine Calculator on webpage www.

outrun,thank you very much indeed for a detailed explanaition.I try to build the structure of a calc in the way you have suggested.Thank you pal,Kind Regards,PiotrW
by PiotrW
May 3rd, 2010, 6:01 pm
Forum: Programming and Software Forum
Topic: OnLine Calculator on webpage www.
Replies: 10
Views: 29316

OnLine Calculator on webpage www.

outrun,the way the calculators is organized and their quick computations make an impression. So, you have done it wih CGI, right? Could you recommend an online tutorial, that could bring such results?Regards,PiotrW
by PiotrW
May 3rd, 2010, 3:11 pm
Forum: Programming and Software Forum
Topic: OnLine Calculator on webpage www.
Replies: 10
Views: 29316

OnLine Calculator on webpage www.

Cuchulainn,If I chose your first suggestion... I have created stand-alone exe in C++:http://quantitude.pl/00_download/fx_opt_calc.exebut do know how to embed it in the html script?Do you have any reference?PiotrW
by PiotrW
May 3rd, 2010, 1:17 pm
Forum: Numerical Methods Forum
Topic: Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)
Replies: 3
Views: 33170

Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)

Hi,thank you FaridMoussaoui for a quick response.For the others:Random Generation of Stochastic Area Integrals. J. G. Gaines and T. J. Lyons SIAM Journal of Applied Mathematics. Volume 54, Issue 4, pp. 1132-1146Regards,PiotrW
by PiotrW
May 3rd, 2010, 1:09 pm
Forum: Programming and Software Forum
Topic: OnLine Calculator on webpage www.
Replies: 10
Views: 29316

OnLine Calculator on webpage www.

<t>Hi,thanks Cuchulainn for a quick responseYou ask which language do I use -- well, I would use that one which facilitates putting calc on a website. I am prepared to learn it from scratch just to build a calc.I plan to create a calc of Market Value of plain vanilla & barrier options (explicit ...
by PiotrW
May 3rd, 2010, 11:07 am
Forum: Programming and Software Forum
Topic: OnLine Calculator on webpage www.
Replies: 10
Views: 29316

OnLine Calculator on webpage www.

Hello everyone,my intension is to put an online calculator on a website. It would involve computing a CDF & PDF of a normally distributed random variable.Perhaps someone of you know how to do it?Regards,PiotrW
by PiotrW
May 3rd, 2010, 10:58 am
Forum: Student Forum
Topic: Milstein Scheme
Replies: 2
Views: 167561

Milstein Scheme

Hi JAC,could you attach a document in which you found that?I guess that might cast some light on he matter.Regards,PiotrW
by PiotrW
May 3rd, 2010, 10:51 am
Forum: Numerical Methods Forum
Topic: Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)
Replies: 3
Views: 33170

Double Integral in Milstein Scheme for 2 SDE's (e.g. Heston model)

<t>Hello everyone,perhaps someone of you came across with an issue of double stochastic integral calculation. It arose from a Milstein scheme used for Heston model and it is as:I' d like to put it to MC calculation, but unfortunately do not know how to embed it in the script.Do you know any explicit...
by PiotrW
September 6th, 2009, 12:05 pm
Forum: Technical Forum
Topic: How to Access C++ DLL in Excel
Replies: 7
Views: 41626

How to Access C++ DLL in Excel

<r>Hello gauravkumar2,you should also pay attention to the variable mapping from function declared in C++ dll to that declared in VBA.C: "int variable" is mapped to VB: "ByVal variable As Long", etc.Go to the section "Writing a Visual Basic program to call the DLL" in the middle of the page: <URL ur...
by PiotrW
September 1st, 2009, 5:55 am
Forum: Programming and Software Forum
Topic: Borland C++ Builder dll in Excel (bcb dll 4 xls)
Replies: 5
Views: 38155

Borland C++ Builder dll in Excel (bcb dll 4 xls)

Hi mj,Turbo C++ 2006 Explorer is Free download, Full product.If you would like to download it, you may use https://downloads.embarcadero.com/free/c_builder .Regards,PiotrW
by PiotrW
August 31st, 2009, 10:20 am
Forum: Programming and Software Forum
Topic: Borland C++ Builder dll in Excel (bcb dll 4 xls)
Replies: 5
Views: 38155

Borland C++ Builder dll in Excel (bcb dll 4 xls)

Hi mj,>Is there real demand for this?If you mean creating a stand-alone dll for Excel in C++ Builder? Yes there is real demand for this.Regards,PiotrW
by PiotrW
August 31st, 2009, 7:41 am
Forum: Programming and Software Forum
Topic: xll dll
Replies: 12
Views: 190747

xll dll

<t>Hi Elektor,I have several quastions to your post, if you do not mind:1. I suppose you have to use DLL WIZARD in bcb to write "Code(sumtwoints.cpp)", right?2. Shouldn't there be any dllimport in the subsequenst statement?3. Could you explain what this "-O2" in "BCC32 -tWD -O2 sumtwoints.cpp" means...