Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (36) |
Author: lizgdal   😊 😞
Number: of 6131 
Subject: Re: Who is having success with smallcaps?
Date: 12/15/23 6:57 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 7
P123 is probably good (I haven't found anything better, except GTR1 of course), but might have look-ahead bias if not used carefully (adding lag if needed). FactSet is P123's primary data vendor. Preliminary data (based on news releases) can be used or turned off. With Prelim turned off, the fundamental data is exposed on the SEC File Date + one day. Live results could be different from the backtest, because live results depend on the FactSet processing time. P123 is striving to get closer to true PIT.

FactSet is the fourth largest player in the financial data space, and so the data and processing time are probably very good. The data quality might offset the small PIT issues. Prelim data could offer advantages if used correctly (waiting for filing and processing will sometimes reduce returns).

Equities Lab uses SEC filing date plus 4 days.

GTR1 uses the date the data was available for live trading. GTR1 live results and backtest results are the same.

=== links for more information ===
Equities Lab Comprehensive Data
"Our data changes daily, and covers each trading day from January 1, 1995 to present. Morningstar takes a few days to clean and process the data they get from the SEC, while they update the price data after the close of the market... Equities Lab uses the SEC release date, adds four days to account for processing delays, and makes the data available then."
equitieslab.com - Comprehensive data

The Timing of the Earnings Press Release and the Annual Filing, May 24, 2018
About 12 days on average between Earnings News Release and 10-K filing.
calcbench.com - The timing of the earnings press release and the

Comparison of the Costs and Features of the Four Leading Financial Data Providers [Bloomberg, Capital IQ (CapIQ), Factset and Refinitiv]
"As of 2017, FactSet had 89,000 clients with total revenue of approximately $1.3 billion, making it the fourth largest player in the financial data space"
wallstreetprep.com - Bloomberg vs capital iq vs factset vs thomson reuters eikon

some discussion of this at P123:

FactSet beta site v1.0, NOW LIVE, April 2020
"options for Data Vendor—Compustat or FactSet—and for PIT Method"
"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."
"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."
community.portfolio123.com - Factset beta site v1 now live

Help - “PIT Method - Prelim”, March 2021
community.portfolio123.com - Live strategy different than simulated strategy of the same date

SURVIVORSHIP BIAS?, December 2021
"ETFs are far superior investment vehicles than common stocks for an evidence-based, data-driven investment process, IMO."
community.portfolio123.com - Survivorship bias

Our Financial Data Providers and Approach to Historical Data Accuracy, updated September 2023
"Since we began using Factset as our primary data provider, we strived to improve how close the data is to true PIT by tracking changes and backfills by Factset."
portfolio123.customerly.help - Our financial data providers and approach to historical data accuracy
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to lizgdal here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,106 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (36) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community