8 Messages
Digest #4599
Messages
Tue Aug 13, 2019 9:47 am (PDT) . Posted by:
obanduzzy
Hey Randy,
Apparently, that is now all behind a subscription.
just got off a chat with somebody at advfn.
is there anybody else still pumping out those numbers for free?
10 years of sales, roe, roi, fcf, eps and so on?
I saw the template for GuruFocus, it looks quite complete but a bit on the spendy side. LOL
Apparently, that is now all behind a subscription.
just got off a chat with somebody at advfn.
is there anybody else still pumping out those numbers for free?
10 years of sales, roe, roi, fcf, eps and so on?
I saw the template for GuruFocus, it looks quite complete but a bit on the spendy side. LOL
Tue Aug 13, 2019 11:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Morningstar recently made theirs harder to get at as well, even for
subscribers.
I'm not aware of any free sources of 10 years of annual statements data,
but I haven't looked at Edgar lately because I don't do much with financial
statements data, and when I do, I either use my subscription with GuruFocus
or Portfolio123.
NASDAQ might, but they get very testy about automated access. So anyone
using it a lot could get their access cut off.
*After some searching...*
------------------------------
Hmm. This site appears to have 14 years of annual and quarterly data
available:
https://www.macrotrends.net/stocks/charts/MMM/3m/income-statement
However, the data is in script format, so the data would need to be
extracted from there. For example, the 14 years of revenues:
{"field_name":"<a
href='\/stocks\/charts\/MMM\/3m\/revenue'>Revenue<\/a>","popup_icon":"<div
class='ajax-chart' data-tipped-options=\"ajax: {data: { t: 'MMM', s:
'revenue', freq: 'A', statement: 'income-statement' }}\"><i
style='font-size:18px; color:#337ab7;' class='fas
fa-chart-bar'><\/i><\/span><\/div>","2018-12-31":"32765.00000","2017-12-31":"31657.00000","2016-12-31":"30109.00000","2015-12-31":"30274.00000","2014-12-31":"31821.00000","2013-12-31":"30871.00000","2012-12-31":"29904.00000","2011-12-31":"29611.00000","2010-12-31":"26662.00000","2009-12-31":"23123.00000","2008-12-31":"25269.00000","2007-12-31":"24462.00000","2006-12-31":"22923.00000","2005-12-31":"21167.00000"}
------------------------------
This site appears to do it similarly to AdvFn, showing a window of only a
few years at a time:
https://csimarket.com/stocks/income.php?code=MMM&annual
------------------------------
There was a discussion about using stockrow.com data:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/35521
....which offered either JSON or an XLSX file.
------------------------------
On Tue, Aug 13, 2019 at 9:47 AM obanduzzy@... wrote:
>
> Apparently, that is now all behind a subscription.
>
> just got off a chat with somebody at advfn.
>
> is there anybody else still pumping out those numbers for free?
>
> 10 years of sales, roe, roi, fcf, eps and so on?
>
> I saw the template for GuruFocus, it looks quite complete but a bit on the
> spendy side. LOL
>
>
>
subscribers.
I'm not aware of any free sources of 10 years of annual statements data,
but I haven't looked at Edgar lately because I don't do much with financial
statements data, and when I do, I either use my subscription with GuruFocus
or Portfolio123.
NASDAQ might, but they get very testy about automated access. So anyone
using it a lot could get their access cut off.
*After some searching...*
------------------------------
Hmm. This site appears to have 14 years of annual and quarterly data
available:
https://www.macrotrends.net/stocks/charts/MMM/3m/income-statement
However, the data is in script format, so the data would need to be
extracted from there. For example, the 14 years of revenues:
{"field_name":"<a
href='\/stocks\/charts\/MMM\/3m\/revenue'>Revenue<\/a>","popup_icon":"<div
class='ajax-chart' data-tipped-options=\"ajax: {data: { t: 'MMM', s:
'revenue', freq: 'A', statement: 'income-statement' }}\"><i
style='font-size:18px; color:#337ab7;' class='fas
fa-chart-bar'><\/i><\/span><\/div>","2018-12-31":"32765.00000","2017-12-31":"31657.00000","2016-12-31":"30109.00000","2015-12-31":"30274.00000","2014-12-31":"31821.00000","2013-12-31":"30871.00000","2012-12-31":"29904.00000","2011-12-31":"29611.00000","2010-12-31":"26662.00000","2009-12-31":"23123.00000","2008-12-31":"25269.00000","2007-12-31":"24462.00000","2006-12-31":"22923.00000","2005-12-31":"21167.00000"}
------------------------------
This site appears to do it similarly to AdvFn, showing a window of only a
few years at a time:
https://csimarket.com/stocks/income.php?code=MMM&annual
------------------------------
There was a discussion about using stockrow.com data:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/35521
....which offered either JSON or an XLSX file.
------------
On Tue, Aug 13, 2019 at 9:47 AM obanduzzy@..
>
> Apparently, that is now all behind a subscription.
>
> just got off a chat with somebody at advfn.
>
> is there anybody else still pumping out those numbers for free?
>
> 10 years of sales, roe, roi, fcf, eps and so on?
>
> I saw the template for GuruFocus, it looks quite complete but a bit on the
> spendy side. LOL
>
>
>
Tue Aug 13, 2019 11:40 am (PDT) . Posted by:
forse85
One idea. I found out my local library has an online subscription to Morningstar. Saved me some money.
Tue Aug 13, 2019 8:56 am (PDT) . Posted by:
obanduzzy
The nerve of them completely screwing up my stock analysis.
Tue Aug 13, 2019 11:34 am (PDT) . Posted by:
codyklein
Can't open with alt d+d+w. I remember a link posted a while back to open it with newer versions of excel but I can't find it. Randy, I think you posted it, do you remember what it was?
Tue Aug 13, 2019 12:12 pm (PDT) . Posted by:
codyklein
Never mind, the alt ddw worked, not sure what I was thinking of.
Tue Aug 13, 2019 12:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I added an icon to my quick access toolbar for it. They call it the "From
Web (Legacy)" option...
On Tue, Aug 13, 2019 at 11:34 AM codyklein@... wrote:
> Can't open with alt d+d+w. I remember a link posted a while back to open
> it with newer versions of excel but I can't find it. Randy, I think you
> posted it, do you remember what it was?
>
>
Web (Legacy)" option...
On Tue, Aug 13, 2019 at 11:34 AM codyklein@..
> Can't open with alt d+d+w. I remember a link posted a while back to open
> it with newer versions of excel but I can't find it. Randy, I think you
> posted it, do you remember what it was?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar