5 New Messages
Digest #2783
Messages
Mon Sep 23, 2013 3:29 am (PDT) . Posted by:
"PC_BABE" cs.holdings
Ditto. Web page is down
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of kkkutty@yahoo.com
Sent: Monday, September 23, 2013 1:51 AM
To: smf_addin@yahoogroups.com
Subject: RE: Re: [smf_addin] New ADVFN 10-yr spreadsheet not Updating
Even after resolving the links, I'm unable to recalculate with new ticker symbols. Part of the problem may be that the following URL doesn't seem to be working (of course, I replaced "Exchange"; and "Ticker" with actual names when testing):
http://www.advfn.com/exchanges/ <http://www.advfn.com/exchanges/%22&Exchange&%22/%22&Ticker&%22/financials?btn=annual_reports&mode=company_data&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1> "&Exchange&"/"&Ticker&"/financials?btn=annual_reports&mode=company_data&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1
Has anyone else had similar issues? Did ADVFN change their URL again? Thanks.
--- In smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> , <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
If you saw a location in front of the function, adding the add-in to that location doesn't help. You have to resolve the link errors before it can do the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo group. Or try just running the smfFixLinks macro that is part of the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@... <mailto:dcharlotte99@...> > wrote:
First, my thanks to John Babcock for the new ADVFN 10-yr financial spreadsheet that works with the changes to the ADVFN website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter a new ticker.
F9 changes the company and exchange info cells as well as the URL cells John includes. But all the data is $0.00. There are no error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I created that. I've had the add-in installed at C:/Program Files/SMF Add-in for several years. I made sure the Add-in is active in the Excel Options.
Any clues why the data doesn't update?
From: smf_addin@yahoogrou
Sent: Monday, September 23, 2013 1:51 AM
To: smf_addin@yahoogrou
Subject: RE: Re: [smf_addin] New ADVFN 10-yr spreadsheet not Updating
Even after resolving the links, I'm unable to recalculate with new ticker symbols. Part of the problem may be that the following URL doesn't seem to be working (of course, I replaced "Exchange"
http://www.advfn.
Has anyone else had similar issues? Did ADVFN change their URL again? Thanks.
--- In smf_addin@yahoogrou
If you saw a location in front of the function, adding the add-in to that location doesn't help. You have to resolve the link errors before it can do the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo group. Or try just running the smfFixLinks macro that is part of the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@
First, my thanks to John Babcock for the new ADVFN 10-yr financial spreadsheet that works with the changes to the ADVFN website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter a new ticker.
F9 changes the company and exchange info cells as well as the URL cells John includes. But all the data is $0.00. There are no error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I created that. I've had the add-in installed at C:/Program Files/SMF Add-in for several years. I made sure the Add-in is active in the Excel Options.
Any clues why the data doesn't update?
Mon Sep 23, 2013 6:22 am (PDT) . Posted by:
bushpilote
Thanks John.
--- In smf_addin@yahoogrou
john_babcock_
<http://us-mg6.
0ADVFN%20-%20New%
Thank you for uploading the updated file ADVFN - 10 year data -
workaround.xlsx. It is very helpful. One small thing - should you
remove older version?
J.C.H.
--- In smf_addin@yahoogrou
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.
Mon Sep 23, 2013 12:10 pm (PDT) . Posted by:
dmatu2000
Amazing work. Thank you as well.
--- In smf_addin@yahoogrou
Thanks John.
--- In smf_addin@yahoogrou
john_babcock_
<http://us-mg6.
0ADVFN%20-%20New%
Thank you for uploading the updated file ADVFN - 10 year data -
workaround.xlsx. It is very helpful. One small thing - should you
remove older version?
J.C.H.
--- In smf_addin@yahoogrou
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.
Mon Sep 23, 2013 12:44 pm (PDT) . Posted by:
managerisk77
Thank you
--- In smf_addin@yahoogrou
The FinViz screener does allow sorting, but I don't see an
"unsorted, leave as is" option.
If you want to sort and filter, you'll have to convert the array
to values. You could have VBA do that, or do it manually. You
could even have a little macro that would fill the data onto the
page AS values. For example, just one statement:
Range("
smfGetCSVFile(
2,3,4 <http://finviz.
", pDim1:=3, pDim2:=4)
The two pDim variables tell the smfGetCSVFile(
rows and columns to return.
On Wed, Sep 18, 2013 at 9:45 AM, <cmeehan777@
<mailto:cmeehan7
Hello, I'm new to the group and started using the
=smfGetCSVFile(
c=,[#],
<http://finviz.
function to import data. Two questions regarding this: Can I
turn off the alphabetical sorting when these are imported? I
would like the order I type the symbols in to be the same as the
order they are displayed. Is this possible, and if so how?
Second, is there a way to be able to import the data and apply a
"sort & filter" function without copying the data to a new page
to get rid of the "array" which can not be edited.
Mon Sep 23, 2013 8:41 pm (PDT) . Posted by:
kbnorway
Thank you for sharing this model with us, much appreciated.
--- In smf_addin@yahoogrou
Oops!! My fault. I only saw a few years of data for ticker FB
(FaceBook) because there ARE only a few years of data. When I
substituted another ticker, XOM (ExxonMobil) and hit F9, all 10
years of data appeared.
Thanks for such a useful spreadsheet!
Toby
Tidak ada komentar:
Posting Komentar