Here it is

See sub in Module2

No, I am using the search box on page http://bsym.bloomberg.com/sym/What do you mean by forming a url ?

Sorry but I do not get it : if you enter GGB 4.6 05/20/13 in the symbol search box, it gives you the bond

I am afraid the sg quotes may be staled ...I will check in a few days to see if it updates.

Page for SG on bloomberg is SGWP.2011 : 104.9 - 107.92012 : 99.0 - 102.02013 : 95.9 - 99.92014 : 95.7 - 100.7Edit : file attached

Maybe you could use future quotes : Eurex

Hi, I made a small prototype excel file using InternetExplorer.

Hi, could you give more details ?

<r>To handle array my guess would be to use pointer : summation should be defined as double __stdcall summation(double* y, int n)and declared in vb as Declare Function summation _Lib "C:\Visual Studio 2005\Projects\Filter\debug\Filter.dll" _(Byref a As Double, ByVal b As Integer) As Doublenote the b...

<r>A couple of things : - in vba, you try to call the function minimum instead of summ - in c file, you use _stdcall (single underscore) instead of __stdcallCould you provide the compiled dll to check the exported names ? You can check these names using dependency walker : <URL url="http://www.depen...

Hi,Not sure to understand but if you use the eigen vector (0.553, 0.596, -0.461, -0.355), you should get a negative variance.

In Excel, the method Range.CopyFromRecordset is pretty fast to copy data.

Can you provide the url of the file ?

Hi, this paper may help : http://www.damianobrigo.it/upfrontCDSnote.pdf