Question

Import excel data from web doesn't work

Hi all, I need to import some data downloaded from an excel url. To do it, I download the excel on my pc (even if i don't need ...

29 days ago | 1 answer | 0

Question

How to change date in a website page

Hi all, I have a problem: I need to change the "Date Range" in this webpage https://markets.ft.com/data/funds/tearsheet/histori...

1 month ago | 1 answer | 0

Question

solve function give a wrong solution

Hi all, I'm trying to solve a simple equation in Matlab using solve function. The code is: syms x solv = solve( (1+x/12)^12 =...

3 months ago | 2 answers | 0

Question

From excel link to time table

Hi all, I have to download an excel file from this link: https://app2.msci.com/eqb/currency/performance/90463.48.all.xls and ...

7 months ago | 1 answer | 0

Question

How can I round numbers from summarize function at 2 decimals?

Hi everybody, Do you know how to round summarize numbers with only 2 decimals? For example I would like to read "Constant" v...

1 year ago | 0 answers | 0

Answered

From char to timetable

Simply great!!! The solution is what i wanted. I didn't know the splitlines function and it's very useful. Many thanks!!

From char to timetable

Simply great!!! The solution is what i wanted. I didn't know the splitlines function and it's very useful. Many thanks!!

1 year ago | 0

Question

From char to timetable

Hi everybody! I have a char variable of 1x446405. The structure of the variable is always the same like below: 2019-...

1 year ago | 2 answers | 0

Question

How to make a summation with index vector?

Hi! I need to solve this summation in Matlab: <</matlabcentral/answers/uploaded_files/117072/matlab.JPG>> where N is a con...

2 years ago | 1 answer | 0

Question

How to convert a cell vector with numbers and non-numbers into a comma-seprated (.csv) format?

Hi, I have the cell array: Matrix(1,1) = {'ABCD'} Matrix(1,2) = {'*'} Matrix(2,1) = {'251'} Matrix(2,2) = {...

2 years ago | 1 answer | 0

Question

Why ocr function doesn't recognize the numbers?

Hi, I have the image below: <</matlabcentral/answers/uploaded_files/101580/Captura.PNG>> I need to capture the numbers ...

3 years ago | 1 answer | 0

Question

How to change uicontrol properties in a callback function of a different uicontrol?

Hi everyone! I'm developing a GUI in which I would like to make invisible a popupmenu when every value is choosed by another pop...

3 years ago | 0 answers | 0

Question

How to load a variable into the workspace not as a structure into a GUI?

Hi everybody, I'm developing a GUI and I need to load a variable into the workspace. I'm using the "assignin" function but it ge...

3 years ago | 1 answer | 0

Answered

How do I label the grouped horizontal bars in MATLAB?

I solved adding this code: yb = [datas{2,2}, datas{3,2}, datas{5,2}, datas{1,2}, datas{4,2}]; for j = 1:size(yb,2) ...

How do I label the grouped horizontal bars in MATLAB?

I solved adding this code: yb = [datas{2,2}, datas{3,2}, datas{5,2}, datas{1,2}, datas{4,2}]; for j = 1:size(yb,2) ...

3 years ago | 0

| accepted

Question

How do I label the grouped horizontal bars in MATLAB?

I know someone uses the text function but I am ont able to solve my problem. This is my code: label = categorical({'A';'B';...

3 years ago | 2 answers | 0

Answered

Datafeed returns an error using fetch function

This is the Mathworks answer on my Technical Support on yahoo fetch function: I sincerely apologize for the recent issues you...

Datafeed returns an error using fetch function

This is the Mathworks answer on my Technical Support on yahoo fetch function: I sincerely apologize for the recent issues you...

3 years ago | 0

Answered

I have seven different graphs in one script and I want to see all seven graphs in one screen what matlab command I can Use.

Use subplot(m,n,p) function!

I have seven different graphs in one script and I want to see all seven graphs in one screen what matlab command I can Use.

Use subplot(m,n,p) function!

3 years ago | 0

Question

Java error to read pdf file

I'm trying to open a PDF file in matlab through java. The code is: clear java javaaddpath('C:\Users\AURYN BASE 1\Downloa...

3 years ago | 1 answer | 0

Question

How can i change value in a web drop down box?

Hello I need to read values from this webpage: <https://markets.ft.com/data/funds/tearsheet/historical?s=GB00B1VMCY93:EUR> ...

3 years ago | 1 answer | 0

Question

Bar plot error using text function

Hi, A friend with (Matlab2017) gave me this code: label = categorical({'IBS';'ZEN';'RE';'LRS';'SEASONAL';'AAA';'COMBOCOM...

3 years ago | 1 answer | 0

Question

How Can I extend chart range datas in excel using actxserver?

This is my code: excel = actxserver('Excel.Application'); excel.Visible = true; excel.DisplayAlerts = false; ...

3 years ago | 0 answers | 0

Question

How Can I change the range of a excel chart using actxserver?

This is my code: excel = actxserver('Excel.Application'); excel.Visible = true; excel.DisplayAlerts = false; filen...

3 years ago | 1 answer | 0

Question

How to get data from web?

Hello! I need to donwload the table and the datas in this url: http://www.morningstar.es/es/tools/categoryoverview.aspx?filte...

3 years ago | 1 answer | 0

Question

Undefined function or variable 'Sheets'.

Hello! I'm using this code to get formulas from excel sheet: excel = actxserver('Excel.Application'); excel.DisplayAlert...

3 years ago | 0 answers | 0

Question

Error using xlsread (line 260)

Hello! Today "xlsread" function give me this error: Error using xlsread (line 260) Undefined function 'Activate' for inp...

3 years ago | 1 answer | 1

Question

How can I extract content froma website?

I need to extract the "last price" from the second row (strike price 8,000.00) in this website: http://www.eurexchange.com/ex...

3 years ago | 1 answer | 0

Answered

can't connect to yahoo

Hello! I contact Matlab support and they give me a new code for datafeed toolbox. Now it works! You should do the same if you wa...

can't connect to yahoo

Hello! I contact Matlab support and they give me a new code for datafeed toolbox. Now it works! You should do the same if you wa...

3 years ago | 2

Question

Datafeed returns an error using fetch function

Hi everybody, I'm trying to use "fetch" function with this code: fetch(yahoo,'SPY',today()) but I recive this error: ...

3 years ago | 7 answers | 1

Question

Select my mail address to send mail by Outlook with Matlab

Hello, I'm using this function to send mail through Outlook with matlab: function sendolmail(to,subject,body,attachments) ...

3 years ago | 2 answers | 0

Question

Paste values in excel with MATLAB COM activeX

Hello I need to paste as values in Excel some copied cells. How Can I do? With my code I can copy as formulas and not as values!...

3 years ago | 1 answer | 0

Question

How can I detect the third saturday of each month?

Hello everyone! I have the follow vector of date-number: 734321 734328 734336 734342 734349 734356 734363 734371 734...

3 years ago | 1 answer | 0