Stock Financials Data Batch Download

Enter stock symbols to download the financial data into one Excel file. There will be a worksheet for every company.

You can also add stocks from the financial page of stocks. You can download up to 5 stocks at a time.

This feature is for Premium Members only.


Please be patient and wait for the file generated after clicking "Download" button.

Change log: Jan 28, 2016: Add 'Total Debt per share' below 'Tangible Book per share'. Jan 20, 2016: Add 'Price-to-Operating-Cash-Flow ratio' below 'Price-to-Free-Cash-Flow ratio'. Jan 18, 2016: Add 'Net-Net Working Capital (per share)' below 'Net Current Asset Value (per share)'. Oct 19, 2015: Add 'Beta' above 'Filing Date'. Oct 16, 2015: Add 'Net Interest Income' below 'Interest Expense' for non-financial companies. Make 'Interest Expense' and 'Interest Income' as the sub-item of 'Net Interest Income'. Oct 6, 2015: Add 'Current Deferred Taxes Liabilities' and 'Current Deferred Revenue' above 'DeferredTaxAndRevenue' as the components of 'DeferredTaxAndRevenue'. Oct 5, 2015: Add 'Investments And Advances' below 'Total Current Assets'. Sep 9, 2015: Add 'Filing Date' below 'Shares Outstanding (EOP)'. Aug. 17, 2015: Add 'Weighted Average Cost of Capital (WACC) %' below 'Return on Invested Capital %'. Move 'Return on Capital - Joel Greenblatt %' above 'Return on Invested Capital %'. Jun. 19, 2015: Add 'Minority Interest' above 'Other Long-Term Liabilities'. Change 'Capital Lease Obligation' to be a sub-item of 'Long-Term Debt'. Add 'Other Liabilities' above 'Total Liabilities' for insurane companies. Add 'Other Assets' above 'Total Assets' for insurane companies. Add 'Accounts Payable & Accrued Expense', 'DeferredTaxAndRevenue', 'NonCurrent Deferred Liabilities', and 'Minority Interest' for insurance companies. Add 'Minority Interest' above 'Other Liabilities' for banks. Jun. 19, 2015: Add 'Cash From Other Investing Activities' above 'Cash Flow from Investing'. Jun. 18, 2015: Add 'Price to Book Value' above 'Price to Tangible Book'. Apr. 7, 2015: Add 'Other Income (Minority Interest)' under 'Other Income (Expense)' as a sub-item. Mar. 24, 2015: Add 'Goodwill' under 'Intangible Assets' as a sub-item. Jan. 28, 2015: Add 'PEG Ratio' under 'PS Ratio', add 'EBITDA 5-Y Growth (%)' under 'YoY EBITDA Growth (%)'. Jan. 16, 2015: Add 'Return on Invested Capital %' under 'Return on Assets %'. Jan. 9, 2015: For cash flow statements, add 'Stock Based Compensation' under 'Change In DeferredTax'. Dec. 24, 2014: For income statement of banks, changed name from 'Other Expense' to 'Other Noninterest Expense'. Moved 'Credit Losses Provision' below 'Revenue'. Dec. 19, 2014: Changed Income Statement format by moving 'EBITDA' and 'DDA' under 'Shares Outstanding (Diluted)'. For insurance companies, added 'Interest Expense' and 'Other Expense', as well as deleted 'Advertising' and 'Research &Development'. Dec. 18, 2014: Changed Income Statement format by moving 'EBITDA' and 'DDA' under 'Shares Outstanding (Diluted)'. For banks, moved 'SpecialCharges' under 'SGA' as a subset of 'SGA', as well as deleted 'Advertising' and 'Research &Development'. Dec. 1, 2014: Change 'Forex Rate' by using 12-01 monthly data as the Dec data. Nov. 19, 2014: Added 'Earning Power Value (per share)' below 'Graham Number (per share)'. Nov. 6, 2014: Added 'Cash Conversion Cycle' below 'Days Inventory'. Nov. 3, 2014: Added 'Days Accounts Payable' below 'Days Sales Outstanding'. Oct. 27, 2014: Added 'Shares Outstanding' below 'Shares Outstanding (Basic)'. Oct. 27, 2014: Moved 'Shares Outstanding (Basic)' below 'YoY EBITDA Growth (%)'. Oct. 16, 2014: Added 'Capital Expenditure' below 'Net Change in Cash'. Oct. 9, 2014: Added 'eps without NRI' below 'Earnings per Share (diluted)'. Oct. 9, 2014: Added 'Tangible Book per share' below 'Book Value Per Share'. Oct. 9, 2014: Added 'Sloan Ratio' below 'Beneish M-Score'. Sept. 26, 2014: Added 'DeferredTaxAndRevenue' above 'Other Current Liabilities', and remove its portion from 'Other Current Liabilities' during calculation. Sept. 26, 2014: Changed name of the field from 'DeferredTaxAndRevenue' to 'NonCurrent Deferred Liabilities'. Sept. 24, 2014: Income Statement added 'Tax Rate %' below 'Tax Provision'. Sept. 24, 2014: Balance Sheet: Added 'Debt to Equity' below 'Long Term Debt', and 'Total Equity to Total Asset' below 'Total Equity'. Sept. 24, 2014: Income Statement added 'Gross Margin %' below 'Gross Profit', 'Operating Margin %' below 'Operating Income', 'Net Margin %' below 'Net Income'. Sept. 24, 2014: Cash Flow Statement: 'Net Issuance of Stock' is seperated into two rows: 'Issuance of Stock', and 'Repurchase of Stock'. Feb. 10, 2014: added row 54 - Other operating charges, and row 106-Accumulated other comprehensive income (loss)

Add Notes, Comments

If you want to ask a question or report a bug, please create a support ticket.

User Comments

BayKnights
ReplyBayKnights - 1 week ago
No financials for DLTR, Dollar Tree
Rmaciver1
ReplyRmaciver1 - 2 weeks ago
No financials for TETAA, Teton Advisors
Gurufocus
ReplyGurufocus - 1 month ago
[email protected],
GuruFocus Excel Add-In can implement your purpose. Please check it. Thanks.
Mooninja01@google
ReplyMooninja01@google - 2 months ago
Thanks
Qwas
ReplyQwas - 2 months ago
Pay and thou shalt receive
Mufalo
ReplyMufalo - 2 months ago
I need help downloading wacc analysis for Vodafone for the past three years
2012,2013 and 2014
Boomsmile@facebook
ReplyBoomsmile@facebook - 3 months ago
thank you .
[email protected]
Mario888
ReplyMario888 - 4 months ago
hello, does gurufocus have 20 year data that can screen Free Cash Flow?
I want to check Quarter on Quarter, Year on Year stock performance.
reply to : [email protected]
TQ
Mariio
Aronbara664@facebook
ReplyAronbara664@facebook - 4 months ago
would be great... if it worked. srsly, wtf?
Natilda
ReplyNatilda - 4 months ago
I can't download the file
Claudio.pascual@google
ReplyClaudio.pascual@google - 4 months ago
It does not work!
Namia_98
ReplyNamia_98 - 4 months ago
Cannot download the file, can anyone help please ??
Tomsherwood99
ReplyTomsherwood99 - 4 months ago
Gurufocus,
I disagree. You should put the data in the same place for all companies. You're just making it more painful to automate use of the data.
Nanthanhu@yahoo
ReplyNanthanhu@yahoo - 5 months ago
谢谢。
Raysuiaiy@facebook
ReplyRaysuiaiy@facebook - 5 months ago
Thanks
Yanicin23@google
ReplyYanicin23@google - 5 months ago
quisiera tener eeff de microsot por favor
Shiep_01@facebook
ReplyShiep_01@facebook - 5 months ago
thanks
Yair.eyal@google
ReplyYair.eyal@google - 6 months ago
FileToStar
Gurufocus
ReplyGurufocus - 6 months ago
financial data has three templates. Banks, Insurance, and others. They are better this way.

Thanks!
Tomsherwood99
ReplyTomsherwood99 - 6 months ago
One thing that would really help would be having all companies' data use the same template. As it is now, certain data points I use don't always show up on the same rows. My system of using the indirect formula to pull the data I need would work perfectly if the data wasn't moving around. Just leave rows blank if the company in question doesn't have anything available.
Addis Wong
ReplyAddis Wong - 6 months ago
AAPL
Satiyeh2005
ReplySatiyeh2005 - 6 months ago
AAGC,AAIR,AAMC,AAME,AAN
Mcolympic
ReplyMcolympic - 6 months ago
thanks
Ahmadhourani
ReplyAhmadhourani - 6 months ago
n
Qniform
ReplyQniform - 7 months ago
Good bye
Rpanton
ReplyRpanton - 7 months ago
Any chance you could offer the previous version of 15 years of data so I don't need to rerwrite all of my spreadsheets?
Jae Jun
ReplyJae Jun - 7 months ago
Please add back the export CSV feature as before!
Rrobinson10
ReplyRrobinson10 - 7 months ago
WHAT HAPPENED TO SYM.CSV OPTION!
Balou63
ReplyBalou63 - 7 months ago
it seems as if the 10 years data of several stocks is from 1995 to 2004 while 15 years batch downloads are correct.
Aliraza
ReplyAliraza - 7 months ago
sax
Marco.loca
ReplyMarco.loca - 8 months ago
very good
Hanrui890721@google
ReplyHanrui890721@google - 8 months ago
1111111111111111111111
Lifeidb
ReplyLifeidb - 8 months ago
lafoadfhsdf
Statman
ReplyStatman - 8 months ago
cde ckh
T2vinh.12a3@google
ReplyT2vinh.12a3@google - 9 months ago
Thanks :)
Shenguru
ReplyShenguru - 9 months ago
ABAX,MNST,FISV,TPL,LABL
Shenguru
ReplyShenguru - 9 months ago
HCSG,MIDD,GPN,IDXX,NEOG
Oqulent
ReplyOqulent - 9 months ago
IBM, BABA, TWTR, TSLA, TSLA
Haagen
ReplyHaagen - 9 months ago
Fuck let me download
Marko80m
ReplyMarko80m - 9 months ago
Is it possible to download if I am free trail user?
Ct6691
ReplyCt6691 - 9 months ago
It's a food valuable
Jeffhua713814@facebook
ReplyJeffhua713814@facebook - 9 months ago
it is a valuable resource!
Jeffhua713814@facebook
ReplyJeffhua713814@facebook - 9 months ago
thanks
Arivp
ReplyArivp - 9 months ago
como puedo descargar documento ?
Guozhen0908@google
ReplyGuozhen0908@google - 9 months ago
Thanks
123456
Reply123456 - 9 months ago
~~~
Hu.guess@yahoo
ReplyHu.guess@yahoo - 10 months ago
Gotta love teases. Definitely broken
Yxia
ReplyYxia - 11 months ago
unt
Yxia
ReplyYxia - 11 months ago
unt
Qiy721@facebook
ReplyQiy721@facebook - 11 months ago
Nothing happened!
King818
ReplyKing818 - 11 months ago
After clicking on the "Download" button, I have waited for a very long time and nothing happened.
Kamitsu_me@facebook
ReplyKamitsu_me@facebook - 11 months ago
thanks
Mohammadrezabiria@google
ReplyMohammadrezabiria@google - 11 months ago
:(Asdasdas
Rpanton
ReplyRpanton - 11 months ago
for some reason my list of download requests keeps getting longer even though I've restarted the browser ... cannot forget previous requests. Using Chrome browser ... suggestions?
Skaldex@google
ReplySkaldex@google - 1 year ago
great!
Paul_ufo@facebook
ReplyPaul_ufo@facebook - 1 year ago
kk
Khotekhoto@gmail.com
Reply[email protected] - 1 year ago
I am clicking on the 15year financials for starbucks and then when I click download, nothing happens.
[email protected]
Yangshwe@google
ReplyYangshwe@google - 1 year ago
Useful info!!
Afrimi52@google
ReplyAfrimi52@google - 1 year ago
great!
Hikumarpal
ReplyHikumarpal - 1 year ago
ok
Paulo.zunguze
ReplyPaulo.zunguze - 1 year ago
thanks
Akiraluck
ReplyAkiraluck - 1 year ago
USEFUL
Syedasadraza@facebook
ReplySyedasadraza@facebook - 1 year ago
OTCPK:SFCJF, OTCPK:SFCJF, OTCPK:SFCJF, OTCPK:SFCJF, OTCPK:SFCJF, OTCPK:SFCJF
Zarra1292@google
ReplyZarra1292@google - 1 year ago
useful
Saumilshah
ReplySaumilshah - 1 year ago
Usefuk
Ayisha china
ReplyAyisha china - 1 year ago
useful
Intan
ReplyIntan - 1 year ago
pleaseeee
Duyennui
ReplyDuyennui - 1 year ago
fgdthg
Linh
ReplyLinh - 1 year ago
Tks, it's informative with me
SorinTeo
ReplySorinTeo - 1 year ago
I press "Download button and .. nothing. Why?
SorinTeo
ReplySorinTeo - 1 year ago
Why download does not work?
Blue-pen
ReplyBlue-pen - 1 year ago
thx
Itsikalbert
ReplyItsikalbert - 1 year ago
Does anyone know the maximum number of different symbols you can pull at one time?
Lijiaxiang1007@google
ReplyLijiaxiang1007@google - 1 year ago
useful
CS_Schramm
ReplyCS_Schramm - 1 year ago
AMNF has Financial Data only up to year 2010.
If you check this tickker in other sources as YAHOO, Financial Times www.ft.com or AAII StockInvestorPro you see that they all show financial data up to 2014.
With gurufocus there are dividend payments shown up to oct 2014.
Moeningstar also shows financial data up to 2010
Probably there is an error in the Morningstar data.
Promotion175
ReplyPromotion175 - 1 year ago
why download is not working?
Joshuaelijay@google
ReplyJoshuaelijay@google - 1 year ago
why i cant download
Sherlockhty2007@facebook
ReplySherlockhty2007@facebook - 1 year ago
thanks
Yuwenjinjin@google
ReplyYuwenjinjin@google - 1 year ago
good
Junaid Ashraf
ReplyJunaid Ashraf - 1 year ago
how it will be download plz tell me.
Fm11d019@google
ReplyFm11d019@google - 1 year ago
thankyou for sharing
Bungbung
ReplyBungbung - 1 year ago
thk
Zhd-lyc@google
ReplyZhd-lyc@google - 1 year ago
could we see the value reio
Ryi
ReplyRyi - 1 year ago
BABA
Jacinthe
ReplyJacinthe - 1 year ago
Why the high and low of the stock price each year does not appear anymore?
Thank you
Angie_gys@facebook
ReplyAngie_gys@facebook - 1 year ago
kk
Ichigo8
ReplyIchigo8 - 1 year ago
ok
Mrshankar
ReplyMrshankar - 1 year ago
gg
Carry9572
ReplyCarry9572 - 1 year ago
chl
Haywar
ReplyHaywar - 1 year ago
00100
Eykamran
ReplyEykamran - 1 year ago
good
Nelsonlemieux
ReplyNelsonlemieux - 1 year ago
Did anyone ever determine maximum? I'd like to pull down financial data for a sizeable portfolio. All responses are greatly appreciated
Bentam64
ReplyBentam64 - 1 year ago
Does anyone know the maximum number of different symbols you can pull at one time?
Financewilliamlee
ReplyFinancewilliamlee - 2 years ago
Thank you for sharing,.
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)

GuruFocus Premium Plus Membership

FEEDBACK