NexusFi: Find Your Edge


Home Menu

 





Backtesting an idea - help


Discussion in Platforms and Indicators

Updated
    1. trending_up 1,707 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 Volt 
Whitehall, NY
 
Experience: Advanced
Platform: TOS, Market Delta
Broker: Infinity, TOS, IB
Trading: es
Posts: 277 since Aug 2012
Thanks Given: 125
Thanks Received: 395

I'm not sure if I am on the right sub forum for this question but I am looking to back test a variation on the Dogs of the Dow. So can somewhat point me to a place where I can get the data ( I can go back manually and this doesn't have to be automated) for the Dow that will give me the forward price to earnings ratio - 12 month and price to sales ratios.

I want to see how a method performs if I buy the 5 lowest priced stocks in the Dow each quarter that have a positive 12 month forward P/e ratio and a low price to sales ratio. Each quarter I would do the same search again and rotate out to new stocks if/when needed. Re-balancing the portfolio to equal dollar amounts. I want to go back the past 25 years to see how this idea has performed.

any ideas as to where to turn for such data would be appreciated. I apologize if this post is in the wrong place and please help me get it moved to where the appropriate eyes can see it.

Thanks,

Volt


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
CPI Eve: Fed Hike Odds Hold at 52% for the First Time, I …
Prediction Markets & Event Contracts
Probability Collapse: Bitcoin $150k Craters from 15% to …
Prediction Markets & Event Contracts
Iran Talks Final Stages -- Two VLCCs Exit Hormuz, Record …
Traders Hideout
The Great Rotation -- Small Caps Crushing Tech as Sectio …
Traders Hideout
GDP Day: The First Economic Reckoning -- Pahlavi at 6.55 …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Lady Vols Primer: Trading Volatility Journal
6 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Trying to learn Volume and price action correlation
5 thanks
  #3 (permalink)
 
Fu510n's Avatar
 Fu510n 
Suffield, CT
 
Experience: Advanced
Platform: TS, MC, MW, Python, Rust
Broker: TS, IB, IQFeed, Kraken
Trading: NQ, ES, CL, RTY
Frequency: Several times daily
Duration: Seconds
Posts: 165 since Oct 2009
Thanks Given: 942
Thanks Received: 165



Volt View Post
I'm not sure if I am on the right sub forum for this question but I am looking to back test a variation on the Dogs of the Dow. So can somewhat point me to a place where I can get the data ( I can go back manually and this doesn't have to be automated) for the Dow that will give me the forward price to earnings ratio - 12 month and price to sales ratios.

I want to see how a method performs if I buy the 5 lowest priced stocks in the Dow each quarter that have a positive 12 month forward P/e ratio and a low price to sales ratio. Each quarter I would do the same search again and rotate out to new stocks if/when needed. Re-balancing the portfolio to equal dollar amounts. I want to go back the past 25 years to see how this idea has performed.

any ideas as to where to turn for such data would be appreciated. I apologize if this post is in the wrong place and please help me get it moved to where the appropriate eyes can see it.

Thanks,

Volt

Not sure what's out there for "free" though I suppose you could figure out what individual/component stocks made up the Dow throughout each quarter for the past 25+ years manually. I Googled and found Siblis which appears to have what you're looking for for $49. Never used them and can't vouch for them in the least but it's a start..

From the website:
"DJIA Index Researcher Dataset by Siblis Research that has the monthly share prices, outstanding shares, quarterly earnings, market caps, P/B ratios, total returns and weightings of the individual companies since 3/31/1979."

-Guy

p.s. if you decide to go the manual route, I'd start with Historical components of the Dow Jones Industrial Average to get the list of companies (sadly no symbols), and after getting the symbols, use Yahoo finance Python module (with Pandas) to download the raw data and go from there.


Follow me on X Reply With Quote
Thanked by:




Last Updated on December 20, 2016


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts