11 New Messages
Digest #2771
Messages
Thu Sep 12, 2013 5:00 am (PDT) . Posted by:
"raiders8112" raiders8112
Does anyone know how to convert the Morningstar.xlsx file to retrieve quarterly data?
Thanks.
Thanks.
Thu Sep 12, 2013 10:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The MorningStar URLs need to be changed from "&period=12" to "&period=3".
That changes what is RETRIEVED, but I'm not sure that's the only change you
would need to make to PROCESS the retrieved data correctly.
On Wed, Sep 11, 2013 at 12:50 PM, raiders8112 <mike.russo@comcast.net>wrote:
> Does anyone know how to convert the Morningstar.xlsx file to retrieve
> quarterly data?
>
That changes what is RETRIEVED, but I'm not sure that's the only change you
would need to make to PROCESS the retrieved data correctly.
On Wed, Sep 11, 2013 at 12:50 PM, raiders8112 <mike.russo@comcast.
> Does anyone know how to convert the Morningstar.
> quarterly data?
>
Thu Sep 12, 2013 5:27 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Is there a way to download the whole csv file and look at it?
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, September 12, 2013 3:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] basic quote
Because Yahoo throws a comma-delimited number in the middle of a comma-delimited file, the "float shares" data item shouldn't be used -- unless you want to make it your last field, so you know how to construct it. The RCHGetYahooQuotes() function is little more than a CSV file parser, so it doesn't know what each field is in each record sent by Yahoo.
On Wed, Sep 11, 2013 at 7:21 AM, Michael Grames <mike@grames.net> wrote:
Float Shares is returning 3 columns, the first value seems correct, but I don't know the following two (88 & 0 in my example). I shifted the input parameters over one column, so the symbol shows twice. I usually don't have the Symbol as one of the inputs, but you didn't either, as you were only taking inputs from B2 to R2.
Is there a way to download the whole csv file and look at it?
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Thursday, September 12, 2013 3:08 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] basic quote
Because Yahoo throws a comma-delimited number in the middle of a comma-delimited file, the "float shares" data item shouldn'
On Wed, Sep 11, 2013 at 7:21 AM, Michael Grames <mike@grames.
Float Shares is returning 3 columns, the first value seems correct, but I don't know the following two (88 & 0 in my example). I shifted the input parameters over one column, so the symbol shows twice. I usually don't have the Symbol as one of the inputs, but you didn't either, as you were only taking inputs from B2 to R2.
Thu Sep 12, 2013 9:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sure. It's actually based on the "Download Data (delayed)" link on the main
quote page of a stock:
http://finance.yahoo.com/q?s=MMM
That is:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csv
The "s=MMM" tells it the ticker and the "&f=sl1d1t1c1ohgv" gives it the
list of Yahoo codes. So, if you wanted just the last price for IBM and MMM,
you would use this URL:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM&f=sl1&e=.csv
I just add a "view-source:" prefix to the URL to view the file in my
browser (FireFox).
On Thu, Sep 12, 2013 at 5:27 AM, Jim Ranum <amt2100@gmail.com> wrote:
>
> Is there a way to download the whole csv file and look at it?****
>
>
>
quote page of a stock:
http://finance.
That is:
http://download.
The "s=MMM" tells it the ticker and the "&f=sl1d1t1c1o
list of Yahoo codes. So, if you wanted just the last price for IBM and MMM,
you would use this URL:
http://download.
I just add a "view-source:
browser (FireFox).
On Thu, Sep 12, 2013 at 5:27 AM, Jim Ranum <amt2100@gmail.
>
> Is there a way to download the whole csv file and look at it?****
>
>
>
Thu Sep 12, 2013 11:21 am (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy.
That view-source instruction is probably the thing I'd like to see. But what would I enter to see all the codes? Maybe there are some unusual ones that would be interesting.
I've tried several different ways of typing the view-source in front of the URL and none of them work. Can you please give us the specific way to type that? Is there a slash or period, etc.?
Thanks again,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, September 12, 2013 12:53 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] basic quote
Sure. It's actually based on the "Download Data (delayed)" link on the main quote page of a stock:
http://finance.yahoo.com/q?s=MMM
That is:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM <http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csv> &f=sl1d1t1c1ohgv&e=.csv
The "s=MMM" tells it the ticker and the "&f=sl1d1t1c1ohgv" gives it the list of Yahoo codes. So, if you wanted just the last price for IBM and MMM, you would use this URL:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM <http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM&f=sl1&e=.csv> &f=sl1&e=.csv
I just add a "view-source:" prefix to the URL to view the file in my browser (FireFox).
On Thu, Sep 12, 2013 at 5:27 AM, Jim Ranum <amt2100@gmail.com> wrote:
Is there a way to download the whole csv file and look at it?
That view-source instruction is probably the thing I'd like to see. But what would I enter to see all the codes? Maybe there are some unusual ones that would be interesting.
I've tried several different ways of typing the view-source in front of the URL and none of them work. Can you please give us the specific way to type that? Is there a slash or period, etc.?
Thanks again,
Jim
From: smf_addin@yahoogrou
Sent: Thursday, September 12, 2013 12:53 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] basic quote
Sure. It's actually based on the "Download Data (delayed)" link on the main quote page of a stock:
http://finance.
That is:
http://download.
The "s=MMM" tells it the ticker and the "&f=sl1d1t1c1o
http://download.
I just add a "view-source:
On Thu, Sep 12, 2013 at 5:27 AM, Jim Ranum <amt2100@gmail.
Is there a way to download the whole csv file and look at it?
Thu Sep 12, 2013 10:45 am (PDT) . Posted by:
gbullr
That dog will hunt!.
Thanks.
--- In smf_addin@yahoogrou
It's an EXCEL file, not a CSV file, so smfGetCSVFile(
work.
If you know the name of the EXCEL file on the Internet, you can
access it directly, as in this example:
http://finance.
<http://finance.
However, if the URL you cited CREATES the workbook and then
downloads it, you may be out of luck.
An alternative is to use the MorningStar holdings CSV file:
=smfGetCSVFile(
port?exportType=
<http://portfolios.
=details&t=GURU> ")
On Tue, Sep 10, 2013 at 10:48 AM, <gaston.bullrich
<mailto:gaston.
I am looking to download the file that opens up when you click
this link:
http://www.globalxf
<http://www.globalxf
>
automatically.
Is it possible to use the smfgetcsv() function?
Thu Sep 12, 2013 11:11 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It works. But it is very slow. A spreadsheer which retrieve the option chain for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion on how to speed it up?
tx
tx
Thu Sep 12, 2013 12:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'll need to define "didn't work properly". I don't know what I should be
looking for.
On Thu, Sep 12, 2013 at 12:36 AM, sri yanto <sri.yanto@yahoo.com> wrote:
>
> =RCHGetYahooQuotes - smoe function didn;'t work properly
>
> i wanna ask, this function, since yesterday, i just realized that some
> code like "k", "k5", "j", or somethin related o 52 high or low, can return
> as usual, any idea?
>
looking for.
On Thu, Sep 12, 2013 at 12:36 AM, sri yanto <sri.yanto@yahoo.
>
> =RCHGetYahooQuotes - smoe function didn;'t work properly
>
> i wanna ask, this function, since yesterday, i just realized that some
> code like "k"
> as usual, any idea?
>
Thu Sep 12, 2013 7:42 pm (PDT) . Posted by:
"sri yanto" sri.yanto
it's return zero for "w"
and Return N/A for "k"
i'am using RCHGetYahooQuotes("~~~~~.JK","k") in smf update table content, which tildas replacing ticker like MAIN, BMRI
thnak bro
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You'll need to define "didn't work properly". I don't know what I should be
> looking for.
>
> On Thu, Sep 12, 2013 at 12:36 AM, sri yanto <sri.yanto@...> wrote:
>
> >
> > =RCHGetYahooQuotes - smoe function didn;'t work properly
> >
> > i wanna ask, this function, since yesterday, i just realized that some
> > code like "k", "k5", "j", or somethin related o 52 high or low, can return
> > as usual, any idea?
> >
>
and Return N/A for "k"
i'am using RCHGetYahooQuotes(
thnak bro
--- In smf_addin@yahoogrou
>
> You'll need to define "didn&#
> looking for.
>
> On Thu, Sep 12, 2013 at 12:36 AM, sri yanto <sri.yanto@
>
> >
> > =RCHGetYahooQuotes - smoe function didn;'t work properly
> >
> > i wanna ask, this function, since yesterday, i just realized that some
> > code like "k"
> > as usual, any idea?
> >
>
Fri Sep 13, 2013 12:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like that's what Yahoo is populating the file with...
On Thu, Sep 12, 2013 at 7:42 PM, sri yanto <sri.yanto@yahoo.com> wrote:
> it's return zero for "w"
> and Return N/A for "k"
>
> i'am using RCHGetYahooQuotes("~~~~~.JK","k") in smf update table content,
> which tildas replacing ticker like MAIN, BMRI
>
On Thu, Sep 12, 2013 at 7:42 PM, sri yanto <sri.yanto@yahoo.
> it's return zero for "w"
> and Return N/A for "k"
>
> i'am using RCHGetYahooQuotes(
> which tildas replacing ticker like MAIN, BMRI
>
Thu Sep 12, 2013 6:06 pm (PDT) . Posted by:
"Isaac Wiedmann" isaac_wiedmann
Hi Randy,
I just joined this group and started using your plugin. As an engineer myself, I am impressed with the effort you have put in to make all this work, so thank you.
I replied to this thread because I am experiencing the same issue that Bill is. I receive an "Error" for both elements 13862 and 13863 when I enter the equations "=RCHGetElemen
I also ran your suggested test listed in one of the replies and received the same result "3M Co" as Bill.
Just like Bill I am using Microsoft Excel 2010 Professional on a Windows 7 machine.
Thank you
Isaac
--- In smf_addin@yahoogrou
>
> It leaves me confused, since the first of those is the what is saved for
> the element definition.
>
> Usually that means an issue with the VBA EVAL() function, but that occurs
> with older versions of EXCEL, which you say doesn't apply.
>
>
> On Sat, Aug 31, 2013 at 2:47 AM, <bmissell@
>
> > Back to the original issue "13862" not working on my machine - My
> > machine returns "3M CO" for both lines - does that tell you anything for
> > diagnostics?
> >
>
Tidak ada komentar:
Posting Komentar