{"id":461,"date":"2011-08-02T06:43:42","date_gmt":"2011-08-02T06:43:42","guid":{"rendered":"http:\/\/datafutures.net\/ecsi\/?page_id=461"},"modified":"2011-11-16T21:12:56","modified_gmt":"2011-11-16T21:12:56","slug":"u-a-api-faq","status":"publish","type":"page","link":"https:\/\/www.csidata.com\/?page_id=461","title":{"rendered":"U.A. API FAQ"},"content":{"rendered":"
\n

Question: I have been using a piece of software called FDC that interefaces with CSI’s API to access the data for neary four years now with out any problems. I recently purchased a new laptop with the Windows 7 Ultimate OS (64 bit) on it.\u00a0 On this computer the FDC software is not able to successfully interface with the API. What could be wrong?<\/span><\/p>\n

Answer:<\/span> <\/span>The following keys should be present in your registry, if not, then something is preventing the UAd.exe from registering itself when it is run.\u00a0 Please make sure you run UA from an admin account at least once for the entries to be entered.<\/p>\n

HKEY_CLASSES_ROOT\\TypeLib\\{6F2F99A0-6600-11D3-B331-525400E8C92C}\\1.0\\0\\win32\\”C:\\ua\\uad.exe”<\/p>\n

HKEY_CLASSES_ROOT\\Wow6432Node\\CLSID\\{6F2F99A3-6600-11D3-B331-525400E8C92C}\\LocalServer32\\”C:\\ua\\uad.exe \/Automation”<\/p>\n

HKEY_CLASSES_ROOT\\Wow6432Node\\CLSID\\{A7120BAF-D87E-4949-93A0-53BB63F4D528}\\LocalServer32\\”C:\\ua\\uad.exe \/Automation”<\/p>\n

HKEY_CLASSES_ROOT\\Wow6432Node\\TypeLib\\{6F2F99A0-6600-11D3-B331-525400E8C92C}\\1.0\\0\\win32\\”C:\\ua\\uad.exe”<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: Why does the UAD.exe program hang when it is called from a perl script for the third time while running. I’m running the uad.exe program on a windows server 2003 machine with all patches. <\/span><\/p>\n

Answer:<\/span> Try this first, prior to running from perl, ensure that the file “windows\\ua.ini” is set to the correct directory, like:
\n[Program]
\nDirectory=C:\\ua\\<\/p>\n

using SetPrivateProfileString<\/p>\n

Try setting your scripts working directory as C:\\UA<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: Moving from successful Excel API interface to\u00a0 to VS2010. Windows 7 x64 with VS2010 Ultimate. Can you offer a code sample for the Current release of Visual Studio?<\/span><\/p>\n

Answer:<\/span> Will you be using C++ or C#?<\/p>\n

Click here for a C# example.<\/a><\/p>\n

If using C++ here is a sample array accessor to use after a request: ( you’ll need to import the com class from ua\\uapi\\ua.tlb )<\/p>\n

IAPI2 *UAapi = new IAPI2();
\nif(UAapi==NULL)
\n{
\nAfxMessageBox(“Unable to open connection to UA stub object”);
\nreturn;<\/p>\n

}
\nif(!UAapi->CreateDispatch(“UA.Api2”))
\n{
\nAfxMessageBox(“Unable to open connection to UA”);
\nreturn;
\n}<\/p>\n

UAapi->SetApplyCommodityAdjustments(0);
\nUAapi->SetRoundToTick(0);<\/p>\n

VARIANT IArray, DArray;
\nVariantInit(&IArray);
\nVariantInit(&DArray);
\ncount= UAapi->CopyRetrievedDataToArray2(0, &IArray , &DArray);
\nchar strLineOut[128];
\nlong NumIntColumns, NumFltColumns;
\n{ SafeArrayGetUBound(IArray.parray,1,&NumIntColumns); NumIntColumns++;
\nSafeArrayGetUBound(DArray.parray,1,&NumFltColumns); NumFltColumns++;
\n}
\nlong *iArray; SafeArrayAccessData(IArray.parray,(void**)&iArray);
\ndouble *dArray; SafeArrayAccessData(DArray.parray,(void**)&dArray);<\/p>\n

for(int c=0; c < count; c++ )
\n{
\n#define sGetDate(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+0]
\n#define sGetDyDm(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+1]
\n#define sGetStrike(c) iArray[NumIntColumns*(c)+2]
\n#define sGetVol(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+3]
\n#define sGetTVol(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+5]
\n#define sGetOi(c)\u00a0\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+4]
\n#define sGetTOi(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+6]
\n#define sGetfStrike(c)dArray[NumFltColumns*(c)+0]
\n#define sGetOpen(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+1]
\n#define sGetHigh(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+2]
\n#define sGetLow(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+3]
\n#define sGetClose(c)\u00a0 dArray[NumFltColumns*(c)+4]
\n#define sGetBid(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+5]
\n#define sGetAsk(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+6]
\n\/\/ print to file the commod code
\n{\u00a0 sprintf(strLineOut, “%d,%d,%2.8f00, %2.8f00, %2.8f00, %2.8f00, %d,%d\\n”,\u00a0 sGetDate(c),
\nsGetDyDm(c),
\nsGetOpen(c),
\nsGetHigh(c),
\nsGetLow(c),
\nsGetClose(c),
\nsGetVol(c),
\nsGetOi(c)
\nfputs(strLineOut, ptr);
\n}
\n}
\nSafeArrayUnaccessData(IArray.parray);
\nSafeArrayUnaccessData(DArray.parray);
\n}<\/p>\n

or
\nlong nNumRecords = UAapi->CopyRetrievedDataToArray((short)0,
\n&DateArray, &DOWArray, &DydmArray,
\n&OpenArray, &HighArray, &LowArray, &CloseArray,
\n&ClosingBidArray, &ClosingAskArray,
\n&VolumeArray, &OIArray, &TotalVolumeArray, &TotalOIArray, &CashArray);
\nSafeArrayAccessData(DateArray.parray,(void**)&cDateArray);
\nSafeArrayAccessData(DydmArray.parray,(void**)&cDydmArray);
\nSafeArrayAccessData(OpenArray.parray,(void**)&cOpenArray);
\nSafeArrayAccessData(HighArray.parray,(void**)&cHighArray);
\nSafeArrayAccessData(LowArray.parray,(void**)&cLowArray);
\nSafeArrayAccessData(CloseArray.parray,(void**)&cCloseArray);
\nSafeArrayAccessData(VolumeArray.parray,(void**)&cCVArray);
\nSafeArrayAccessData(OIArray.parray,(void**)&cCIArray);<\/p>\n

for(int j=0;j<nNumRecords;j++)
\n{
\ndouble o=cOpenArray[j];
\ndouble h=cHighArray[j];
\ndouble l=cLowArray[j];
\ndouble c=cCloseArray[j];
\nfprintf(ptr,”%d,%d, %2.8f00, %2.8f00, %2.8f00, %2.8f00,%8d,%8d\\n”,
\ncDateArray[j], cDydmArray[j],
\no,
\nh,
\nl,
\nc,
\ncCVArray[j],
\ncCIArray[j] );<\/p>\n

}
\nSafeArrayUnaccessData(DateArray.parray);
\nSafeArrayUnaccessData(DydmArray.parray);
\nSafeArrayUnaccessData(OpenArray.parray);
\nSafeArrayUnaccessData(HighArray.parray);
\nSafeArrayUnaccessData(LowArray.parray);
\nSafeArrayUnaccessData(CloseArray.parray);
\nSafeArrayUnaccessData(VolumeArray.parray);
\nSafeArrayUnaccessData(OIArray.parray);<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I am confused about the use of letters \u201cC\u201d and \u201cX\u201d in relation to the file name of a detrended contract. Which is correct, please?<\/span><\/p>\n

Answer:<\/span> There are 2 ways to Detrend, the one that refers to is where the detrend begins back before the current contract.\u00a0 This is the 2nd contract option.
\nThe other begins backwards before the current day, this is the 2nd day option. It looks like this one isn’t documented but may be what you are considering.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: We installed CSI “Unfair Advantage 2.10.7.115” on a new Windows 7 Enterprise 64 bit machine.\u00a0 The application works, but we are having problems with API2. The open\/high\/low\/close values come out garbled in our extract program.\u00a0 API2 works fine with our existing Windows XP 32 bit with “Unfair Advantage 2.10.7.7”. What is the issue?<\/span><\/p>\n

Answer:<\/span> Versions after 2.10.7.7 have changed the variant data type from float to double due to overflows. This is contained in the CopyDataToRetrievedArray routines.
\nThis may be what you’ve encountered and it’s a good chance that it is.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: If I want to get a quote for MSFT, do I need to have MSFT in some kind of portfolio or list a-priori or can I just query the API ad-hoc.\u00a0 If the latter, then does that just retrieve the data over the wire and cache it in the database?\u00a0 My symbol list changes from week-to-week and it would be extremely painful for me to provide it a prior.<\/span><\/p>\n

Answer:<\/span> The best way to get a quote in an ad hoc way would be to use either<\/p>\n

RetrieveSnapShot or
\nRetrieveAdjAndUnadjStock(\u00a0 long MarketNumber\/*[in]*\/,
\nlong LoadStartDate\/*[in]*\/,
\nlong LoadEndDate\/*[in]*\/,
\nVARIANT* IntResultArray\/*[out]*\/,
\nVARIANT* FltResultArray\/*[out]*\/,
\nlong* NumRecords\/*[out,retval]*\/) \/\/ [85]<\/p>\n

These return data in 2 variant arrays, an integer for dates, volumes, and a double float for pricing.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I\u2019d like to start pulling future data from CSI through the API and I can\u2019t find any documentation outlining how to access CSI through Python or Java.\u00a0\u00a0<\/span>
\nCould you provide me some guidance?<\/span><\/p>\n

Answer:<\/span> You’re right, I don’t have examples using those languages. I did find these for python, which is where you’ll need to start if you don’t have COM support:<\/p>\n

http:\/\/www.boddie.org.uk\/python\/COM.html
\nor
\nhttp:\/\/sourceforge.net\/projects\/pywinauto\/<\/p>\n

From there, you may look at the way perl connects, and imitate. There is an Exmple.pl in the uapi root.<\/p>\n

I’m not up on Python, but with Perl, I found that it does not support Variant array passing through COM.\u00a0 Therefore the return of data can only be done through the Clipboard, which is not advisable.\u00a0 I’d recommend you look into that before tackling this in Python.<\/p>\n

As for Java, if J++ is still around, that might work, but I’m not sure about Sun Java. This looks promising:
\nhttp:\/\/edn.embarcadero.com\/article\/33305<\/p>\n

But again, you may wish to check on the Variant Array passing to COM.<\/p>\n

I just perform another search, and found that Perl now supports this. Here is what the lingo talks about:<\/p>\n

Variants by reference
\nSome OLE servers expect parameters passed by reference so that they can be changed in the method call. This allows methods to easily return multiple values. There is preliminary support for this in the Win32::OLE::Variant module:<\/p>\n

my $x = Variant(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 my $y = Variant(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Corel->GetSize($x, $y);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 print “Size is $x by $y\\n”;<\/span><\/p>\n

After the GetSize method call $x and $y will be set to the respective sizes. They will still be variants. In the print statement the overloading converts them to string representation automatically.
\nVT_BYREF is now supported for all variant types (including SAFEARRAYs). It can also be used to pass an OLE object by reference:<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 my $Results = $App->CreateResultsObject;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Object->Method(Variant(VT_DISPATCH|VT_BYREF, $Results));<\/span><\/p>\n

so\u00a0 you could then POSSIBY translate something like this to get the data after
\nthe requests:<\/p>\n

$DateArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $OpenArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $HighArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $LowArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $CloseArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $DOWArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $DydmArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $ClosingBidArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $ClosingAskArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $VolumeArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $OIArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $TotalVolumeArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $TotalOIArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span>
\n\u00a0\u00a0\u00a0 $CashArray = Win32::OLE::Variant->new(VT_I4|VT_BYREF, 0);<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $numRec= $CSI_OLEhandle->CopyRetrievedDataToArray(0,<\/span>
\n\\$DateArray,<\/span>
\n\\$DOWArray,<\/span>
\n\\$DydmArray,<\/span>
\n\\$OpenArray,<\/span>
\n\\$HighArray,<\/span>
\n\\$LowArray,<\/span>
\n\\$CloseArray,<\/span>
\n\\$ClosingBidArray,<\/span>
\n\\$ClosingAskArray,<\/span>
\n\\$VolumeArray,<\/span>
\n\\$OIArray,<\/span>
\n\\$TotalVolumeArray,<\/span>
\n\\$TotalOIArray, <\/span>
\n\\$CashArray);<\/span><\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I am currently developing an application in Excel (2007) to access Unfair Advantage using the API2.<\/span>
\nThe purpose of the Excel application is to generate a report for a selected list of markets that includes the most recent rolled contract, the current contract and the next available contract.\u00a0 Once if have these contracts identified, I will extract specific contract information such as volume and open interest among other things.<\/span> I have completed the VBA code to generate a list of basic market information using the Market Profile function, such as market name, exchange, trade units, contract size, valid months, etc.\u00a0 This was rather straight forward.\u00a0 I also use the Build Contract List function to get the number of contracts for a particular market.<\/span> Now my primary question relates to using the Retrieve Back Adjusted Contract function.\u00a0 I define the various roll parameters such as the market number, roll logic type, roll when, valid months, roll at least N days before expiration, etc.\u00a0 I need to extract is the most recent contract roll date (\u201cLast Roll Date\u201d).\u00a0 Since this function returns the number of data days found, I am guessing that the most recent roll date is somewhere within this data, but I\u2019m not sure where I might find it.\u00a0 How do I determine the most recent roll date?\u00a0\u00a0 <\/span><\/p>\n

Answer:<\/span> You’ll need to iterate through the data to detect the last roll date. Within the data is the contract month field,\u00a0 just go to the end, and compare backwards until you find the change in delivery.<\/span><\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: Is the CSI API available for a C++ compilation?<\/span><\/p>\n

Answer:<\/span> Yes, the API is available for C++.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I’m trying to access stock prices via the OLE API.\u00a0 This code tries to access IBM prices for all dates:<\/span><\/p>\n

long count = ua->RetrieveSnapShot(5159, 1, 0, 0, 0, -1, -1, &longArray, &floatArray);<\/span><\/p>\n

The results include many rows for the sames date (with a different returned market number).\u00a0 If I only use the returned 5159 dates, I still get different results from the Unfair Advantage application.\u00a0 <\/span><\/p>\n

For date 19620102: UA close=2.64101139, API close=-24.936167.
\nWhy are some API prices negative? <\/span>Can you provide an API code example that returns the same prices for IBM that are displayed in Unfair Advantage?<\/span><\/p>\n

Answer:<\/span> For Stocks you may wish to try using<\/p>\n

\u00a0\u00a0\u00a0 count = UAapi->RetrieveAdjAndUnadjStock(5159, -1, -1, &IArray, &DArray);<\/span><\/p>\n

or you can stick with<\/p>\n

count= UAapi->RetrieveSnapShot(5159 ,1 , 0 , 0 , 0 , -1 , -1 , &IArray , &DArray);<\/span><\/p>\n

There are also some properties to consider:<\/p>\n

UAapi->SetApplyStockSplitAdjustments(1);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UAapi->SetRoundToTick(0);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UAapi->SetPropStockAdjustments(0);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UAapi->SetApplyStockDividendAdjustments(0);<\/span><\/p>\n

Here is sample array access code:<\/p>\n

VARIANT IArray, DArray;<\/span>
\n\u00a0\u00a0\u00a0 VariantInit(&IArray);<\/span>
\n\u00a0\u00a0\u00a0 VariantInit(&DArray);<\/span><\/p>\n

count = UAapi->RetrieveAdjAndUnadjStock(5159, -1, -1, &IArray, &DArray);<\/p>\n

if( count )<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 char strLineOut[128];<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 long NumIntColumns, NumFltColumns;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { SafeArrayGetUBound(IArray.parray,1,&NumIntColumns); NumIntColumns++;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SafeArrayGetUBound(DArray.parray,1,&NumFltColumns); NumFltColumns++;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 long *iArray; SafeArrayAccessData(IArray.parray,(void**)&iArray);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 float *dArray; SafeArrayAccessData(DArray.parray,(void**)&dArray);<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for(int c=0; c < count; c++ )<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetDate(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+0]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetDyDm(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+1]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetStrike(c) iArray[NumIntColumns*(c)+2]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetVol(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+3]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetTVol(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+5]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetOi(c)\u00a0\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+4]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetTOi(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+6]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetfStrike(c)dArray[NumFltColumns*(c)+0]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetOpen(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+1]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetHigh(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+2]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetLow(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+3]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetClose(c)\u00a0 dArray[NumFltColumns*(c)+4]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetBid(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+5]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetAsk(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+6]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ print to file the commod code<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if( isOption )<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0 sprintf(strLineOut, “%d,%d,%d,,%d,%g,%g,%g,%g,%g,%g,%d,%d,%d,%d,%d\\n”,\u00a0 nMarketNo,\u00a0 sGetDyDm(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetStrike(c), sGetDate(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetOpen(c), sGetClose(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetHigh(c), sGetLow(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetBid(c),\u00a0 sGetAsk(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetVol(c),\u00a0 sGetTVol(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetOi(c),\u00a0\u00a0 sGetTOi(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 nOptionConversionFactor);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fputs(strLineOut, pContractsOut);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } else<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0 sprintf(strLineOut, “%d,%d,,%d,%g,%g,%g,%g,%g,%g,%d,%d,%d,%d,%d\\n”,\u00a0 nMarketNo,\u00a0 sGetDyDm(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetDate(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetOpen(c), sGetClose(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetHigh(c), sGetLow(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetBid(c),\u00a0 sGetAsk(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetVol(c),\u00a0 sGetTVol(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sGetOi(c),\u00a0\u00a0 sGetTOi(c),<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 nConversionFactor);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fputs(strLineOut, pUnderlyingContractsOut);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SafeArrayUnaccessData(IArray.parray);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SafeArrayUnaccessData(DArray.parray);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0 ua->Release();<\/span>
\n\u00a0\u00a0\u00a0 flcose(ptr);<\/span><\/p>\n<\/div>\n

\n
\n<\/div>\n
UPDATE: We released a new API documentation. Click here<\/a> to download.<\/span><\/div>\n
\n
\n<\/div>\n
\n

Question: I am about to upgrade some software which interfaces with the Metastock format. How can I do some ‘C’ routines which can read Microsoft binary format (MBF)?<\/span><\/p>\n

Answer: <\/span>It is contained in the m2i_i2m.dll that is located in the ua\\uapi directory. This will translate the Microsoft binary into ieee float format and vice versus.
\nHere are the actual routines that can be used.<\/p>\n

extern “C”<\/span>
\n{<\/span>
\n\/\/ XXXX XXXX SMMM MMMM MMMM MMMM MMMM MMMM (MSBIN)<\/span>
\n\/\/ SXXX XXXX XMMM MMMM MMMM MMMM MMMM MMMM (IEEE)<\/span>
\nint msbintoieee( float *src4, float *dst4 )<\/span>
\n{<\/span>
\n unsigned char szIeee[4], szExp;<\/span>
\n memcpy( szIeee, src4, 4 );<\/span>
\n szExp=szIeee[3];<\/span>
\n szExp-=0x02; <\/span>
\n if( szExp == 0xFF )<\/span>
\n return 1;<\/span>
\n if( szIeee[2] & 0x80 ) <\/span>
\n szIeee[3]=0x80; \/\/ S <- S else szIeee[3]=0x00; szIeee[3]|=(szExp>>1); \/\/ -> XXXX XXXX<\/span>
\n if( szExp & 0x01 ) <\/span>
\n szIeee[2]|=0x80; <\/span>
\n else<\/span>
\n szIeee[2]&=0xEF;<\/span>
\n memcpy( dst4, &szIeee, 4 );<\/span>
\n return 0;<\/span>
\n}<\/span>
\n\/\/ SXXX XXXX XMMM MMMM MMMM MMMM MMMM MMMM (IEEE)<\/span>
\n\/\/ XXXX XXXX SMMM MMMM MMMM MMMM MMMM MMMM (MSBIN)<\/span>
\nint ieeetomsbin( float *src4, float *dst4 )<\/span>
\n{<\/span>
\n unsigned char szMsbin[4], szExp;<\/span>
\n memcpy( szMsbin, src4, 4 );<\/span>
\n szExp=szMsbin[3]<<1;>>7; \/\/ XXXX XXXX <- szExp+=0x02; if( szExp == 0xFF ) return 1; if( szMsbin[3] & 0x80 ) \/\/ S -> S<\/span>
\n szMsbin[2]|=0x80; <\/span>
\n else<\/span>
\n szMsbin[2]&=0x7F;<\/span>
\n szMsbin[3]=szExp; <\/span>
\n memcpy( dst4, &szMsbin, 4 );<\/span>
\n return 0;<\/span>
\n}<\/span>
\n}<\/span><\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I am running Linux and would like the ability to pull data from CSI via the C API. Is that possible?<\/span><\/p>\n

Answer: <\/span>We haven’t had a chance to embark on a Linux compatible UA.\u00a0 You mentioned
\nthat you were able to makes some calls through wine, but had problems with others.
\nMaybe we can try to facilitate these, although we’d have to reference wine to see if
\nit is capable of handling variant safearrays in the proper manner.
\nIt was CopyRetrievedDataToArray, and CopyRetrievedDataToArray2 that failed.<\/p>\n

Here is the proper way to use it:
\nVARIANT IArray, DArray;<\/span>
\nVariantInit(&IArray);<\/span>
\nVariantInit(&DArray);<\/span>
\n\u00a0<\/span>
\nint count= UAapi->CopyRetrievedDataToArray2(0, &IArray , &DArray);<\/span>
\n\u00a0<\/span>
\nif( count )<\/span>
\n{<\/span>
\n\u00a0\u00a0\u00a0 char strLineOut[128];<\/span>
\n\u00a0\u00a0\u00a0 long NumIntColumns, NumFltColumns;<\/span>
\n\u00a0\u00a0\u00a0 { SafeArrayGetUBound(IArray.parray,1,&NumIntColumns); NumIntColumns++;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 SafeArrayGetUBound(DArray.parray,1,&NumFltColumns); NumFltColumns++;<\/span>
\n\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0 long *iArray; SafeArrayAccessData(IArray.parray,(void**)&iArray);<\/span>
\n\u00a0\u00a0\u00a0 double *dArray; SafeArrayAccessData(DArray.parray,(void**)&dArray);<\/span>
\n\u00a0\u00a0\u00a0 for(int c=0; c < count; c++ )<\/span>
\n\u00a0\u00a0\u00a0 {<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetDate(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+0]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetDyDm(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+1]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetStrike(c) iArray[NumIntColumns*(c)+2]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetVol(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+3]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetTVol(c)\u00a0\u00a0 iArray[NumIntColumns*(c)+5]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetOi(c)\u00a0\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+4]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetTOi(c)\u00a0\u00a0\u00a0 iArray[NumIntColumns*(c)+6]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetfStrike(c)dArray[NumFltColumns*(c)+0]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetOpen(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+1]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetHigh(c)\u00a0\u00a0 dArray[NumFltColumns*(c)+2]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetLow(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+3]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetClose(c)\u00a0 dArray[NumFltColumns*(c)+4]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetBid(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+5]<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #define sGetAsk(c)\u00a0\u00a0\u00a0 dArray[NumFltColumns*(c)+6]<\/span>
\n\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fprintf(ptr,”%d, %g, %g, %g, %g\\n”, sGetDate(c), sGetOpen(c),sGetLow(c),sGetHigh(c),sGetClose(c) );<\/span>
\n\u00a0\u00a0\u00a0\u00a0 }<\/span>
\n\u00a0\u00a0\u00a0\u00a0 SafeArrayUnaccessData(IArray.parray);<\/span>
\n\u00a0\u00a0\u00a0\u00a0 SafeArrayUnaccessData(DArray.parray);<\/span>
\n}<\/span><\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I would like to retrieve data for the Hong Kong Dollar (QE7) like in the code below. I am not sure what call to make to actually retrieve the data. The functions RetrieveStock and RetrieveContract do not seem appropriate here; the former is for Stocks and the latter is for Futures. Is there an appropriate retrieve function for cash, spot, or FX data?<\/span><\/p>\n

Dim UA As Object<\/span>
\nDim NumBars As Long<\/span>
\nDim ErrNo As Integer<\/span>
\nSet UA = CreateObject(“UA.Api2”)<\/span>
\nUA.MarketSymbol = “QE7”<\/span>
\nUA.MarketNumber = UA.FindMarketNumber()<\/span>
\n‘ This will return MarketNumber = 2257…<\/span>
\nMsgBox “MarketNumber = ” & UA.MarketNumber<\/span>
\nErrNo = UA.GetMarketProfile()<\/span>
\n‘ This will return ErrNo = 1…<\/span>
\nMsgBox “ErrNo = ” & ErrNo<\/span>
\n‘ This will return QE7 : CASH: Hong Kong Dollars per 1 U.S. Dollar-#390(44)…<\/span>
\nMsgBox UA.MarketSymbol + ” : ” + UA.Exchange + ” : ” + UA.MarketName<\/span><\/p>\n

Answer:<\/span> You would use RetrieveContract<\/span> or RetrieveSnapshot<\/span> for these but specify
\n“54” as the delivery month. Kind of non-standard but that’s our cash code
\nhere at CSI.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: We are using the CSI API2 to extract daily options on futures prices. Our ‘C’ program uses your OLE interface and is very similar to your example ‘C’ code for retrieving option prices. Unfortunately, it takes 4 – 10 seconds to extract prices for a single option both from the API and using the UA application.<\/span>
\nA single futures market, CL, currently has 3169 active options. It takes about 6 hours to retrieve prices for these options. We have 50 additional futures markets that we need option prices, so the total time required exceeds 1 day. This makes it impossible to have option prices for all markets available on a daily basis.<\/span>
\nThis seems very high for a process that I assumed would be IO bound.<\/span>
\nWe have a critical need to get daily options prices in a reasonable amount of time. Can you give us a faster way to extract daily prices?<\/span><\/p>\n

Answer: We recommend using RetrieveSnapshot when accessing option data, as you have seen, the other method is not practical.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: This is the typical way to get data from a symbol:<\/span><\/p>\n

7. symbol = “AMRI”<\/span>
\n8. UA.MarketSymbol = symbol<\/span>
\n10. MarketNumber = UA.FindMarketNumber()<\/span>
\n11. UA.MarketNumber = MarketNumber<\/span>
\n12. ErrNo = UA.GetMarketProfile()<\/span>
\netc, etc.<\/p>\n

However, AMRI<\/span> is a symbol name that has been reused and thus exists twice in the DB. CSI API will return a handle to the FIRST one. Now, what is the easiest way to get ALL the handles one by one for symbol “AMRI<\/span>“?<\/p>\n

Answer:<\/span> In this unfortunate case, you may need to depend in our csi numbers, which are available in the factsheet. You can look up the ones you’re interested in, or iterate through them.<\/p>\n<\/div>\n

\n
\n<\/div>\n
\n

Question: I am needing to make a decision about using the API or pulling the data for stocks, futures, spot etc. from the CSI folders as ASCII. We need to pull the data into a database for processing. Some continuous futures contracts will be required. The guys at CSI did not know if continuous futures contracts would have to be built on each call from the API.<\/span>
\nI wanted to ask you if:<\/span>
\n1) Is it better to pull data from the ASCII files and use UA to generate them or use the API, and, if API is the better method,<\/span>
\n2) you are available for building this for me, or if it is better to have my programmer start from scratch with the API.<\/span>
\nI figured much of this has already been written, but the guys at CSI said the only thing they have available is the API doc.<\/span><\/p>\n

Answer:<\/span> Continuous contracts are rebuilt on every API call. A mechanism can be made to get around this, by first updating the database, and then parsing the update log to see if either a) correction has been posted to the market(s) you’re tracking or b) a roll has occurred. Then you would call to rebuild, otherwise you can call RetrieveSnaphot to obtain the last day of data.
\nSome customers are doing this from their software, and their are cases where it’s sensible, but I think in your case it may be easier to just update a portfolio and then have your software read those files, you’ll still need to read the whole file into your database, as continuous
\ncontract data does change back in time, at least back-adjusted ones do.
\nWe do have several example programs that use the API located under your ua\\API folder. The API is fairly straight forward, your programmer can always request my assistance if you choose
\nto go that way.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Question: I have been using a piece of software called FDC that interefaces with CSI’s API to access the data for neary four years now with out any problems. I recently purchased a new laptop with the Windows 7 Ultimate OS (64 bit) on it.\u00a0 On this computer the FDC software is not able to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":625,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/461"}],"collection":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=461"}],"version-history":[{"count":6,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/461\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/461\/revisions\/464"}],"up":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/625"}],"wp:attachment":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}