<t>I just cannot find any document like pdf manuals that are relating to the VBA API functions. Any one could tell meobjDataControl.GetHistoricalData arraySecurity, 1, arrayField, CDate(SD), CDate(ED), Results:=vtResultobjSnap.GetData arraySecurity, "MARKET_SECTOR_DES", , , 10000, vtResultwhat does ...

but if you plug s=0 and k = 0 in the formula it gives you the exact number of N(confidence), which indicates it should be excessive k in the formula

the link is not working...

The "K" in CF Var is kurtosis or excessive kurtosis? any official literal?

and it's odd i am getting different answers by sparsing Aeq Beq, why?

<t>Thanks how do i instruct Matlab to clear the memory? i think matlab just couldn't find a enough big contiguous free block to store the data. Actually my data contains large amount of 0s, most of the subsets are zeros(x,y). I tried to use sparse function, it helps in reducing the size of the datas...

<t>Hi guys, I am encountering this problem when running linear programming in Matlab, ===============================================================??? Out of memory. Type HELP MEMORY for your options.Error in ==> lipsol at 689 x(perm) = (P(perm,perm)+U(perm,*U(perm,')\b(perm);Error in ==> linprog ...

<r><URL url="http://faculty.fuqua.duke.edu/~charvey/Research/Published_Papers/P54_Autoregressive_conditional_skewness.pdfsaw"><LINK_TEXT text="http://faculty.fuqua.duke.edu/~charvey/ ... ess.pdfsaw">http://faculty.fuqua.duke.edu/~charvey/Research/Published_Papers/P54_Autoregressive_conditional_skewn...

Or there is no way to do that in MATLAB..? the stats toolbox is pretty weakAlso, how to do regression with the autoregressive residuals?y(t) = b*x(t) + e(t)e(t) = a*e(t-1)+...plz advise, thanks!

<t>I keeping hearing ppl say sb uses "momentum model", use the momentum factors.... I know momentum model assumes the current price/return is positively correlated to the past price/return, and some TA indicator like MACD, RSI, CCI can all defined as "momentum factor". I wonder if what they mention ...

<t>I've built a Access form to download data from bloomberg to database, what I did is just download the bloomberg API and check "Bloomberg data library" and "Bloomberg history library" in VBA reference. Now I am going to build the same form in VB 2008. But cannot find anywhere to choose the add-in ...

could u give a link to the paper? thx!

<t>i create a Access form which has some listbox, buttons... to let me choose what data I want to load to the excel. So i have to write SQL in Access VBA first and then give the data to excel. i am thinking about ur idea, but that's same just like I build the form in Excel, and still write everythin...

actually I am simply writing a ssql in Access VBA and execute it to extract the value I want from the database and put in the excel spreadsheet cell, and one by one... i think that's either DAO or ADO right?

i am exporting the data from Access to excel file but turns out pretty slow, since i have to put data in the spreadsheet cell by cell. But i know someone is doing the same way using VB+SQLserver, so the software really makes difference?