Question

How do I convert a table to .csv format

I have the follwing code, and i wish to convert a table to a .csv format and not a .txt as this code does. The inputfile is a nu...

1 year ago | 1 answer | 0

Question

Finding peak (highest price), trough (lowest price), and average distance between peak and trough for a series of prices

I have a n x m cell array of prices. I use the code below to find the highest price, the lowest price, and the percentile rang...

1 year ago | 0 answers | 0

Question

use workspace variables as input to generate multiple text file outputs

I have n workspace variables which all happen to be tables. The following script takes one such variable for example GPB_USD as...

1 year ago | 1 answer | 0

Question

remove table header row

I have the attached table which I wish to 1) Remove the header row. 2) duplicate the second column and append to end, making...

1 year ago | 1 answer | 0

Question

horizontal concatenate a datetime structure to a table array

Hi I am trying to place a datetime array next to a table array I am trying the follwing but getting an error. Once they...

1 year ago | 2 answers | 0

Question

date and time format change

i have a cell n x 2 table array. The first column containd dateas in the format of 'yyyy-MM-dd''T''HH:mm:ss.SSSSSSSSS''Z''' ...

1 year ago | 1 answer | 0

Question

Indexing into a m x n array to find values using an array of row and column indices

I have a cell array A. and marrix B A = [2,4,0.5,0.34;0.01,4,0.5,0.34;10,4,0.2,0.6;10,4,0.2,0.6;19,15,0.7,0.6] B = [1,1;1,2;2,...

1 year ago | 1 answer | 0

Question

return row index of values greater than 0 to a 3 dimensional array

I have a Matrix A, of m x n dimensions. I wish to go through each row from left to right and return the index of values greater...

1 year ago | 2 answers | 0

Question

VORTEX TECHNICAL INDICATOR CODE

I am trying to find some matlab code for the vortex technical indicator

1 year ago | 0 answers | 0

Question

How to calculate the n period Element difference every in a matrix ?

Hello. I have a matrix A, of size n x m, and second matrix of prices, matrix B same size. I wish to find the difference b...

1 year ago | 1 answer | 0

Question

How to save each iteration of a loop into the same sheet of an Excel spreadsheet using a mac and the function Mac OSX friendly function xlwrite

How I am trying to write the outputs of each iteration of each loop to the same spreadsheet but in different sheets. Thus ...

2 years ago | 1 answer | 0

Question

I want to create a date vector in serial format. I know the end date, but I wish to be able to go lets say n period back from this date in either daily or weekly steps. The end date should be at the bottom of the vector. Any help?

I want to create a date vector in serial format. I know the end date, e.g, 21st June 2018, but I wish to be able to go lets say ...

2 years ago | 1 answer | 0

Question

How do Index into a structure array and assign columns to a variable

I have what looks likes a structure array as output. Each cell of the structure array is n x 5. I wish to attract columns 2, 3...

3 years ago | 1 answer | 0

Question

can i used cellfun with a function which has more than one input?

Hello I have a function as follows [ chart_datavortex ] = chart_funcv( 'AUD_USD', New_dataopenbidx, New_datahighbidx, New_d...

3 years ago | 1 answer | 2

Question

how do I delete a duplicate record from an SQLite database using a MATLAB command

Hi I have an sqlite database with records which can be identified by a datetime string. i have a duplicate entry and which to d...

3 years ago | 1 answer | 0

Question

update SQLite database using insert

Hello I am trying to update my SQLite database using the following command insert(conn, 'ClosePriceTable', {'Dates','AUD_CAD...

3 years ago | 1 answer | 0

Question

Extract data from a nested structure array

Hi I am new to matlab. I wish to extract data from an structure array. the data is char type and double type. I am using...

3 years ago | 1 answer | 0

Question

How do i use the timer function to execute a script at 06:00hrs each day monday through friday

I currently have the following but i want this to occur each day at the same time T1 =timer(TimerFcn','myscriptname') St...

3 years ago | 2 answers | 0

Question

why does Matlab return ' expression to the left of the equals sign is not a valid target'

I am using MATLAB 2017a and Python 3.6 I am trying to call a Python script from within the MATLAB window and assign the returned...

3 years ago | 2 answers | 0

Question

How do I pull data from an SQLite daatbase into Matlab workspace

Hi I have somehow managed to put together some python code to retrieve data in an SQL lite database, I know which to pull that ...

3 years ago | 1 answer | 0

Question

updating an sql lite database on my macbook delete and insert

Hi I wish to update an SQL Lite database file in Matlab on my macbook I understand sql lite has limitations. The replace funct...

3 years ago | 1 answer | 0

Question

How can my Matlab script read streamed data from my Python script

I have created a script in Python which streams live data to my terminal on my Macbook. I am suing Python 3.6. At this point I m...

3 years ago | 1 answer | 0

Question

Neural Network (NARX) performance interpretation - how small is small?

I have built a neural network to forecast currency pair prices (trend) a few steps ahead. How do I interpret the performance pl...

3 years ago | 1 answer | 0

Question

Neural Network for Currency Forecast - How do I stop it from repeatedly training after I am happy with my NN performance?

I have read a few papers on using a Neural Network to forecast a few periods ahead the price or trend in a Currency pair. I hav...

3 years ago | 1 answer | 0

Question

what are NARX Function inputs "X" and "Xi"? Whats is an example of both?

Allow me to preface I am somewhat new to Matlab, and Neural Networks. Despite this I have created a NARX function to predict mul...

3 years ago | 1 answer | 0

Question

Factoran and postive definite matrix

I wish to perform some factor analysis on my portfolio I have a matrix of returns and wish to use the factoran function to deriv...

3 years ago | 0 answers | 0