public static object CALSecurityCategory(string standard, int level, string fieldsStr, int date)
{
try
{
if (ExcelDnaUtil.IsInFunctionWizard())
{
return("!!! In FunctionWizard");
}
DataAPI tmp = new DataAPI();
DateUtilities.CALDate snapDate = new DateUtilities.CALDate(date);
return(Utilities.ArrayResizer.Resize(tmp.SecurityCategory(standard, level, fieldsStr, snapDate)));
}
catch (Exception e)
{
return(Utilities.ExcelRangeErrorString(e));
}
}
public static object CALMarketDataGetHistDailyQuotes(string securityID, string fieldsStr, int start, int end)
{
try
{
if (ExcelDnaUtil.IsInFunctionWizard())
{
return("!!! In FunctionWizard");
}
DataAPI tmp = new DataAPI();
DateUtilities.CALDate startDate = new DateUtilities.CALDate(start);
DateUtilities.CALDate endDate = new DateUtilities.CALDate(end);
return(Utilities.ArrayResizer.Resize(tmp.MarketDataGetHistDailyQuotes(securityID, fieldsStr, startDate, endDate)));
}
catch (Exception e)
{
return(Utilities.ExcelRangeErrorString(e));
}
}
public static object CALFundamentalBalanceSheetRange(string securityID, int start, int end, string fieldsStr, string reportType)
{
try
{
if (ExcelDnaUtil.IsInFunctionWizard())
{
return("!!! In FunctionWizard");
}
DataAPI tmp = new DataAPI();
DateUtilities.CALDate startDate = new DateUtilities.CALDate(start);
DateUtilities.CALDate endDate = new DateUtilities.CALDate(end);
//return tmp.FundamentalBalanceSheetRange(securityID, startDate, endDate, fieldsStr, reportType);
return(Utilities.ArrayResizer.Resize(tmp.FundamentalBalanceSheetRange(securityID, startDate, endDate, fieldsStr, reportType)));
}
catch (Exception e)
{
return(Utilities.ExcelRangeErrorString(e));
}
}
