10 New Messages
Digest #2776
Messages
Tue Sep 17, 2013 4:14 am (PDT) . Posted by:
gpommer1982
I'm having trouble with the ADVFN functions returning an 'ERROR'.
When I enter a ticker symbol, the functions from MSN, etc work
fine but it won't pull any data from ADVFN. I am using
=RCHGetElementNumber("ticker", xxxx) to get my data. This
started when Windows updated. I've tried pulling new SMF Add-In
files, restarting, disabling and then reenabling the Add-In to no
avail and I'm not sure where to go next. Hoping someone can
help.
When I enter a ticker symbol, the functions from MSN, etc work
fine but it won't pull any data from ADVFN. I am using
=RCHGetElementNumbe
started when Windows updated. I've tried pulling new SMF Add-In
files, restarting, disabling and then reenabling the Add-In to no
avail and I'm not sure where to go next. Hoping someone can
help.
Tue Sep 17, 2013 4:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you look at the messages over the past month (or more), you'll see AdvFN
has been a frequent topic of conversation. They have been fiddling around
with their website structure and content. Often, the web pages aren't even
working.
So the use of AdvFN data is up in the air right now, until they get their
act straightened out.
On Mon, Sep 16, 2013 at 8:02 PM, <gpommer1982@yahoo.com> wrote:
>
> I'm having trouble with the ADVFN functions returning an 'ERROR'. When I
> enter a ticker symbol, the functions from MSN, etc work fine but it won't
> pull any data from ADVFN. I am using =RCHGetElementNumber("ticker", xxxx)
> to get my data. This started when Windows updated. I've tried pulling new
> SMF Add-In files, restarting, disabling and then reenabling the Add-In to
> no avail and I'm not sure where to go next. Hoping someone can help.
>
has been a frequent topic of conversation. They have been fiddling around
with their website structure and content. Often, the web pages aren't even
working.
So the use of AdvFN data is up in the air right now, until they get their
act straightened out.
On Mon, Sep 16, 2013 at 8:02 PM, <gpommer1982@
>
> I'm having trouble with the ADVFN functions returning an 'ERROR&#
> enter a ticker symbol, the functions from MSN, etc work fine but it won't
> pull any data from ADVFN. I am using =RCHGetElementNumbe
> to get my data. This started when Windows updated. I've tried pulling new
> SMF Add-In files, restarting, disabling and then reenabling the Add-In to
> no avail and I'm not sure where to go next. Hoping someone can help.
>
Tue Sep 17, 2013 10:54 am (PDT) . Posted by:
"derrickhnj" derrickhnj
Thanks for the update. Thanks so much for this add-in as well. Do you know of another element we could use for 10 year historical financials as a substitute for ADVFN in the meantime?
Thanks,
Derrick
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you look at the messages over the past month (or more), you'll see AdvFN
> has been a frequent topic of conversation. They have been fiddling around
> with their website structure and content. Often, the web pages aren't even
> working.
>
> So the use of AdvFN data is up in the air right now, until they get their
> act straightened out.
>
>
> On Mon, Sep 16, 2013 at 8:02 PM, <gpommer1982@...> wrote:
>
> >
> > I'm having trouble with the ADVFN functions returning an 'ERROR'. When I
> > enter a ticker symbol, the functions from MSN, etc work fine but it won't
> > pull any data from ADVFN. I am using =RCHGetElementNumber("ticker", xxxx)
> > to get my data. This started when Windows updated. I've tried pulling new
> > SMF Add-In files, restarting, disabling and then reenabling the Add-In to
> > no avail and I'm not sure where to go next. Hoping someone can help.
> >
>
Thanks,
Derrick
--- In smf_addin@yahoogrou
>
> If you look at the messages over the past month (or more), you'll see AdvFN
> has been a frequent topic of conversation. They have been fiddling around
> with their website structure and content. Often, the web pages aren't even
> working.
>
> So the use of AdvFN data is up in the air right now, until they get their
> act straightened out.
>
>
> On Mon, Sep 16, 2013 at 8:02 PM, <gpommer1982@
>
> >
> > I'm having trouble with the ADVFN functions returning an 'ERROR&#
> > enter a ticker symbol, the functions from MSN, etc work fine but it won't
> > pull any data from ADVFN. I am using =RCHGetElementNumbe
> > to get my data. This started when Windows updated. I've tried pulling new
> > SMF Add-In files, restarting, disabling and then reenabling the Add-In to
> > no avail and I'm not sure where to go next. Hoping someone can help.
> >
>
Tue Sep 17, 2013 10:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't think there are any elements. But you can look at the GuruFocus
workbook that was uploaded recently.
Or use the MorningStar file and do VLOOKUP() functions to grab the data:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/19776
On Tue, Sep 17, 2013 at 10:45 AM, derrickhnj <derrickhorvath@gmail.com>wrote:
> Thanks for the update. Thanks so much for this add-in as well. Do you
> know of another element we could use for 10 year historical financials as a
> substitute for ADVFN in the meantime?
>
workbook that was uploaded recently.
Or use the MorningStar file and do VLOOKUP() functions to grab the data:
http://groups.
On Tue, Sep 17, 2013 at 10:45 AM, derrickhnj <derrickhorvath@
> Thanks for the update. Thanks so much for this add-in as well. Do you
> know of another element we could use for 10 year historical financials as a
> substitute for ADVFN in the meantime?
>
Tue Sep 17, 2013 4:14 am (PDT) . Posted by:
michalemory
Not all of the financial statements on Morningstar have the same
data. For example, Halliburton's Income statement has
'Restructuring, merger and acquisition', whereas, Ford's does
not.
This is creating issues when using the raw data for something
like a DCF model. For one stock, row 11 may be operating income
and the other stock operating income may be row 10. Is there a
way to ensure that the right data automatically ends up in the
right place on the model?
Thanks and sorry if this has been asked before.
data. For example, Halliburton&#
'Restructuring, merger and acquisition&#
not.
This is creating issues when using the raw data for something
like a DCF model. For one stock, row 11 may be operating income
and the other stock operating income may be row 10. Is there a
way to ensure that the right data automatically ends up in the
right place on the model?
Thanks and sorry if this has been asked before.
Tue Sep 17, 2013 4:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Retrieve only what you need, or use VLOOKUP() functions to find what you
need. And then add processing to handle the situation if what you need
doesn't exist.
As you note, assuming something is on row 10 or 11 may not be a good idea.
On Mon, Sep 16, 2013 at 11:59 AM, <michalemory@yahoo.com> wrote:
>
> Not all of the financial statements on Morningstar have the same data.
> For example, Halliburton's Income statement has 'Restructuring, merger and
> acquisition', whereas, Ford's does not.
>
> This is creating issues when using the raw data for something like a DCF
> model. For one stock, row 11 may be operating income and the other stock
> operating income may be row 10. Is there a way to ensure that the right
> data automatically ends up in the right place on the model?
>
> Thanks and sorry if this has been asked before.
>
need. And then add processing to handle the situation if what you need
doesn't exist.
As you note, assuming something is on row 10 or 11 may not be a good idea.
On Mon, Sep 16, 2013 at 11:59 AM, <michalemory@
>
> Not all of the financial statements on Morningstar have the same data.
> For example, Halliburton&#
> acquisition&#
>
> This is creating issues when using the raw data for something like a DCF
> model. For one stock, row 11 may be operating income and the other stock
> operating income may be row 10. Is there a way to ensure that the right
> data automatically ends up in the right place on the model?
>
> Thanks and sorry if this has been asked before.
>
Tue Sep 17, 2013 6:43 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi all,
I found a website that is not new, but they just updated it with a ton of
data I think we can use the SMF tool to access a lot of the items that don't
show up well from Yahoo and other sites.
www.quandl.com
(I have no affiliation)
It's free to sign up and if you sign up, you get access to their "API
access" which is the mother lode of data. It caught my attention because
"float" was at the top of the list and that number is jacked up on the
GetYahooQuotes function.
Of course I'm not proficient enough at setting up this SMF stuff by myself
YET, but I thought if Randy or one of you other gurus wanted to tackle it,
you could set up something similar to the RCHGetYahooQuotes from this quandl
site and actually dwarf the data you get from yahoo. This site has a bunch
of other countries and fundamental data, economic data, GDP, unemployment,
crime, etc., etc.
I would dearly love to be able to set up something like a RCHGetYahooQuotes
array on the list of codes available from this site. (hint, hint)
Thanks,
Jim
I found a website that is not new, but they just updated it with a ton of
data I think we can use the SMF tool to access a lot of the items that don't
show up well from Yahoo and other sites.
www.quandl.com
(I have no affiliation)
It's free to sign up and if you sign up, you get access to their "API
access" which is the mother lode of data. It caught my attention because
"float" was at the top of the list and that number is jacked up on the
GetYahooQuotes function.
Of course I'm not proficient enough at setting up this SMF stuff by myself
YET, but I thought if Randy or one of you other gurus wanted to tackle it,
you could set up something similar to the RCHGetYahooQuotes from this quandl
site and actually dwarf the data you get from yahoo. This site has a bunch
of other countries and fundamental data, economic data, GDP, unemployment,
crime, etc., etc.
I would dearly love to be able to set up something like a RCHGetYahooQuotes
array on the list of codes available from this site. (hint, hint)
Thanks,
Jim
Tue Sep 17, 2013 7:11 am (PDT) . Posted by:
"Jim Ranum" amt2100
Oops. Well, I just got an email when I signed up that quandl has an Excel
addin available.
Sorry.
I'm sure they got the idea from Randy.
Jim
Sent: Tuesday, September 17, 2013 9:43 AM
To: 'smf_addin@yahoogroups.com'
Subject: New website data
Hi all,
I found a website that is not new, but they just updated it with a ton of
data I think we can use the SMF tool to access a lot of the items that don't
show up well from Yahoo and other sites.
www.quandl.com
(I have no affiliation)
It's free to sign up and if you sign up, you get access to their "API
access" which is the mother lode of data. It caught my attention because
"float" was at the top of the list and that number is jacked up on the
GetYahooQuotes function.
Of course I'm not proficient enough at setting up this SMF stuff by myself
YET, but I thought if Randy or one of you other gurus wanted to tackle it,
you could set up something similar to the RCHGetYahooQuotes from this quandl
site and actually dwarf the data you get from yahoo. This site has a bunch
of other countries and fundamental data, economic data, GDP, unemployment,
crime, etc., etc.
I would dearly love to be able to set up something like a RCHGetYahooQuotes
array on the list of codes available from this site. (hint, hint)
Thanks,
Jim
addin available.
Sorry.
I'm sure they got the idea from Randy.
Jim
Sent: Tuesday, September 17, 2013 9:43 AM
To: 'smf_addin@
Subject: New website data
Hi all,
I found a website that is not new, but they just updated it with a ton of
data I think we can use the SMF tool to access a lot of the items that don't
show up well from Yahoo and other sites.
www.quandl.com
(I have no affiliation)
It's free to sign up and if you sign up, you get access to their "API
access" which is the mother lode of data. It caught my attention because
"float" was at the top of the list and that number is jacked up on the
GetYahooQuotes function.
Of course I'm not proficient enough at setting up this SMF stuff by myself
YET, but I thought if Randy or one of you other gurus wanted to tackle it,
you could set up something similar to the RCHGetYahooQuotes from this quandl
site and actually dwarf the data you get from yahoo. This site has a bunch
of other countries and fundamental data, economic data, GDP, unemployment,
crime, etc., etc.
I would dearly love to be able to set up something like a RCHGetYahooQuotes
array on the list of codes available from this site. (hint, hint)
Thanks,
Jim
Tue Sep 17, 2013 8:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing automated -- you'd have to grab them yourself, maybe with
RCHGetTableCell() or smfGetTagContent().
On Mon, Sep 16, 2013 at 6:30 PM, lawrence.leesh <lawrence.leesh@yahoo.com>wrote:
>
> smfPricesByDates use Yahoo symbols, which are not available for Thailand
> stocks. Is there another function similar to this that works with Google
> symbols?
>
RCHGetTableCell(
On Mon, Sep 16, 2013 at 6:30 PM, lawrence.leesh <lawrence.leesh@
>
> smfPricesByDates use Yahoo symbols, which are not available for Thailand
> stocks. Is there another function similar to this that works with Google
> symbols?
>
Tue Sep 17, 2013 2:41 pm (PDT) . Posted by:
dmatu2000
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.
Tidak ada komentar:
Posting Komentar