15 New Messages
Digest #2788
Messages
Fri Sep 27, 2013 2:29 am (PDT) . Posted by:
alankc_mok
Randy,
I used your code but still returns error. Same result after I
installed the RCH addin beta. Is there any other things I can do
?
Thanks
Alan
---In smf_addin@yahoogrou
This works fine for me:
=smfGetOptionQuotes
On Thu, Sep 26, 2013 at 7:50 PM, <alankc_mok@
<mailto:alankc_
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.
Fri Sep 27, 2013 7:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could try the smfForceRecalculation macro. Maybe you got a bad copy of
that web page, so there's nothing there to find. See the LINKS area of the
group for information on that macro.
On Fri, Sep 27, 2013 at 2:29 AM, <alankc_mok@yahoo.com> wrote:
> I used your code but still returns error. Same result after I installed
> the RCH addin beta. Is there any other things I can do ?
>
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
>
> This works fine for me:
>
> =smfGetOptionQuotes("IWM 10/4 2013 $108 Call","l")
>
that web page, so there's nothing there to find. See the LINKS area of the
group for information on that macro.
On Fri, Sep 27, 2013 at 2:29 AM, <alankc_mok@yahoo.
> I used your code but still returns error. Same result after I installed
> the RCH addin beta. Is there any other things I can do ?
>
> ---In smf_addin@yahoogrou
>
> This works fine for me:
>
> =smfGetOptionQuotes
>
Fri Sep 27, 2013 7:30 am (PDT) . Posted by:
dmatu2000
I'm curious how this looks compared to the other 10 year files.
Have you uploaded it to the board?
---In smf_addin@yahoogrou
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@
<mailto:gpommer1
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
<http://financials.
GOOG&reportType=
ounding=3&denominat
...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.
Fri Sep 27, 2013 7:32 am (PDT) . Posted by:
dmatu2000
Also, how do you log into MS in excel?
---In smf_addin@yahoogrou
I'm curious how this looks compared to the other 10 year files.
Have you uploaded it to the board?
---In smf_addin@yahoogrou
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@
<mailto:gpommer1
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
<http://financials.
GOOG&reportType=
ounding=3&denominat
...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.
Fri Sep 27, 2013 7:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No. I didn't feel the need since it's just a single function invocation...
On Fri, Sep 27, 2013 at 7:30 AM, <david_matuszak@yahoo.com> wrote:
> I'm curious how this looks compared to the other 10 year files. Have you
> uploaded it to the board?
> =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.
>
>
On Fri, Sep 27, 2013 at 7:30 AM, <david_matuszak@
> I'm curious how this looks compared to the other 10 year files. Have you
> uploaded it to the board?
> =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.
>
>
Fri Sep 27, 2013 7:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Go to the EXCEL Web Query dialog (I use keyboard shortcut Alt+D+D+W),
navigate to morningstar.com, log in, then hit the "Cancel" button to get
out of the Web Query dialog (you don't actually need to import anything).
On Fri, Sep 27, 2013 at 7:32 AM, <david_matuszak@yahoo.com> wrote:
> Also, how do you log into MS in excel?
>
navigate to morningstar.
out of the Web Query dialog (you don't actually need to import anything).
On Fri, Sep 27, 2013 at 7:32 AM, <david_matuszak@
> Also, how do you log into MS in excel?
>
Fri Sep 27, 2013 8:01 am (PDT) . Posted by:
dmatu2000
Thanks.
Would you mind loading it? I understand that it is a single
function. However, I am not getting it to display correctly. It
could be that I am using my work computer right now and behind a
vpn.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Go to the EXCEL Web Query dialog (I use keyboard shortcut
Alt+D+D+W), navigate to morningstar.com <http://morningstar.com>
, log in, then hit the "Cancel" button to get out of the Web
Query dialog (you don't actually need to import anything).
On Fri, Sep 27, 2013 at 7:32 AM, <david_matuszak@...
<mailto:david_matuszak@...> > wrote:
Also, how do you log into MS in excel?
Would you mind loading it? I understand that it is a single
function. However, I am not getting it to display correctly. It
could be that I am using my work computer right now and behind a
vpn.
---In smf_addin@yahoogrou
Go to the EXCEL Web Query dialog (I use keyboard shortcut
Alt+D+D+W), navigate to morningstar.
, log in, then hit the "Cancel" button to get out of the Web
Query dialog (you don't actually need to import anything).
On Fri, Sep 27, 2013 at 7:32 AM, <david_matuszak@
<mailto:david_
Also, how do you log into MS in excel?
Fri Sep 27, 2013 8:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
OK. I just uploaded:
smfGetCSVFile-Template-MorningStar-Financials.xls
On Fri, Sep 27, 2013 at 8:01 AM, <david_matuszak@yahoo.com> wrote:
>
> Would you mind loading it? I understand that it is a single function.
> However, I am not getting it to display correctly. It could be that I am
> using my work computer right now and behind a vpn.
>
smfGetCSVFile-
On Fri, Sep 27, 2013 at 8:01 AM, <david_matuszak@
>
> Would you mind loading it? I understand that it is a single function.
> However, I am not getting it to display correctly. It could be that I am
> using my work computer right now and behind a vpn.
>
Fri Sep 27, 2013 8:41 am (PDT) . Posted by:
dmatu2000
Thank you. I appreciate it.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
OK. I just uploaded:
smfGetCSVFile-Template-MorningStar-Financials.xls
On Fri, Sep 27, 2013 at 8:01 AM, <david_matuszak@...
<mailto:david_matuszak@...> > wrote:
Would you mind loading it? I understand that it is a single
function. However, I am not getting it to display correctly. It
could be that I am using my work computer right now and behind a
vpn.
---In smf_addin@yahoogrou
OK. I just uploaded:
smfGetCSVFile-
On Fri, Sep 27, 2013 at 8:01 AM, <david_matuszak@
<mailto:david_
Would you mind loading it? I understand that it is a single
function. However, I am not getting it to display correctly. It
could be that I am using my work computer right now and behind a
vpn.
Fri Sep 27, 2013 7:42 am (PDT) . Posted by:
blake_alsman
I used the smfGetTagContent(
from MarketWatch. Here's that formula:
=smfGetTagContent(
G","
---In smf_addin@yahoogrou
wrote:
The documentation for the RCHGetYahooQuotes(
DOCUMENTATION folder in the FILES area of the group. It contains
a list of the Yahoo codes.
Unfortunately, neither "Next Earnings Date" nor "Ex-Dividend
Date" are things that Yahoo provides on their current quotes CSV
interface.
On Tue, Jun 25, 2013 at 5:25 AM, ssztaba <ssjurik@
<mailto:ssjurik@
I'm using =RCHGetYahooQuotes(
formula.
In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and
last price of the stock in Column A. I think the 'n' and 'l1'
are called the Yahoo codes.
I've looked in the Files section, but I am not finding, a list of
other available Yahoo codes. I'm specifically looking for the
Yahoo codes for 'Next Earnings Date" and for "Next Ex Date"
Fri Sep 27, 2013 7:45 am (PDT) . Posted by:
jovica.bozic
---In smf_addin@yahoogrou
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=
Fri Sep 27, 2013 8:02 am (PDT) . Posted by:
jovica.bozic
@friedman_steve
Data from first link is useless since MRQ is missing.
Dara from second link is complete but Cash Flow statement is
missing last quarter from every year so putting together data in
table for visualization or analysis complicates things a bit.
Also there is an issue of errors but big part can be fixed by
adding or subtracting from correct/known data. But verifying 10
yrs + at least 10 Q of data for every company on EDGAR is stupid.
I don't know what source to use. Guru's data isn't detailed,
sometimes their data retrieval is slow and I need 10-12 last
quarters in financials.
---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:
I am noticing ADVFn errors also. 'Extraordinary Items' is always
equal to Net Income every year, which would not be correct.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com>
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.com/common/financial/NASDAQ/apple-computer-inc-A\
APL/full-financials?isfull=1&bsfull=1&cffull=1&grfull=1&prfull=1&\
effull=1&vrfull=1
Data from first link is useless since MRQ is missing.
Dara from second link is complete but Cash Flow statement is
missing last quarter from every year so putting together data in
table for visualization or analysis complicates things a bit.
Also there is an issue of errors but big part can be fixed by
adding or subtracting from correct/known data. But verifying 10
yrs + at least 10 Q of data for every company on EDGAR is stupid.
I don't know what source to use. Guru's data isn't detailed,
sometimes their data retrieval is slow and I need 10-12 last
quarters in financials.
---In smf_addin@yahoogrou
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=
Fri Sep 27, 2013 10:49 am (PDT) . Posted by:
"Dave" drbluesman
Hi All,
I have written an extension for LibreOffice Calc that functions similar
to the SMF addin. It can be found at the LibreOffice Extension center
at http://extensions.libreoffice.org/extension-center/smf-extension/. I
know that an extension like this has been asked about on this forum, and
the group homepage states that LO is not supported here. I hope that
this info will help direct some people to what they are looking for, and
save Randy a bit of time responding to questions that don't pertain to
the Excel SMF addin that is hosted here.
Thanks!
Dave
I have written an extension for LibreOffice Calc that functions similar
to the SMF addin. It can be found at the LibreOffice Extension center
at http://extensions.
know that an extension like this has been asked about on this forum, and
the group homepage states that LO is not supported here. I hope that
this info will help direct some people to what they are looking for, and
save Randy a bit of time responding to questions that don't pertain to
the Excel SMF addin that is hosted here.
Thanks!
Dave
Fri Sep 27, 2013 10:57 am (PDT) . Posted by:
thomas91112
Which function works best for retrieving futures pricing?
Fri Sep 27, 2013 12:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Depends entirely on the source of the data...
On Fri, Sep 27, 2013 at 10:57 AM, <thomas91112@yahoo.com> wrote:
>
> Which function works best for retrieving futures pricing?
>
On Fri, Sep 27, 2013 at 10:57 AM, <thomas91112@
>
> Which function works best for retrieving futures pricing?
>
Tidak ada komentar:
Posting Komentar