15 New Messages
Digest #2778
Messages
Thu Sep 19, 2013 6:04 am (PDT) . Posted by:
jpaucamp1
Hi John
A personal thanks from me for this as I used to use advfn for my
financial data source and started working on a whole new version
yesterday from morningstar to get around the advfn issue.
Just a question with regards to the URL for individual stocks.
How did you get the correct url for each ticker? I track 3800
companies some of which are on your list but at least 600 ain't.
Is there an easy way to get them?
Thanks for your help
Ohann
--- In smf_addin@yahoogrou
wrote:
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 6:14 am (PDT) . Posted by:
bushpilote
Nice!! Thanks.
Please note that ADVFN has mislabeled Row 237 in the Cash Flow
Page. They are showing Total Cash Flow From INVESTING Activities
instead of Total Cash Flow From FINANCING Activities.Until such
time that they correct it, you can get around it by entering the
following
formula"
B236,"<
copying it all the way across to V237..
I'm looking to create a similar ticker database for stocks
trading on Canada's TSX. Any suggestions of where I can find the
corresponding ticker's name that works in advfn? I could extract
them one by one from their but that's painfully slow. Searches on
Google and Bing lead nowhere.
--- In smf_addin@yahoogrou
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 7:04 am (PDT) . Posted by:
john_babcock_vc
To build the company database, I built a crude web crawler in
Excel using the VBA Web control. It goes down the list of
tickers, sends ADVFN the "-company"
dmatu2000 suggested. When ADVFN forwards to the correct URL that
includes company name, it parses that URL, extracts the company
name, adds it to the list and goes on to the next one. It takes
about 5 seconds per company.
At that pace, I didn't have time to scan all major market tickers
yesterday and I wanted to see if it was of some use to the group
before running them all. I'll do two things: 1) I'll post the
crawler to the "uploaded by members" section in case someone else
wants to improve it. It's super rough. 2) I'll just leave my
laptop to complete the crawls of NYSE, AMEX, and NASDAQ. That
might take a day or two.
--- In smf_addin@yahoogrou
wrote:
Hi John
A personal thanks from me for this as I used to use advfn for my
financial data source and started working on a whole new version
yesterday from morningstar to get around the advfn issue.
Just a question with regards to the URL for individual stocks.
How did you get the correct url for each ticker? I track 3800
companies some of which are on your list but at least 600 ain't.
Is there an easy way to get them?
Thanks for your help
Ohann
--- In smf_addin@yahoogrou
wrote:
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 7:22 am (PDT) . Posted by:
jpaucamp1
Thanks John! That would be awesome!
--- In smf_addin@yahoogrou
wrote:
To build the company database, I built a crude web crawler in
Excel using the VBA Web control. It goes down the list of
tickers, sends ADVFN the "-company"
dmatu2000 suggested. When ADVFN forwards to the correct URL that
includes company name, it parses that URL, extracts the company
name, adds it to the list and goes on to the next one. It takes
about 5 seconds per company.
At that pace, I didn't have time to scan all major market tickers
yesterday and I wanted to see if it was of some use to the group
before running them all. I'll do two things: 1) I'll post the
crawler to the "uploaded by members" section in case someone else
wants to improve it. It's super rough. 2) I'll just leave my
laptop to complete the crawls of NYSE, AMEX, and NASDAQ. That
might take a day or two.
--- In smf_addin@yahoogrou
wrote:
Hi John
A personal thanks from me for this as I used to use advfn for my
financial data source and started working on a whole new version
yesterday from morningstar to get around the advfn issue.
Just a question with regards to the URL for individual stocks.
How did you get the correct url for each ticker? I track 3800
companies some of which are on your list but at least 600 ain't.
Is there an easy way to get them?
Thanks for your help
Ohann
--- In smf_addin@yahoogrou
wrote:
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 1:16 pm (PDT) . Posted by:
john_babcock_vc
As promised, both the updated database and the web crawler are
posted in the "Upload by Members" area. The web crawler is
really crude, but it served it's purpose. The ADVFN sheet seems
to work fine.
--- In smf_addin@yahoogrou
wrote:
Thanks John! That would be awesome!
--- In smf_addin@yahoogrou
wrote:
To build the company database, I built a crude web crawler in
Excel using the VBA Web control. It goes down the list of
tickers, sends ADVFN the "-company"
dmatu2000 suggested. When ADVFN forwards to the correct URL that
includes company name, it parses that URL, extracts the company
name, adds it to the list and goes on to the next one. It takes
about 5 seconds per company.
At that pace, I didn't have time to scan all major market tickers
yesterday and I wanted to see if it was of some use to the group
before running them all. I'll do two things: 1) I'll post the
crawler to the "uploaded by members" section in case someone else
wants to improve it. It's super rough. 2) I'll just leave my
laptop to complete the crawls of NYSE, AMEX, and NASDAQ. That
might take a day or two.
--- In smf_addin@yahoogrou
wrote:
Hi John
A personal thanks from me for this as I used to use advfn for my
financial data source and started working on a whole new version
yesterday from morningstar to get around the advfn issue.
Just a question with regards to the URL for individual stocks.
How did you get the correct url for each ticker? I track 3800
companies some of which are on your list but at least 600 ain't.
Is there an easy way to get them?
Thanks for your help
Ohann
--- In smf_addin@yahoogrou
wrote:
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 9:29 pm (PDT) . Posted by:
jpaucamp1
Thanks again John!
--- In smf_addin@yahoogrou
As promised, both the updated database and the web crawler are
posted in the "Upload by Members" area. The web crawler is
really crude, but it served it's purpose. The ADVFN sheet seems
to work fine.
--- In smf_addin@yahoogrou
wrote:
Thanks John! That would be awesome!
--- In smf_addin@yahoogrou
wrote:
To build the company database, I built a crude web crawler in
Excel using the VBA Web control. It goes down the list of
tickers, sends ADVFN the "-company"
dmatu2000 suggested. When ADVFN forwards to the correct URL that
includes company name, it parses that URL, extracts the company
name, adds it to the list and goes on to the next one. It takes
about 5 seconds per company.
At that pace, I didn't have time to scan all major market tickers
yesterday and I wanted to see if it was of some use to the group
before running them all. I'll do two things: 1) I'll post the
crawler to the "uploaded by members" section in case someone else
wants to improve it. It's super rough. 2) I'll just leave my
laptop to complete the crawls of NYSE, AMEX, and NASDAQ. That
might take a day or two.
--- In smf_addin@yahoogrou
wrote:
Hi John
A personal thanks from me for this as I used to use advfn for my
financial data source and started working on a whole new version
yesterday from morningstar to get around the advfn issue.
Just a question with regards to the URL for individual stocks.
How did you get the correct url for each ticker? I track 3800
companies some of which are on your list but at least 600 ain't.
Is there an easy way to get them?
Thanks for your help
Ohann
--- In smf_addin@yahoogrou
wrote:
I was impressed with yweinstock&#
changed their structure again, making the URLs not work. I took
his spreadsheet and updated it to work with the ADVFN's new
structure. I left the URL in one cell so that if they change it
again, it will be easy to update. The resulting spr
dmatu2000'
help, but it doesn't work to pages with 10 years of financial
data. The site redirects you to the page with the company that
only shows 5 years of data. The only way that I could figure out
to work around that is to use a lookup table in Excel that lists
the ADVFN URL "company name" for each ticker symbol. So you
enter the ticker, the table populates the URL company name and
exchange, then sends the fully formed URL to ADVFN.com. I
populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum
Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to
retrieve anything prior to 2012 for the financial statements. And
I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version
access to a company'
name (the name they have in their database) and ticker along
with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.
er&"/full-
Meaning the company name is not required as long as there is a
placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
trying to get it to work but still having issues.
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Thu Sep 19, 2013 6:09 am (PDT) . Posted by:
"DefelRadar" DefelRadar
I agree with Randy that fulldisclosure.com looks like it is gone for good. This is a pity b/c I cannot find any site that comes close to having the quarterly earnings info/history that the site did. Thank Reuters for screwing a good thing up. More than likely they did it so it was no longer free and could charge for the data.
has anyone found a suitable alternative for earnings/fulldisclosure.com? I'd want at least 2 years of quarterly earnings history. Closest thing I've found is yahoo.
--- In smf_addin@yahoogroups.com, "bs2167" <bs2167@...> wrote:
>
> Hello,
>
> As of this morning, I haven't been able to access the fulldisclosure.com website. I wanted to 1) check that I'm not the only having problems and 2) see if anyone has found an alternate web address that works (similar to last time when earnings.com became fulldisclosure.com).
>
> Appreciate any input. Thanks
>
has anyone found a suitable alternative for earnings/fulldisclo
--- In smf_addin@yahoogrou
>
> Hello,
>
> As of this morning, I haven't been able to access the fulldisclosure.
>
> Appreciate any input. Thanks
>
Thu Sep 19, 2013 7:57 am (PDT) . Posted by:
gbullr
I propose Randy kills this website as a datasource. It appears to
be 3/4s of the questions and he has no way of controlling how
they serve data so if anyone wants to do Randy any favors....
Just a thought
be 3/4s of the questions and he has no way of controlling how
they serve data so if anyone wants to do Randy any favors....
Just a thought
Thu Sep 19, 2013 8:13 am (PDT) . Posted by:
john_babcock_vc
Is there a more reliable place to get 10 years of financial
statements than ADVFN? I'd love to drop it, but I thought it was
the only game in town.
--- In smf_addin@yahoogrou
I propose Randy kills this website as a datasource. It appears to
be 3/4s of the questions and he has no way of controlling how
they serve data so if anyone wants to do Randy any favors....
Just a thought
Thu Sep 19, 2013 8:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
MorningStar and GuruFocus both have 10 years of data.
On Thu, Sep 19, 2013 at 8:13 AM, <john@rusticcanyon.com> wrote:
> Is there a more reliable place to get 10 years of financial statements
> than ADVFN? I'd love to drop it, but I thought it was the only game in town.
>
On Thu, Sep 19, 2013 at 8:13 AM, <john@rusticcanyon.
> Is there a more reliable place to get 10 years of financial statements
> than ADVFN? I'd love to drop it, but I thought it was the only game in town.
>
Thu Sep 19, 2013 10:37 am (PDT) . Posted by:
"Christopher" jcredline
Thanks for the response. I was thinking the result would be the absolute high value in the High Price column between the selected dates. Thansk again for your time.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not seeing the problem.
>
> On 12/07/2011 -- Adjusted high price = $25.78 * $24.07 / $25.66 = $24.1826
>
> On 08/18/2011 -- Adjusted low price = $19.16 * $17.84 / $19.19 = $17.8121
> On 04/04/2011 -- Adjusted low price = $19.36 * $17.81 / $19.49 = $17.6912
>
> On Wed, Sep 18, 2013 at 9:17 PM, Christopher <miller@...> wrote:
>
> >
> > I was trying to get the annual high and low prices for a ticker.
> > INTC 2011 for example.
> >
> > High Formula
> > =smfpricesbetween("INTC",DATE(2011,1,1),DATE(2011,12,31),"04") = $24.1826
> > Low Formula
> > =smfpricesbetween("INTC",DATE(2011,1,1),DATE(2011,12,31),"06") = $17.6912
> >
> > When I pull the historical prices from the Yahoo finance pages to compare
> > - INTC, daily for 2011, I can't find a match for my results.
> > This is what I find for the annual Highs and Lows.
> >
> > High Values
> > 12/07/2011 - High $25.78, Close $25.66, Adjusted Close $24.07
> > Low Values
> > 08/19/2011 - Low $19.16, Close $19.19
> > 04/04/2011 - Adjusted Close $17.81
> >
> > Sorry to bother you, but I looked everywhere and I just can't figure out
> > what the smfpricesbetween results compare to.
> >
>
--- In smf_addin@yahoogrou
>
> I'm not seeing the problem.
>
> On 12/07/2011 -- Adjusted high price = $25.78 * $24.07 / $25.66 = $24.1826
>
> On 08/18/2011 -- Adjusted low price = $19.16 * $17.84 / $19.19 = $17.8121
> On 04/04/2011 -- Adjusted low price = $19.36 * $17.81 / $19.49 = $17.6912
>
> On Wed, Sep 18, 2013 at 9:17 PM, Christopher <miller@.
>
> >
> > I was trying to get the annual high and low prices for a ticker.
> > INTC 2011 for example.
> >
> > High Formula
> > =smfpricesbetween(
> > Low Formula
> > =smfpricesbetween(
> >
> > When I pull the historical prices from the Yahoo finance pages to compare
> > - INTC, daily for 2011, I can't find a match for my results.
> > This is what I find for the annual Highs and Lows.
> >
> > High Values
> > 12/07/2011 - High $25.78, Close $25.66, Adjusted Close $24.07
> > Low Values
> > 08/19/2011 - Low $19.16, Close $19.19
> > 04/04/2011 - Adjusted Close $17.81
> >
> > Sorry to bother you, but I looked everywhere and I just can't figure out
> > what the smfpricesbetween results compare to.
> >
>
Thu Sep 19, 2013 12:17 pm (PDT) . Posted by:
michalemory
That's worked. I appreciate it!
Thu Sep 19, 2013 6:27 pm (PDT) . Posted by:
gbullr
Is it possible to use the addin to get the data from:
http://www.gurufocus.com/financials/CNQR
<http://www.gurufocus.com/financials/CNQR>
http://www.gurufocu
<http://www.gurufocu
Thu Sep 19, 2013 7:06 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Yes, there have been several emails regarding gurufocus the last 3 weeks and there is a gurufocus spreadsheet in the Files section.
Works great, although the gurufocus website is slow, so it's a bit slow in the spreadsheet.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of gaston.bullrich@gmail.com
Sent: Thursday, September 19, 2013 9:28 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] GuruFocus
Is it possible to use the addin to get the data from:
http://www.gurufocus.com/financials/CNQR
Works great, although the gurufocus website is slow, so it's a bit slow in the spreadsheet.
Jim
From: smf_addin@yahoogrou
Sent: Thursday, September 19, 2013 9:28 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] GuruFocus
Is it possible to use the addin to get the data from:
http://www.gurufocu
Thu Sep 19, 2013 8:17 pm (PDT) . Posted by:
mlawson3
The "Upload by Members" section now has my attempt at working
with ADVFN's new website and data. It has data for the trailing
12 quarters as well as the last 10 years. It shouldn't be too
hard to adjust if you want more or less quarterly or annual data.
Teasing the exchange and the company name ADVFN uses in the URL
from the smfGetWebPage function took an obnoxious amount of text
parsing. In the end, I had to set up an exceptions table for
when the parsing just didn't provide the correct company name.
Its not elegant, but its not overly burdensome, either. On the
other hand, every single bit of data is pulled using the
RCHGetTableCell function, so any recalculations take a bit to
complete. Those with older computers beware??
with ADVFN's new website and data. It has data for the trailing
12 quarters as well as the last 10 years. It shouldn'
hard to adjust if you want more or less quarterly or annual data.
Teasing the exchange and the company name ADVFN uses in the URL
from the smfGetWebPage function took an obnoxious amount of text
parsing. In the end, I had to set up an exceptions table for
when the parsing just didn't provide the correct company name.
Its not elegant, but its not overly burdensome, either. On the
other hand, every single bit of data is pulled using the
RCHGetTableCell function, so any recalculations take a bit to
complete. Those with older computers beware??
Tidak ada komentar:
Posting Komentar