MATLAB: Cell contents reference from a non-cell array object.

algorithmic tradingDatabase Toolbox

Hi,

I am dealing with the following error:

Cell contents reference from a
non-cell array object.

The error points me to the following line:

Error using dataset/subsrefDot
(line 80)

which corresponds to:

update(conn, tablename, columnnames, data, whereclause);

Any ideas on how to deal with the error? If needed i can provide the full code as well.

Best Answer

Apparently it's not a cell array at that point. Or something else is horribly wrong. This is where debug stop on errors is your best friend:

Run:

dbstop if error

This sets a condition to stop when an error is thrown so you can see everything as it is at the time of the error. Then recreate the error.

My magic eight ball guess is that l_equities.CONVERSION is empty; that it will eventually become a cell array but is not on your first iteration.

Related Solutions

MATLAB: How to fetch data from Bloomberg by using the CUSIP for a security with the Datafeed Toolbox 1.3.1 (R13)

The CUSIP for a security signifies the security and the market. The Datafeed Toolbox can fetch data using the CUSIP of a security.

For example the following returns the same results:

c = bloomberg;
data = fetch(b,'IBM US Equity')
data1 = fetch(b,'459200101')

MATLAB: How to get a list of all possible strategies that can be attached to an order in the Bloomberg EMSX API

After opening a connection to Bloomberg, you can use the function "getBrokerInfo" to obtain a list of the available strategies for a broker, as follows:

>> c = emsx('//blp/emapisvc_beta');
>> brokerstrat.EMSX_TICKER = 'ABCD US Equity';
>> brokerstrat.EMSX_BROKER = 'BMTB';
>> r = getBrokerInfo( c, brokerstrat )

The lines above return a list of the available strategies for the specified broker.

To obtain more information about a specific strategy, you can use the function "getBrokerInfo" again, as follows:

>> brokerstrat.EMSX_TICKER = 'ABCD US Equity';
>> brokerstrat.EMSX_BROKER = 'BMTB';
>> brokerstrat.EMSX_STRATEGY = 'SSP';
>> r = getBrokerInfo( c, brokerstrat )

You can find more information about the function "getBrokerInfo" at the following documentation page:

https://www.mathworks.com/help/trading/emsx.getbrokerinfo.html

Best Answer

Related Solutions

MATLAB: How to fetch data from Bloomberg by using the CUSIP for a security with the Datafeed Toolbox 1.3.1 (R13)

MATLAB: How to get a list of all possible strategies that can be attached to an order in the Bloomberg EMSX API

Related Question