Index | Recent Threads | Who's Online | Search

Posts: 373    Pages: 38    1 2 3 4 5 6 7 8 9 10 Next
Last Post
This topic has been viewed 19089 times and has 372 replies
marco
FactSet beta site v1.0, NOW LIVE

Dear All,

The beta site on which you can compare Compustat to FactSet fundamentals is now live. You can access it here: https://beta.portfolio123.com

Once you sign in, click on your picture in the upper right-hand corner of your screen. You’ll see options for Data Vendor—Compustat or FactSet—and for PIT Method , which I’ll explain below.

If you choose Compustat as your Data Vendor, you should see pretty much what the regular P123 website offers. If you choose FactSet as your data vendor, all fundamental data will be what FactSet has provided us rather than what Compustat has provided us.

The stocks themselves will remain the same. The beta site does not represent universes created with Factset data (we do not expect the universes to differ much). Estimates are also still from CapitalIQ, as well as all remaining datasets. Little by little we’ll be adding other Factset datasets to the beta site.

RBICS is on the beta site, but for informational purposes only. In other words, you can look up a company’s RBICS code or the companies in an RBICS category, as explained here—https://www.portfolio123.com/mvnforum/viewthread_thread,12240—but we haven’t yet incorporated in ranking yet.

As for the PIT Method, here’s how it works.

For Compustat, "Use Prelim" reflects what we have now. Preliminary announcements are exposed when Compustat processes them. "Exclude Prelim" enables you to completely exclude preliminary announcements so that only data from complete statements from filing is exposed. NOTE: this is a brand new feature that did not exist before.

For FactSet, it’s a similar behavior from March 2020 onwards. The main difference for Factset lies when doing historical backtests since we had to make some compromises. The main problem lies in that Factset creates only one record for the as-reported period. This record is first populated with pre-announcement data (if the company pre-announces). When the SEC filing is processed, that record is overwritten, therefore Factset no longer has the original preliminary data.

The handling of preliminary data is the main problem with Factset in the context of a point in time database. NOTE: going forward, we at Portfolio123, are keeping the preliminary data so this will not be an issue for historical data starting around March 2020.

Luckily Factset does give us two key dates for past filings: when the preliminary data was first announced ("News Date") and when it was filed with the SEC ("File Date"). When you choose "Use Prelim" we expose the final data on the News Date + one day. This means that some data points may suffer from look-ahead biases. Depending your strategy, this may not matter much since many important items are usually always reported in press releases.

If you want a more conservative backtest approach you can choose to "Exclude Prelims" which will expose the data on the File Date + one day. NOTE: this may still suffer from a minor look-ahead bias since Factset may have taken a few days , or even weeks , to process the filing. We hope to revisit this later when we learn more about typical delays.

Lastly, if Factset has neither File Date nor News Date we lag the data 30 days for interims and 45 days for annuals. This is very rare and happens mostly with older periods. We have a new command for these instances, LaggedStmt, which will read true if the statement has been lagged.

As you play with the site, I’m sure a variety of questions will come up. Please don’t hesitate to post them below and we’ll do our best to answer them.

Thank You

Portfolio123 Staff.

Apr 16, 2020 8:43:39 PM       
Edit 3 times, last edit by marco at Apr 16, 2020 8:55:03 PM
wwasilev
Re: FactSet beta site v1.0, NOW LIVE

Ok, some Compustat/Factset sims have pretty similar results. One that doesn't seems to be b/c of the Close(0)/EVPS factor. To get rid of any share count issues. I decided to look at MktCap/EV. In many cases, the results are similar but there are exceptions like HUM. Why is the EV so different between the two DBs?

HUM:
Compustat:
EV=37,792.4013
Mktcap=46,704.4013

FactSet:
EV=48,764.4822
MktCap=46,704.4822

Apr 16, 2020 10:02:42 PM       
yuvaltaylor
Re: FactSet beta site v1.0, NOW LIVE

Ok, some Compustat/Factset sims have pretty similar results. One that doesn't seems to be b/c of the Close(0)/EVPS factor. To get rid of any share count issues. I decided to look at MktCap/EV. In many cases, the results are similar but there are exceptions like HUM. Why is the EV so different between the two DBs?

HUM:
Compustat:
EV=37,792.4013
Mktcap=46,704.4013

FactSet:
EV=48,764.4822
MktCap=46,704.4822


Good catch! Compustat has HUM with over $15 billion in cash and equivalents, while FactSet has it with only $4 billion. It looks like we might have accidentally switched Cash and CashEquiv. We'll fix it ASAP.

Yuval Taylor
Product Manager, Portfolio123
invest(igations)
Any opinions or recommendations in this message are not opinions or recommendations of Portfolio123 Securities LLC.

Apr 16, 2020 10:32:44 PM       
Edit 2 times, last edit by yuvaltaylor at Apr 16, 2020 10:41:43 PM
tissa123
Re: FactSet beta site v1.0, NOW LIVE

I noticed some differences calculating important ratios that depend on some important factors. For example AAPL's EBITDA TTM and Cash & Equiv TTM differ in each database.

Apr 17, 2020 12:37:45 AM       
rodbarcv2
Re: FactSet beta site v1.0, NOW LIVE

I am unable to run simulations on either Compustat or Factset.

For example, on https://beta.portfolio123.com/port_summary.jsp?portid=1596353 I am getting invalid benchmark error, no matter which benchmark I chose. For https://beta.portfolio123.com/port_summary.jsp?portid=1589247 I am getting invalid uid in PriceHistory.

I only tested these 2 so far.

Apr 17, 2020 5:57:13 AM       
dnevin123
Re: FactSet beta site v1.0, NOW LIVE

I am also receiving the "invalid uid in PriceHistory" error for the following port https://beta.portfolio123.com/port_summary.jsp?portid=1606334

Apr 17, 2020 7:59:12 AM       
philjoe
Re: FactSet beta site v1.0, NOW LIVE

So basically run your backtest with prelim, then without prelim, and the actual performance answer is somewhere in the middle of those two.

Apr 17, 2020 8:40:18 AM       
geov
Re: FactSet beta site v1.0, NOW LIVE

Beta site does not recognize the "Portfolio" function for both Compustat and Factset.

Apr 17, 2020 9:16:18 AM       
tissa123
Re: FactSet beta site v1.0, NOW LIVE

NFLX's EbitdaTTM is totally different between dbs.

Apr 17, 2020 9:23:28 AM       
marco
Re: FactSet beta site v1.0, NOW LIVE

Georg , Portfolio seems ok for me in the screener. Where do you see the problem ?

Portfolio123 Staff.

Apr 17, 2020 10:10:23 AM       
Posts: 373    Pages: 38    1 2 3 4 5 6 7 8 9 10 Next
 Last Post