correlation matrix online?

[Sidekicker]

Does anyone know of an up to date correlation matrix online?
similar to this:
http://kurtosistrading.com/blogspot/wp-content/uploads/2010/01/matrix.png

I'm more interested in the relationship of bonds, FX, and commods than just FX pairs.

 

[scose-no-doubt]

You'd be better off building it yourself.

On a related note, do any Excel/VBAers have some code I can use that will automatically populate an excel sheet with EOD figures.

 

[BILLV]

What do you think of this?

Forex Correlation

 

[Sidekicker]

You'd be better off building it yourself.

On a related note, do any Excel/VBAers have some code I can use that will automatically populate an excel sheet with EOD figures.

Yeah, but then I have to get EOD data for many symbols and it's not that easy with the UK brokers.

What do you think of this?

Forex Correlation

Thanks, but that's FX only.

 

[scose-no-doubt]

What's wrong with yahoo or msn EOD? The problem I have is coding in the auto update. Completely at a loss

 

[Sidekicker]

What's wrong with yahoo or msn EOD? The problem I have is coding in the auto update. Completely at a loss

They don't have futures as far as I know especially not Bund data.

 

[scose-no-doubt]

Deutsche Bundesbank - Browser-Empfehlung

any good?

Wouldn't commods and FX spot be a decent enough proxy for correlation purposes?

 

[cr6196]

What's wrong with yahoo or msn EOD? The problem I have is coding in the auto update. Completely at a loss

I have seen auto-updates using google, yahoo, and advfn before. I have a spreadsheet (I didn't write it) that does it somewhere but try looking through the google finance API? I have heard it is pretty straightforward to do.

Actually scratch that, I have had a look at the code for excel and it is complicated. It is far easier to use google finance API/javascript.

 

[scose-no-doubt]

Thanks mate

Not seen you round in a while. What gives?

 

[Sidekicker]

I have seen auto-updates using google, yahoo, and advfn before. I have a spreadsheet (I didn't write it) that does it somewhere but try looking through the google finance API? I have heard it is pretty straightforward to do.

Actually scratch that, I have had a look at the code for excel and it is complicated. It is far easier to use google finance API/javascript.

Google FInance doesn't do FX or futures AFAIK.

 

[scose-no-doubt]

Think he was talkin to me mate but as I said before isn't the spot a close enough proxy for correlation purposes.

 

[ppt33]

Does anyone know of an up to date correlation matrix online?
similar to this:
http://kurtosistrading.com/blogspot/wp-content/uploads/2010/01/matrix.png

I'm more interested in the relationship of bonds, FX, and commods than just FX pairs.

try this site it has something similar... but intraday 20 Day and 60 days

Correlation Matrix – Overview 02/06/2012 - Commodity Farm

 

[ppt33]

Does anyone know of an up to date correlation matrix online?
similar to this:
http://kurtosistrading.com/blogspot/wp-content/uploads/2010/01/matrix.png

I'm more interested in the relationship of bonds, FX, and commods than just FX pairs.

try here... something similar

Correlation Matrix – Overview 02/06/2012 - Commodity Farm

 

[ppt33]

sorry for the double up... new around here.

 

[lieblm]

Google FInance doesn't do FX or futures AFAIK.

It does FX actually:

=GoogleFinance("CURRENCY:USDEUR")

 

[alphadude]

Yeah, but then I have to get EOD data for many symbols and it's not that easy with the UK brokers.



Thanks, but that's FX only.

I wouldn't trust any provider to give me correlation matrix of products that I am going to trade.

correlation matrix is dependent on the lead/lag of its constituents. how do you know what these fellows are providing? how do you guarantee there is no look ahead bias; or if they used the EOD price vs adjusted price; or any other price for that matter.