Historical Stock Prices???
I was told to calculate the cost basis for a client's portfolio which was positioned at different intervals between 1970 and 2000. First of all, being new to this stuff, what price should I use to calculate the cost basis for a certain stock; the split adjusted price or the regular price? At first I thought the adjusted, but isn't that used for comparison purposes only? Secondly, where can I find prices for purchases in the 70s? Most sites like Yahoo Finance and MarketWatch only go back so far. Thanks so much for the help.
Bump
lol this sucks. This was my first project they had me do at my 2nd PWM internship for AT&T. Let me just tell you figuring out cost basis for AT&T and all the spin offs and spin off of spin offs is just a nightmare. Good luck.
"Oh the ladies ever tell you that you look like a fucking optical illusion" - Frank Slaughtery 25th Hour.
Historical Stock Info (Originally Posted: 11/14/2011)
Running a regression and need data for historical stock prices/exec comp/AUM etc. It's nothing too far back at most about 10-15 years. Realize this isn't exactly an ER-related question, but I figured this would be as good of a place as any to ask.
Any sites have this info for free? Like for Merrill, etc? Thanks in advance.
yahoo finance
enter ticker
go to historical prices
scroll all the way down to export to spreadsheet
Got t for Lehman, but no such luck for Merrill. Any suggestions? Just looking for yearly data 2000-2008.
Modeling Historical Stock Data (Originally Posted: 04/02/2013)
I am usually just an onlooker here in WSO, don't really post or comment, I just consume the information and watch the spots of hilarity ensue.
But, time to ask a question.
(Caution: I'm a bit lost, I'm in college)
Recently, I added on a module in my Excel to download historical data in any range on any NYSE stock, but I'd like to know how can I begin to model situations from the data, and begin to develop my own trading style and theories.
Note, I don't want to be a trader, I want to be an Investment Banker, but I'd like to understand all aspects of the whole financial atmosphere.
Please don't slaughter me in the comments though, I'm still visiting the library picking up texts, consuming Mergers & Acquisitions, listening to H/Y/W econ and finance lectures, and learning from what you guys post.
Just nudge me in the right direction without kicking the shit out of me.
If it matters, I'm up $4.5M in two months in live training. Up $325k on Tesla for the day.
Soon kids in middle school will be wanting to be investment bankers
Dammit goblan, couldn't you just answer the question? Besides, it's good to have a decent headstart.
Is there anyway you can tell us the name or link where we can get the excel add in?
I'm still testing it out: http://sourceforge.net/projects/kuzelamacro/
what do you want to model ?
I want to be able to start compacting and creating algorithms so I can eventually compare it to a benchmark, and review the algorithm's results and risk metrics. So, modeling anything I can starting with say momentum trading.
You don't even say what data you have... closing prices only?
My bad, yes open to closing prices.
data for modeling (Originally Posted: 03/18/2011)
HI monkeys,
Maybe someone can help me out. I am trying to get financials for a stock I am currently modeling that requires financials back to 2008. However, I cannot get any financials past Dec of 2009 for quarterly data. I do not have access to Bloomberg, Factset, or anything like that. Is there any place else that I can get that data for free or am I literally going to have to go through the 10k and q's and construct all the info for the equity model I am working on for a stock valuation.
Cheers!
You should be using the K's and Q's anyways because of the footnotes and other important items that you can't afford to miss
Yes that's one short cut you should not be taking. Always go directly to the filings, also listen to earnings calls, specifically the Q&A.
Database/spreadsheet of daily stock prices? (Originally Posted: 06/07/2008)
I am curious when I read research reports and working papers that analyze historical stock prices where they get their data from. Is there anywhere online that has a spreadsheet or database with tickers and daily closing stock prices for every stock for the past however many years? I used Compustat back in college but was just curious about anything comparable given that Compustat is no longer accessible to me. Thanks for any help.
Yahoo Finance or Google Finance have the option. If you meant as in dl 30 stock comparisons at once, then no. You can get 1 by 1 though.
There are plenty of robust sources where you can pull the data from, but they aren't cheap. Bloomberg is what I use, but its far from the only source.
The free ones will be more limited in what they can do (like was said above; one at a time).
http://www.diytraders.com/content/view/25/43/ looks like it will get the job done.
Dolorem dolorem et exercitationem nisi. Deserunt aut soluta id qui. Voluptate doloremque qui maiores veniam repudiandae molestias.
Praesentium qui ea et qui saepe nostrum. Illo sit molestiae sed enim dolor reprehenderit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Voluptatem nihil aut labore ducimus iure quas. Dolor dolores vel et nulla explicabo. Consequatur dolore quidem reprehenderit tempora.
Hic vel officia vel nihil ab. In corrupti incidunt sit doloremque nihil corrupti quo. Perspiciatis maiores et provident.
Omnis est impedit maxime qui quis. Explicabo dicta quis autem fuga accusantium ut libero ipsam.