15 New Messages
Digest #2761
Messages
Fri Sep 6, 2013 2:47 am (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Hi Randy
I managed to get the data to appear in Excel. However, when I tried to retrieve the EPS for http://www.4-traders.com/SINGAPORE-TELECOMMUNICATI-6491140/financials/
it returns 240 rather than 24,0 (as appeared on the web page). Is there a way to correct this?
regards
LL
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Do a search on the message archives and you should find a discussion on
> it...
>
> On Wed, Aug 28, 2013 at 1:29 AM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> >
> > Could you pls help me with the RCHGetTable formula for EPS for this
> > company for 2011?
> >
> > http://www.4-traders.com/SINGAPORE-AIRLINES-LTD-6491138/financials/
> >
>
I managed to get the data to appear in Excel. However, when I tried to retrieve the EPS for http://www.4-
it returns 240 rather than 24,0 (as appeared on the web page). Is there a way to correct this?
regards
LL
--- In smf_addin@yahoogrou
>
> Do a search on the message archives and you should find a discussion on
> it...
>
> On Wed, Aug 28, 2013 at 1:29 AM, lawrence.leesh <lawrence.
>
> >
> > Could you pls help me with the RCHGetTable formula for EPS for this
> > company for 2011?
> >
> > http://www.4-
> >
>
Fri Sep 6, 2013 3:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can use the smfGetTagContent() function instead. It won't do any
conversion of data.
On Fri, Sep 6, 2013 at 2:47 AM, lawrence.leesh <lawrence.leesh@yahoo.com>wrote:
>
> I managed to get the data to appear in Excel. However, when I tried to
> retrieve the EPS for
> http://www.4-traders.com/SINGAPORE-TELECOMMUNICATI-6491140/financials/
> it returns 240 rather than 24,0 (as appeared on the web page). Is there a
> way to correct this?
>
conversion of data.
On Fri, Sep 6, 2013 at 2:47 AM, lawrence.leesh <lawrence.leesh@
>
> I managed to get the data to appear in Excel. However, when I tried to
> retrieve the EPS for
> http://www.4-
> it returns 240 rather than 24,0 (as appeared on the web page). Is there a
> way to correct this?
>
Fri Sep 6, 2013 6:26 am (PDT) . Posted by:
rr76012
Hello Randy,
could you recommend a file for etfs. I am looking at 1,3,5 year
returns, std dev, expenses, yield etc...
Thanks,
Have a great day.
could you recommend a file for etfs. I am looking at 1,3,5 year
returns, std dev, expenses, yield etc...
Thanks,
Have a great day.
Fri Sep 6, 2013 8:13 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
AAII just published their 2013 EFT/ETN guide. If you are a member you can download the PDF or an excel file.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of rr76012@yahoo.com
Sent: Friday, September 06, 2013 9:27 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] ETF stats
Hello Randy,
could you recommend a file for etfs. I am looking at 1,3,5 year returns, std dev, expenses, yield etc...
Thanks,
Have a great day.
Kermit
From: smf_addin@yahoogrou
Sent: Friday, September 06, 2013 9:27 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] ETF stats
Hello Randy,
could you recommend a file for etfs. I am looking at 1,3,5 year returns, std dev, expenses, yield etc...
Thanks,
Have a great day.
Fri Sep 6, 2013 8:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Between these, you should be able to get a number of items:
RCHGetTableCell-Template-Yahoo-ETF-Data.xls
SMF-Template-Yahoo-Mutual-Fund-Data.xls
But it looks like Yahoo web page changes have made a number of items either
obsolete or error out...
On Fri, Sep 6, 2013 at 6:26 AM, <rr76012@yahoo.com> wrote:
>
> could you recommend a file for etfs. I am looking at 1,3,5 year returns,
> std dev, expenses, yield etc...
>
>
RCHGetTableCell-
SMF-Template-
But it looks like Yahoo web page changes have made a number of items either
obsolete or error out...
On Fri, Sep 6, 2013 at 6:26 AM, <rr76012@yahoo.
>
> could you recommend a file for etfs. I am looking at 1,3,5 year returns,
> std dev, expenses, yield etc...
>
>
Fri Sep 6, 2013 10:48 am (PDT) . Posted by:
rr76012
Randy, thanks your awesome.
rr
--- In smf_addin@yahoogrou
wrote:
Between these, you should be able to get a number of items:
RCHGetTableCell-
SMF-Template-
But it looks like Yahoo web page changes have made a number of
items either obsolete or error out...
On Fri, Sep 6, 2013 at 6:26 AM, <rr76012@
could you recommend a file for etfs. I am looking at 1,3,5 year
returns, std dev, expenses, yield etc...
Fri Sep 6, 2013 6:27 am (PDT) . Posted by:
"nlavery" nlavery
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
Fri Sep 6, 2013 9:43 am (PDT) . Posted by:
"Michael Ho" mhho092
Hi Randy and everyone,
The Advfn problem might be easily solved by changing the URL from www.advfn.com/...
to ih.advfn.com/... in modGetAdvFnElement.
Apparently ih.advfn.com is still using the same URL scheme as before.
Also, ca.advfn.com (I'm from Canada) seems to have reverted to the old layout.
So parsing data shouldn't be a problem now, just that the URL scheme is changed.
This would be a much smaller problem in scope compared to last week.
Randy, I changed the code but can't figure out how to re-compile (?) the .xla,
nor can I get Excel to use debugger to step into the code. Just wondering whether
you can help us create a new build?
Thanks,
Marshall
The Advfn problem might be easily solved by changing the URL from www.advfn.com/
to ih.advfn.com/
Apparently ih.advfn.com is still using the same URL scheme as before.
Also, ca.advfn.com (I'm from Canada) seems to have reverted to the old layout.
So parsing data shouldn'
This would be a much smaller problem in scope compared to last week.
Randy, I changed the code but can't figure out how to re-compile (?) the .xla,
nor can I get Excel to use debugger to step into the code. Just wondering whether
you can help us create a new build?
Thanks,
Marshall
Fri Sep 6, 2013 9:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "ih" prefix did work for a week or two, but then stopped because of
changes they made to that site.
That's why I have AdvFN in limbo right now. Every several days, or every
week, something changes. It's just not worth doing anything until they make
up their minds what they are going to do.
Plus, we've seen a preview of the new "beta" version of the web page, which
is completely different than it used to be. More of a financial statement
layout, without any of the derived ratios or additional information that
they added to the quarterly and annual periods.
On Fri, Sep 6, 2013 at 9:15 AM, Michael Ho <mhho092@yahoo.com> wrote:
>
> The Advfn problem might be easily solved by changing the URL from
> www.advfn.com/...
> to ih.advfn.com/... in modGetAdvFnElement.
>
> Apparently ih.advfn.com is still using the same URL scheme as before.
>
> Also, ca.advfn.com (I'm from Canada) seems to have reverted to the old
> layout.
> So parsing data shouldn't be a problem now, just that the URL scheme is
> changed.
> This would be a much smaller problem in scope compared to last week.
>
> Randy, I changed the code but can't figure out how to re-compile (?) the
> .xla,
> nor can I get Excel to use debugger to step into the code. Just wondering
> whether
> you can help us create a new build?
>
>
changes they made to that site.
That's why I have AdvFN in limbo right now. Every several days, or every
week, something changes. It's just not worth doing anything until they make
up their minds what they are going to do.
Plus, we've seen a preview of the new "beta" version of the web page, which
is completely different than it used to be. More of a financial statement
layout, without any of the derived ratios or additional information that
they added to the quarterly and annual periods.
On Fri, Sep 6, 2013 at 9:15 AM, Michael Ho <mhho092@yahoo.
>
> The Advfn problem might be easily solved by changing the URL from
> www.advfn.com/
> to ih.advfn.com/
>
> Apparently ih.advfn.com is still using the same URL scheme as before.
>
> Also, ca.advfn.com (I'm from Canada) seems to have reverted to the old
> layout.
> So parsing data shouldn'
> changed.
> This would be a much smaller problem in scope compared to last week.
>
> Randy, I changed the code but can't figure out how to re-compile (?) the
> .xla,
> nor can I get Excel to use debugger to step into the code. Just wondering
> whether
> you can help us create a new build?
>
>
Fri Sep 6, 2013 9:43 am (PDT) . Posted by:
mhho092
Hi Randy and everyone,
I think the advfn problem can be solved by changing from
www.advfn.com/
ih.advfn.com/
It seems ih.advfn.com has not been changed to use the new URL
scheme.
But at the first glance, even the new URL/HTML-input scheme is
not much different from the old scheme. Also, it looks like (I'm
in Canada so I get redirected to ca.advfn.com) they have reverted
to the old layout, so parsing shouldn'
just the URL is different which is a much simpler problem in
scope.
Not sure whether Randy would be able to publish a new build with
the URL changed to ih.advfn.com
Marshall
--- In smf_addin@yahoogrou
I have derived huge benefit from this group, and from all of
Randy's hard work. In the spirit of giving something back, I
rebuilt the 10 year ADVfn model using GuruFocus data and uploaded
it.
It's got some issues, and there are some fields that are
inconsistent, so I've tried to fix them as best possible
(Revenues and Inventory wouldn't pull consistently so I calculate
the number, for example). I've coded the pulled data green and
the calculated data in black. I set it up so that for companies
with less than 10 years of data the first few rows show up
(mostly) blank. The presentation is a little funky and I'm sure
there are more errors to fix, so feel free to update and replace
it.
Hope this helps some of the folks that were inconvenienced.
--- In smf_addin@yahoogrou
Good morning Randy,
Just want to add my two cents to the Advfn data discussion.
I was able to bring FTR'S latest and historical financial data
into a spreadsheet from the new Advfn site with the smf-addin.
It's not as elegant and efficient as it was prior to the revamped
website but it worked with FTR.
For those who are interested in testing it out here's how you do
it:
1. Go to this Group files section
2. Open SmfGetTagContent
3. Download and open
SmfGetTagContent-
4. Paste the following url
(http://www.advfn.
ions-corp-mm-
<http://www.advfn.
ions-corp-mm-
the web page cell. Do this in all of the five sheets of the
spreadsheet. Data will start to appear.
5. Make a copy of "By Table Cell" sheet in the same spreadsheet
a)Paste the url address in 4 in cell C9
b)Keep cells c10:c14 blank
c)Paste
=IF($C$9="
"--"
d)Drag formula in C18 across columns(to 12) and rows (to 7)
f)Extending columns and formula from 12 (N17) to 90 (CN17) and
rows B25 (7) to 371 (B389) or so will give you all annual
financial statements for frontier communications.
g) For Quarterly data paste this
url:(http://www.advfn.
ications-corp-
m=Q)
<http://www.advfn.
ions-corp-mm-
> in C9.
h) Be patient. It will take some time to populate the
spreadsheet.
Question: What does "mm" between "copr" and "FTR" stand for?
Hope this helps.
--- In smf_addin@yahoogrou
wrote:
>
>
>
> This is for you if you are in need of financial data to import
into your spreadsheet.
>
> I am very grateful to Randy for his amazing add-in and I used
it primarily for many years and built a lot of spreadsheets out
of it.
>
> But last year, websites started to change designs to become
more dynamic and used less tables which meant data couldn't be
pulled. I figured that sooner than later, scraping data was going
to become difficult.
>
> Seems like this situation is very close.
>
> My name is Jae Jun and I run a website (oldschoolvalue.
with a subscription to my own data feed for my stock analyzer
product. It downloads and imports all the financial data along
with valuation models and the works. You can use the SMF add-in
along with the spreadsheet without any issues.
>
> But here's the deal. Until I started paying for the data, I
didn't realize how expensive it was.
>
> With Randy's permission, if you are interested in accessing
JUST the financial statements (downloads 10 annual statements and
5 quarterly numbers) without worrying about websites screwing up,
then I can create a barebones version of my spreadsheet and offer
it to SMF members ONLY. Think of it as a template.
>
> There will be a subscription price associated with it.
> Discounted of course because it was thanks to Randy for giving
me the idea in the first place. Cost will likely be $20/month
which is peanuts compared to the time and headache you will save
yourself.
>
> Below is a sample excel file of what I'm talking about. You get
the full financial statements, just like you did with advfn
before all these changes.
>
>
http://oldschoolval
le_Stock_Analyzer_
<http://oldschoolval
ple_Stock_Analyzer_
>
> If Randy doesn't like the idea of selling on his group, then I
apologize and won't bring it up again. Just think that this will
be a good long-term solution to the current problems.
>
> If Randy is ok with it and there is enough people who are
interested, then I will try to set up everything to make it
happen.
>
> Before I post any more details, I'll see what Randy and you all
think.
>
>
>
> --- In smf_addin@yahoogrou
<kermitp@
> >
> > Folks, I think we have pretty well established that ADVFN
site is not
> > working.
> >
> > I don't think we need any more posting to tell us what we
already know.
> >
> > Come to think of it, we probably don't need my posting
either.
> >
> > Have a nice day, everyone
> >
> > Kermit
> >
> > -----Original Message-----
> > From: smf_addin@yahoogrou
[mailto:smf_addin@yahoogrou
> > Of codyklein
> > Sent: Wednesday, August 28, 2013 7:26 PM
> > To: smf_addin@yahoogrou
> > Subject: [smf_addin] Re: Advfn data not updating in smf_addin
> >
> > The new site is disappointing IMO. Heres a peek at FTR:
> >
http://www.advfn.
ons-corp-mm
<http://www.advfn.
ions-corp-mm>
> > -FTR/full-financial
> >
> >
> > --- In smf_addin@yahoogrou
wrote:
> > >
> > > The ADVFN site isn't even working right if you try and go
back to get
> > annual data starting in 2003 or so it takes you to the wrong
page, it kicks
> > you back to the summary page.
> > >
> >
> >
> >
> >
> > ------------
> >
> > Yahoo! Groups Links
> >
>
Fri Sep 6, 2013 9:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "ih" website doesn't even work right now. Go to any annual or quarterly
page and use the drop-down box to try and change the viewed periods. It
bumps you back out to the main company information page.
Until AdvFN stops messing around with things, I don't see any point in
modifying things. I'm not even sure we could trust the data being
displayed...
On Fri, Sep 6, 2013 at 8:04 AM, <mhho092@yahoo.com> wrote:
>
> I think the advfn problem can be solved by changing from www.advfn.com/p.php
> ... <http://www.advfn.com/p.php%20...> to ih.advfn.com/p.php
>
>
> It seems ih.advfn.com has not been changed to use the new URL scheme.
>
>
>
> But at the first glance, even the new URL/HTML-input scheme is not much
> different from the old scheme. Also, it looks like (I'm in Canada so I get
> redirected to ca.advfn.com) they have reverted to the old layout, so
> parsing shouldn't pose an issue anymore -- just the URL is different which
> is a much simpler problem in scope.
>
>
>
> Not sure whether Randy would be able to publish a new build with the URL
> changed to ih.advfn.com
>
>
page and use the drop-down box to try and change the viewed periods. It
bumps you back out to the main company information page.
Until AdvFN stops messing around with things, I don't see any point in
modifying things. I'm not even sure we could trust the data being
displayed...
On Fri, Sep 6, 2013 at 8:04 AM, <mhho092@yahoo.
>
> I think the advfn problem can be solved by changing from www.advfn.com/
> ... <http://www.advfn.
>
>
> It seems ih.advfn.com has not been changed to use the new URL scheme.
>
>
>
> But at the first glance, even the new URL/HTML-input scheme is not much
> different from the old scheme. Also, it looks like (I'm in Canada so I get
> redirected to ca.advfn.com) they have reverted to the old layout, so
> parsing shouldn'
> is a much simpler problem in scope.
>
>
>
> Not sure whether Randy would be able to publish a new build with the URL
> changed to ih.advfn.com
>
>
Fri Sep 6, 2013 10:27 am (PDT) . Posted by:
indinvestor111
Hi,
I just received a premium membership to Morningstar.
can access the 10 columns of data they provide.
Unfortunately, even while logged in the array I've set up returns
only 5 columns of data. I've got "columnyear&qu
array is at least 13 columns wide. Is there some IE setting I
have to change?
FYI, built the sheet before I had access to the paid-for content.
Perhaps this is an issue. I remember reading something about IE
cookies in past posts, but this new group setup is such that I
can't find it any longer.
Thanks
Fri Sep 6, 2013 10:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What URL are you using? I just tried this:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=GOOG&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
")
...and it worked fine for me (12 columns of data returned -- label, 10
years, plus TTM).
I used the EXCEL Web Query dialog to make sure I was logged in first.
On Fri, Sep 6, 2013 at 10:27 AM, <elandry@bmlcapital.com> wrote:
> I just received a premium membership to Morningstar.com so that I can
> access the 10 columns of data they provide.
>
> Unfortunately, even while logged in the array I've set up returns only 5
> columns of data. I've got "columnyear" set to 10, and the array is at least
> 13 columns wide. Is there some IE setting I have to change?
>
> FYI, built the sheet before I had access to the paid-for content. Perhaps
> this is an issue. I remember reading something about IE cookies in past
> posts, but this new group setup is such that I can't find it any longer.
>
>
>
=smfGetCSVFile(
http://financials.
")
...and it worked fine for me (12 columns of data returned -- label, 10
years, plus TTM).
I used the EXCEL Web Query dialog to make sure I was logged in first.
On Fri, Sep 6, 2013 at 10:27 AM, <elandry@bmlcapital.
> I just received a premium membership to Morningstar.
> access the 10 columns of data they provide.
>
> Unfortunately, even while logged in the array I've set up returns only 5
> columns of data. I've got "columnyear&qu
> 13 columns wide. Is there some IE setting I have to change?
>
> FYI, built the sheet before I had access to the paid-for content. Perhaps
> this is an issue. I remember reading something about IE cookies in past
> posts, but this new group setup is such that I can't find it any longer.
>
>
>
Fri Sep 6, 2013 11:19 am (PDT) . Posted by:
indinvestor111
Thanks for the reply!
I'm using:
=smfGetCSVFile(
ess4CSV.html?
asc&columnYear=
<http://financials.
"&$A$1&"
10&rounding=
Would it be too much to ask how I find out if Excel knows I'm
logged in? I pulled up the "new web query" box and logged into
the site through it, but am still not having success. There is no
reference to Morningstar in the existing connection box, if that
means anything.
Thanks
--- In smf_addin@yahoogrou
What URL are you using? I just tried this:
=smfGetCSVFile(
ess4CSV.html?
columnYear=10&round
<http://financials.
GOOG&reportType=
ounding=3&denominat
...and it worked fine for me (12 columns of data returned --
label, 10 years, plus TTM).
I used the EXCEL Web Query dialog to make sure I was logged in
first.
On Fri, Sep 6, 2013 at 10:27 AM, <elandry@
I just received a premium membership to Morningstar.
can access the 10 columns of data they provide.
Unfortunately, even while logged in the array I've set up returns
only 5 columns of data. I've got "columnyear&qu
and the array is at least 13 columns wide. Is there some IE
setting I have to change?
FYI, built the sheet before I had access to the paid-for content.
Perhaps this is an issue. I remember reading something
about IE cookies in past posts, but this new group setup is such
that I can't find it any longer.
Â
Fri Sep 6, 2013 11:31 am (PDT) . Posted by:
indinvestor111
When I click on your link it returns 10 years. Also, when I
changed my link to include a static ticker, then paste to a word
doc, then click it, I get 10 years as well. Perhaps I need to
reprogram the arrays.
Make any sense?
--- In smf_addin@yahoogrou
Thanks for the reply!
I'm using:
=smfGetCSVFile(
ess4CSV.html?
asc&columnYear=
<http://financials.
"&$A$1&"
10&rounding=
Would it be too much to ask how I find out if Excel knows I'm
logged in? I pulled up the "new web query" box and logged into
the site through it, but am still not having success. There is no
reference to Morningstar in the existing connection box, if that
means anything.
Thanks
--- In smf_addin@yahoogrou
What URL are you using? I just tried this:
=smfGetCSVFile(
ess4CSV.html?
columnYear=10&round
<http://financials.
GOOG&reportType=
ounding=3&denominat
...and it worked fine for me (12 columns of data returned --
label, 10 years, plus TTM).
I used the EXCEL Web Query dialog to make sure I was logged in
first.
On Fri, Sep 6, 2013 at 10:27 AM, <elandry@
I just received a premium membership to Morningstar.
can access the 10 columns of data they provide.
Unfortunately, even while logged in the array I've set up returns
only 5 columns of data. I've got "columnyear&qu
and the array is at least 13 columns wide. Is there some
IE setting I have to change?
FYI, built the sheet before I had access to the paid-for content.
Perhaps this is an issue. I remember reading something
about IE cookies in past posts, but this new group setup is such
that I can't find it any longer.
Â
Tidak ada komentar:
Posting Komentar