HT create a new vector in data frame that takes correlation of existing vectors

Posted by Milktrader on Stack Overflow See other posts from Stack Overflow or by Milktrader
Published on 2010-03-18T01:11:33Z Indexed on 2010/03/18 1:41 UTC
Read the original article Hit count: 353

Filed under:

I have a time series of two indexes, with each row representing the closing price on the same day. I'd like to go to row 30 and lookback over the last 30 'days' and calculate the pearson correlation. And then store that value in a new vector. Then, repeat the calculation for the entire time series.

It is a trivial task in Excel, so I'm convinced it can be done in R. I don't know the method to use though.

Related posts about correlation

HT create a new vector in data frame that takes correlation of existing vectors

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a time series of two indexes, with each row representing the closing price on the same day. I'd like to go to row 30 and lookback over the last 30 'days' and calculate the pearson correlation. And then store that value in a new vector. Then, repeat the calculation for the entire time series… >>> More
using Excel VBA, given the daily price of 50 stocks, choose 10 stocks such that they have the minumu

as seen on Stack Overflow - Search for 'Stack Overflow'
The high-level goal is to choose 10 stocks that have the lowest correlation among one another, out of a pool of 50, so that I can have a well-diversified portfolio. I have managed to write some VBA macro to download the past 3 years of daily price data from Yahoo finance, and then compute the 50x50… >>> More
MySQL: Complex Join Statement involving two tables and a third correlation table

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two tables that were built for two disparate systems. I have records in one table (called "leads") that represent customers, and records in another table (called "manager") that are the exact same customers but "manager" uses different fields (For example, "leads" contains an email address… >>> More
Updating Workflow Task without Correlation Token

as seen on Stack Overflow - Search for 'Stack Overflow'
I have inhertied a sequential sharepoint workflow which deals with multiple tasks for different people; multi step approval based on certain condition..For each approval new task is created and monitored...For some reason; we have decided to use single task for the whole workflow and the single task… >>> More
Workflow Foundation 4 WorkflowServiceHost Message Correlation

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 2 methods on a workflow service hosted in WorkflowServiceHost. The first method is called and starts the regular workflow sequence - talking to other web services, database work etc but on some occassions will pause and persist to db (as-in the delay activity) and wait for some human action… >>> More

Developer IT

HT create a new vector in data frame that takes correlation of existing vectors - Developer IT

HT create a new vector in data frame that takes correlation of existing vectors

r

correlation

Related posts about r

Related posts about correlation

HT create a new vector in data frame that takes correlation of existing vectors

using Excel VBA, given the daily price of 50 stocks, choose 10 stocks such that they have the minumu

MySQL: Complex Join Statement involving two tables and a third correlation table

Updating Workflow Task without Correlation Token

Workflow Foundation 4 WorkflowServiceHost Message Correlation

Categories cloud