Fwd: Code snippet for Vba in excel

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Fwd: Code snippet for Vba in excel

rohan talwar
>
>
>
> To add a little more colour to what I'm trying to do.
> I get data from an external data provider and wish to create a time series, then persist it.
> I am trying to now feed a string into the application.run call as the date parameter and value parameter. This is a trial and error outcome because it seems the QL coercion will accept that over an array of long (dates) and double (values).
> I get error 13. If I use the join function to create the string I get an error 5 which seems associated with an extra dimension and is perhaps at the native function level and not QL.
>
> All help appreciate.  
>
> Kind regards
> Rohan Talwar
>
> On 23/01/2013, at 9:51, Rohan TALWAR <[hidden email]> wrote:
>
>>
>>
>>>
>>> Hi all, I hope you are all well.
>>>
>>> Does anyone have a vba code snippet to create a "qltimeseries" obj in vba including the parameter types for passing/instantiation?
>>
>> Passing an array of dates or longs and an array or double does not succeed.
>>>
>>> The type mismatch error under application.run() is difficult to debug since the response is very generic.
>>>
>>> All help appreciated.
>>>
>>> Kind regards
>>> Rohan Talwar

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users