Basic Matlab and datafeed toolbox

1 次查看（过去 30 天）

P_Alpha 2015-10-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/248500-basic-matlab-and-datafeed-toolbox

Hi everyone,

I have the following code which asks users for the number of securities in a portoflio, and then asks the users for the tickers and quantities of each security in the portfolio. Once this data is entered, a call is made to yahoo finance which pulls back the latest price. I also did this for the symbol because I couldn't figure out how to convert the cell array into a column.

My objective here is to have 3 columns: the symbol, the latest price, and the market value (Which will have to be calculated). Any advice is appreciated! Below is what I have so far. FYI I am a total rookie so apologies if this is complete garbage.

%Users input stocks and quantities and the code executes to pull the latest
%prices and then calculate market value.
numsec = ('Enter the number of securities in Portfolio: ');
numsec = input(numsec)
Security = cell(numsec,1);
SecurityQty = nan(numsec,1);
for ns = 1:numsec
    Security{ns} = input(['Enter Security ',num2str(ns),' Ticker: '],'s');
    SecurityQty(ns) = input(['Enter Security ',num2str(ns),' Quantity: ']);
end
   c = yahoo;
   yhoo_fld = 'Last';
prices = fetch(c,Security,yhoo_fld);
tickers = fetch(c,Security,'Symbol');
PriList = prices.Last
tickerlist = tickers.Symbol