10 New Messages
Digest #2787
Messages
Thu Sep 26, 2013 4:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Where did you run into a problem?
On Thu, Sep 26, 2013 at 4:03 PM, Anand Marphatia <marphatia@yahoo.com>wrote:
>
> I joined the group recently, but was unsuccessful in getting the add in to
> work
>
> Can you guide me
>
>
On Thu, Sep 26, 2013 at 4:03 PM, Anand Marphatia <marphatia@yahoo.
>
> I joined the group recently, but was unsuccessful in getting the add in to
> work
>
> Can you guide me
>
>
Thu Sep 26, 2013 7:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you aren't following the documentation. The "welcome to the
group" message should have told you what to do:
*"The first step to using the add-in would be to visit the files area of
the group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation" folder. Sample uses
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."*
The file you are looking at is the documentation for the
RCHGetElementNumber() function. It has a list of all the element numbers
and what they are supposed to return.
PS: You need to send add-in questions to the Yahoo group. I have email
filters that direct them to a folder. I found this message in my SPAM
folder, which means it could easily have been deleted without me ever
seeing it.
On Thu, Sep 26, 2013 at 6:16 PM, Anand Marphatia <marphatia@yahoo.com>wrote:
> So I downloaded
>
> RCH_Stock_Market_Functions xx - I opened the zio and saw two files. I
> clicked on both of them. The second file opened a tab in
> EXcel"RCHgetelemetsnumber";
>
> It shows me a very large number of data in Colum A. Tneplate in B. I do
> not know what to do from there wrt to a specific symbol such as say AAPL
>
> Anand
>
group" message should have told you what to do:
*"The first step to using the add-in would be to visit the files area of
the group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."
The file you are looking at is the documentation for the
RCHGetElementNumber
and what they are supposed to return.
PS: You need to send add-in questions to the Yahoo group. I have email
filters that direct them to a folder. I found this message in my SPAM
folder, which means it could easily have been deleted without me ever
seeing it.
On Thu, Sep 26, 2013 at 6:16 PM, Anand Marphatia <marphatia@yahoo.
> So I downloaded
>
> RCH_Stock_Market_
> clicked on both of them. The second file opened a tab in
> EXcel"RCHgetel
>
> It shows me a very large number of data in Colum A. Tneplate in B. I do
> not know what to do from there wrt to a specific symbol such as say AAPL
>
> Anand
>
Thu Sep 26, 2013 4:59 pm (PDT) . Posted by:
"wolfiyah" wolfiyah
Hi Randy,
Thanks alot for the prompt solution delivered.
After some misconceptions I had about the URL string and some program errors I made, I tested it and it worked perfectly.
Now I shall have shorts data a couple of days earlier than with yahoo!
Peter
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'd be very surprised if nasdaq.com was faster. Are you getting a lot of
> them?
>
> In any case:
>
> =RCHGetTableCell("http://www.nasdaq.com/symbol/mmm/short-interest",column,">Avg
> Daily Share",,,,row)
>
> Just vary row from 1 to whatever and column from 1 to 4, depending on what
> data you want to retrieve.
>
>
> On Thu, Sep 26, 2013 at 12:21 PM, wolfiyah <p.wolfensberger@...>wrote:
>
> >
> > Yahoo is very slow in updating Shares Short.
> > Would it be possible to get the data from nasdaq.com?
> >
> >
>
Thanks alot for the prompt solution delivered.
After some misconceptions I had about the URL string and some program errors I made, I tested it and it worked perfectly.
Now I shall have shorts data a couple of days earlier than with yahoo!
Peter
--- In smf_addin@yahoogrou
>
> I'd be very surprised if nasdaq.com was faster. Are you getting a lot of
> them?
>
> In any case:
>
> =RCHGetTableCell(
> Daily Share",
>
> Just vary row from 1 to whatever and column from 1 to 4, depending on what
> data you want to retrieve.
>
>
> On Thu, Sep 26, 2013 at 12:21 PM, wolfiyah <p.wolfensberger
>
> >
> > Yahoo is very slow in updating Shares Short.
> > Would it be possible to get the data from nasdaq.com?
> >
> >
>
Thu Sep 26, 2013 7:42 pm (PDT) . Posted by:
gpommer1982
Hello all,
I'm attempting to get 10 years worth of data from Morningstar
using the smfGetCSVFile followed by the URL for the location of
the Morningstar data. This is from an old post that Randy had.
I can get the array to work just fine but it only returns 5 years
of data regardless of the columnYear being 5 or 10. I currently
don't have a Morningstar subscription so I guess I'm wondering if
that might be why it only returns 5 years? The file path that
I'm using is below.
=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProc\
ess4CSV.html?t=GOOG&reportType=is&period=12&dataType=A&order=asc&\
columnYear=10&rounding=3&denominatorView=raw")
...where:
-- "reportType" can be "is", "bs", or "cf" (which statement you
want).
-- "period" can be 3 or 12 (quarterly or annual).
-- "dataType"; can be "A" or "R" (As Reported or Restated).
-- "order" can be "asc" or "desc" (order of the years/quarters
going across).
-- "columnYear" can be 5 or 10 (number of columns of data).
-- "denominatorView" can be "raw" or "percentage"
So you could do any of those in an individual worksheet and then
reference the items you want to present.
I'm attempting to get 10 years worth of data from Morningstar
using the smfGetCSVFile followed by the URL for the location of
the Morningstar data. This is from an old post that Randy had.
I can get the array to work just fine but it only returns 5 years
of data regardless of the columnYear being 5 or 10. I currently
don't have a Morningstar subscription so I guess I'm wondering if
that might be why it only returns 5 years? The file path that
I'm using is below.
=smfGetCSVFile(
ess4CSV.html?
columnYear=10&round
...where:
-- "reportType&qu
want).
-- "period" can be 3 or 12 (quarterly or annual).
-- "dataType"
-- "order" can be "asc" or "desc" (order of the years/quarters
going across).
-- "columnYear&qu
-- "denominatorVi
So you could do any of those in an individual worksheet and then
reference the items you want to present.
Thu Sep 26, 2013 7:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yup. I only get 5 years with that URL if I'm not logged in, but 10 if I am
logged in.
On Thu, Sep 26, 2013 at 7:42 PM, <gpommer1982@yahoo.com> wrote:
>
> I'm attempting to get 10 years worth of data from Morningstar using the
> smfGetCSVFile followed by the URL for the location of the Morningstar data.
> This is from an old post that Randy had. I can get the array to work just
> fine but it only returns 5 years of data regardless of the columnYear being
> 5 or 10. I currently don't have a Morningstar subscription so I guess I'm
> wondering if that might be why it only returns 5 years? The file path that
> I'm using is below.
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=GOOG&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
> ")
>
> ...where:
>
> -- "reportType" can be "is", "bs", or "cf" (which statement you want).
> -- "period" can be 3 or 12 (quarterly or annual).
> -- "dataType"; can be "A" or "R" (As Reported or Restated).
> -- "order" can be "asc" or "desc" (order of the years/quarters going
> across).
> -- "columnYear" can be 5 or 10 (number of columns of data).
> -- "denominatorView" can be "raw" or "percentage"
>
> So you could do any of those in an individual worksheet and then reference
> the items you want to present.
>
logged in.
On Thu, Sep 26, 2013 at 7:42 PM, <gpommer1982@
>
> I'm attempting to get 10 years worth of data from Morningstar using the
> smfGetCSVFile followed by the URL for the location of the Morningstar data.
> This is from an old post that Randy had. I can get the array to work just
> fine but it only returns 5 years of data regardless of the columnYear being
> 5 or 10. I currently don't have a Morningstar subscription so I guess I'm
> wondering if that might be why it only returns 5 years? The file path that
> I'm using is below.
>
> =smfGetCSVFile(
> http://financials.
> ")
>
> ...where:
>
> -- "reportType&qu
> -- "period" can be 3 or 12 (quarterly or annual).
> -- "dataType"
> -- "order" can be "asc" or "desc" (order of the years/quarters going
> across).
> -- "columnYear&qu
> -- "denominatorVi
>
> So you could do any of those in an individual worksheet and then reference
> the items you want to present.
>
Thu Sep 26, 2013 7:50 pm (PDT) . Posted by:
alankc_mok
Randy,
I try to get IWM Options Quote for weekly from Yahoo and I use
smfGetOptionQuotes.
It is working fine with Sep 2013 expiry, ie, Sep 27 2013 but
when I switch the date to Oct 4 2013, it returns error.
Please help.
Alan
I try to get IWM Options Quote for weekly from Yahoo and I use
smfGetOptionQuotes.
It is working fine with Sep 2013 expiry, ie, Sep 27 2013 but
when I switch the date to Oct 4 2013, it returns error.
Please help.
Alan
Thu Sep 26, 2013 7:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This works fine for me:
=smfGetOptionQuotes("IWM 10/4 2013 $108 Call","l")
On Thu, Sep 26, 2013 at 7:50 PM, <alankc_mok@yahoo.com> wrote:
>
> I try to get IWM Options Quote for weekly from Yahoo and I use
> smfGetOptionQuotes.
>
> It is working fine with Sep 2013 expiry, ie, Sep 27 2013 but when I
> switch the date to Oct 4 2013, it returns error.
>
=smfGetOptionQuotes
On Thu, Sep 26, 2013 at 7:50 PM, <alankc_mok@yahoo.
>
> I try to get IWM Options Quote for weekly from Yahoo and I use
> smfGetOptionQuotes.
>
> It is working fine with Sep 2013 expiry, ie, Sep 27 2013 but when I
> switch the date to Oct 4 2013, it returns error.
>
Thu Sep 26, 2013 7:52 pm (PDT) . Posted by:
kkkutty
Hi Randy,
Quick question...is there a way to "array-enter" and get multiple
tables from the same web page? For example on this one:
http://www.advfn.com/common/financial/NASDAQ/google-GOOG/full-fin\
ancials?pm=Q&isfull=1&bsfull=1&cffull=1
Thank you very much!
Quick question...is there a way to "array-
tables from the same web page? For example on this one:
http://www.advfn.
ancials?pm=Q&isfull
Thank you very much!
Thu Sep 26, 2013 8:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In some cases, that would be possible, but most web pages will be coded in
such a way that it won't work. This is one of those.
It really wouldn't be that much faster, since the add-in saves the web page
before it extracts the table. So extracting the second table wouldn't need
to retrieve the web page from the Internet, because it's already been saved.
On Thu, Sep 26, 2013 at 7:52 PM, <kkkutty@yahoo.com> wrote:
>
> Quick question...is there a way to "array-enter" and get multiple tables
> from the same web page? For example on this one:
>
>
> http://www.advfn.com/common/financial/NASDAQ/google-GOOG/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1
>
>
>
such a way that it won't work. This is one of those.
It really wouldn't be that much faster, since the add-in saves the web page
before it extracts the table. So extracting the second table wouldn't need
to retrieve the web page from the Internet, because it's already been saved.
On Thu, Sep 26, 2013 at 7:52 PM, <kkkutty@yahoo.
>
> Quick question...is there a way to "array-
> from the same web page? For example on this one:
>
>
> http://www.advfn.
>
>
>
Thu Sep 26, 2013 7:59 pm (PDT) . Posted by:
dcharlotte99
I am noticing ADVFn errors also. 'Extraordinary Items' is always
equal to Net Income every year, which would not be correct.
---In smf_addin@yahoogrou
wrote:
I didn't check everything but what is strange on the first glance
is that Total Operating Expenses could be 0 (talking about AAPL)
for 2008 and earlier, and from 2009 until today is very large
number that doesn't fit at all 100bil. (checked EDGAR and numbers
are wrong).
Also D&A numbers are different if you compare IS & CFS.
Who know what else is incorrect.
If some numbers are so wrong, question is if their data should be
used at all.
LINK :
http://www.advfn.
APL/full-financials
effull=1&vrfull=
Tidak ada komentar:
Posting Komentar