variance between two pairs graphically ?

variance between two pairs graphically ?

frank
2011-07-09 23:08:08

I am looking to graph Variance between two correlated assets (for exemple : usoil/ukoil, or any other).
Thank You for your help, I am a total newbie at Quantshare ...

QuantShare
2011-07-11 08:26:16

Hi Frank,

Do you mean Covariance (or maybe correlation) between two assets?

Variance is usually applied to a single time-series.

frank
2011-07-11 11:41:59

Yes, exactly ! it would look somewhat like an RSI indicator but would plot values (difference between the two assets) instead of % (altough % should also do the job ;)
I'm Wondering if this can be done easily...? (I guess instutitional plateforms must have those capabilities integrated)
Chelios

frank
2011-07-11 12:00:32

I have found a covariance tool on your site but the string :

Plot(covariance(Perf(GetSeries("DIA", close), 1), Perf(GetSeries("SPY", close), 1),2), "Covariance DIA SPY", colorLime|55|colorLime|64|0, ChartBar, StyleOwnScale

does not seem to recognize the ",2" parameter.

(I changed tried changing the dia and spy to AD and BO, but does not help)

frank
2011-07-11 13:10:05

Just for information, I actually do it manually, with my broker. I take , let's say, 1 long USOIL and 1 Short UKOIL (on my demo account) and graph the results of my running total profit. This gives me a sinusoïdal pattern to witch I can apply technical analysis and risk management. Hope this extra info helps ;)
it would sure help me to find a cleaner solution...

QuantShare
2011-07-11 13:26:14

Best Answer

Actually, it is very easy:
- Create a new pane then click on the "Add Indicator" button (First icon on the top of the chart pane)
- Select "Operation" tab
- Select the minus operator (-)
- In the first input box, click on "Add", select "External Symbol" tab, select/type your asset symbol then click on "OK"
- Perform the same operation for the second input box (select a different asset symbol)
- Click on "OK".

This results in the creation of the following formula:
op1 = GetSeries('SPY', Close) - GetSeries('DIA', Close);
Plot(op1, 'Operation', colorBlack, ChartLine, StyleSymbolNone);

Regarding the Covariance function: (It works)
- You should download the indicator first (Covariance)
- Then apply the following formula (example):

Plot(covariance(Perf(GetSeries("DIA", close), 1), Perf(GetSeries("SPY", close), 1),2), "Covariance DIA SPY", colorLime|55|colorLime|64|0, ChartBar, StyleOwnScale);

Covariance (by Stefan Kroscen, uploaded several months ago)

No notes

frank
2011-07-12 15:23:46

pfff, I was missing ";" at the end of last string, thanxs. everything OK.
Where can I find the value for Brent ? is there a list I can consult with assets description ?

QuantShare
2011-07-13 07:24:40

Are you looking for a particular Brent index, ETF or futures?
Currently, we do not offer such list.

frank
2011-07-13 13:12:21

In order to play covariance I need both assets to be in the same category (ETF, CFD or futures). Correct me if i'm wrong but i don't think the numbers will mean much if I play Brent on futures and Crude on ETF ? (or maybe I'm wrong and I'll crunch the numbers ;)

frank
2011-07-13 13:34:49

FYI : My actual broker only deals CFD's (so basically "Stock market indexes")...but looking into a futures broker.

(sorry for any approximate english, I'm French mother tongue ;o

frank
2011-07-13 14:50:10

checked out ETF's, since we cannot go bear on ETFs it seems it would be impossible to hedge a covariance strategy.

QuantShare
2011-07-13 14:54:25

You can use assets that aren't in the same category. If you are creating pair strategies then I suggest you read about "cointegration".

To download futures data, you can use the following item: Futures and Forex historical data
For ETFs data: Historical Stock Market Data (Symbols: ETF Symbols)

You can also import CFDs data into QuantShare if you broker allows you to export historical data.

Futures and Forex historical data (by Tom Huggens, uploaded several months ago)

No notes

Historical Stock Market Data (by QuantShare, uploaded several months ago)

No notes

ETF Symbols (by QuantShare, uploaded several months ago)

No notes

frank
2011-07-13 22:17:46

Ok, thank you. I actually use FXCM (not the best but im still learning ;), for those who are interested I found historical data here :
http://forexforums.dailyfx.com/free-strategy-trader-historical-data/220967-free-strategy-trader-historical-data.html

Again, thank you for all your help, your software is quite interesting. I'll keep on playing around with it and see if i'm smart enough to make something of it !

...sad to say but "Time is our enemy" ;)

QuantShare
2011-07-14 08:16:46

Merci beaucoup pour le lien Frank. Si t'a besoin d'aide ou quoi que ce soit, n'hesite pas a me contacter. Tu peut aussi m'envoyer un email à support@quantshare.com

You can download updated Forex data here: Forex Intraday Data (10 years of one-minute bars)

Forex Intraday Data (by QuantShare, uploaded several months ago)

No notes

Get more messages

No more messages

Back


Trading Items Currency Pairs Calendar Data 31 Forex Pairs Historical Data Design and backtest a trading system with two strategies Pairs Trading Strategy Percentage of Stocks that are trading between their 50 and 200-da...	How-to Lessons How to display two stocks on the same chart How to plot two different time frames in the same chart How to plot the ratio of two stocks Difference between the watchlist and the screener tools How to create a log scale chart
Related Forum Threads Moving Key Info between Computers Creating Watchlist with Two Timeframes How to draw two symbols on 1 chart Pairs trading Import/Export objects between accounts	Blog Posts Buy the best/top rated stocks or how to create powerful rank base... How to deal with StockTwits data Different periodicities and chart bar types in QuantShare Trading... How to get buy and sell orders for a portfolio based on a trading... Download Trading Data using the URL-Script