CANADA & NEW USA are now live (old USA accessible in the beta server)

@Oliver. Great points. Agree with all of them and will be looking at ADRs.

I have been suspicious enough about the estimates data that I have spent the weekend looking again at Zacks. Yesterday I said to myself: “self, they really do not have backtest results that are as good as P123.” This morning, I said to myself two things. First, their Zacks Rank is guaranteed to be PIT unless there are accounting issues or they are dishonest. This is because the Zacks Rank data is generated in house. Second, I note that their less than spectacular backtest results are in line with my out-of-sample results.

The thing that is really causing me to look for answers is that my out-of-sample results are NOT EVEN CLOSE TO BACKTESTED RESULTS OVER THE SAME TIME PERIOD. I have looked at every trade for one port (and started on the others) and it is not due to slippage. Comparison of port to sim is difficult because I am still pretty new so I have made changes in my ports. BTW my ports have lots of trades and few degrees of freedom. The difference between sim and port is looking statistically significant. Still, I am making money and have no reason to complain. However, if I can find a way to do better…

J:

  So this could be a big problem?

Bill

Marco,

Is this still planned to be fixed? It still shows 119 compnies with Country(“CAN”). This will again change the sim results for anybody using Prussell 3000 universe.

KJ

They are not the “Russell” universes, rather our own approximate versions. Excluding companies domiciled in Canada seems like a good reason to rebuild them, which we can, however it’s a balancing act between being closer to the Russells and causing backtests to change.

We also need to investigate which countries are ok to have in the Prussells. Pretty sure that Bermuda (and few others) domiciles should be ok

Would it be possible to keep the old Prussell3000 universe alive as well as the new t.b.d. version which excludes Canada?

Keeping different versions of Prussells makes the universe list very long and confusing.

Just released the first Canadian R2G on P123 platform, let’s see how it goes :smiley: ! It is a 20 stocks large caps with high liquidity low turnover low drawdown portfolio.

If you are interested in the highest liquidity /w no hedge version, Canadian Portfolio Managers lurking here please PM me.

I would have liked XIU… Marco any plans to make it available in the ETF list any soon? I’m going to use SPY temporarily.

Quant

Amazing guys. I love it. Quick question. How do I exclude Canadian income funds from my results. .UN

This is a good question. .UN are investment trusts and I don’t think there is a way to distinguish these. I suggest using the following rule:

DivPSDays(365,0,#Regular,#PayDate,TRUE)<12

This will exclude all companies paying monthly dividends. This will eliminate the majority of .UN’s. But it will also eliminate other companies, perhaps some of them former .UN’s as the tax laws changed a few years ago and many investment trusts converted to normal companies.

Even with the above rule, there are a handful of .UN’s that won’t be filtered out. Try screening for: DivPSDays(365,0,#Regular,#PayDate,TRUE)=4 and you will still see some of these. You can get rid of these by adding them to a global restriction list or inlist.

Steve

Should we should just throw out .UN companies our of the main “All Fundamentals - CANADA”? We will create a universe only of investmet trusts that you will be able to use to screen them out, but maybe its better to separate them completely?

I wouldn’t throw them out of the main universe but perhaps a Universe filter such as Universe(UN) would be a good idea. A separate universe would also be nice but not absolutely necessary.

Steve

The correct terminology is “Income Trust”. http://en.wikipedia.org/wiki/Income_trust

Geov asked a good question: how are the gain and losses of a US hedge instrument handled inside a Canadian portfolio? Are they converted in Canadian dollars every time or the US dollar is mixed with the Canadian funds assuming a 1:1 rate? This brings again why a Canadian hedge is mandatory.

Marco,

In addition to these Income trusts, gonna need a reliable way to identify companies that might be PFIC’s for foreign investors. Possible flags could be very hi levels of ‘passive income’…and ‘passive assets’ not sure if Compustat lets you guys screen for this?

See:
http://www.shapirotaxlaw.com/the-pfic-asset-test-a-trap-for-the-unwary/

And (for a flowchart):
http://www.shapirotaxlaw.com/wp-content/uploads/2013/09/PFIC-asset-test-flowchart.pdf

Can you guys create reliable screens to exclude these from both the Canadian universe and from ADR’s?

Best,
Tom

Tom , do you have examples of PFIC’s ?

A lot of small mining or oil companies are possibilities (own land or a mine…but not much operating income). But, some are big. See:

  1. Fronteer Gold (since acquired), but was listed…and was (I think) a PFIC.
    http://www.newmont.com/sites/default/files/u87/PFIC%20Statement%20-%20Fronteer%20Gold%20(FKA%20Fronteer%20Development%20Group,%20Inc.)%20-%20For%20the%20year%20ended%20April%206th,%202011.pdf

See also:
TICKER: FRG:TSX; FRG:NYSE.MKT

Other private company I found -
2. Pembrook mining co. http://www.pembrookmining.com/i/pdf/2012-02-15_PFICL.pdf. Still private. (They have $53 Million in assets, so not tiny). But, they have been ruled a PFIC. See also:
http://www.pembrookmining.com/i/pdf/FS/2013/Pembrook_FS_Q4_2013.pdf

However, the Harvard report I posted talks of someone inheriting a lot of these when her Dad died and having a tax nightmare.
http://isites.harvard.edu/fs/docs/icb.topic1321119.files/October%209%202013%20%20Articles%20and%20Readings/PFICs_Gone_Wild.1.pdf

These same issues can apply to ADR’s.

  1. Here’s a tiny one. http://www.u3o8corp.com/docs/Investors/US%20Shareholder%20Info/US%20Tax%20information%20memo%20-%20FINAL_apr%201%2013.pdf. Ticker: U3O8 CORP (UWE.TO). They are too small to even look at. But, they were / are a PFIC.

Best,
Tom

Sorry, looks like there’s nothing in the data that identifies PFIC’s

One weird thing that you might notice in backtests is .NV, .SV, .MV, .RV suffixes after some of the ticker symbols. This happened 9 or 10 years ago for a year or two. The suffixes described the voting characteristics of the shares. For example, .NV meant nonvoting. They weren’t very popular and didn’t last too long. But they might live on in the Compustat historical data.

Is it possible to add Canadian market ETF’s for the portfolio(Hedge) backtest tool? And Canadian ETF’s for the ETF simulator?

Hi Marco,

I recall Europe data was in the pipeline as well. Any time schedule for this ?

Thanks,