11 New Messages
Digest #2487
Messages
Tue Jan 29, 2013 7:59 am (PST) . Posted by:
"bozo" calhandon
Here's another good one for you, Randy...
As of about 8:36 AM (MST) Yahoo CSV via URL (http://finance.yahoo.com/d/quotes.csv?s=MCD&f=sf6ghjkg5g6i5j1j3j4j5j6k1k2k3k4k5 ) returned the following for McDonald's (I even ran it twice) ...
"MCD", 1,003,123,000,94.05,94.67,83.31,101.29,"N/A - N/A",N/A,"N/A",95.026B,N/A,10.075B,+11.34,+13.61%,"N/A - 94.65","N/A - +0.31%",N/A,-6.64,-6.56%
"MCD", 1,003,123,000,94.05,94.73,83.31,101.29,"N/A - N/A",N/A,"N/A",95.097B,N/A,10.075B,+11.41,+13.70%,"N/A - 94.72","N/A - +0.38%",N/A,-6.57,-6.49%
The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes do anything to flag this garbage data?
Here is a description of the parameters I requested...
COLUMN DISPLAYED DATA
----------------------------------- -------------------
Symbol............................. MCD
Float Shares....................... " 1"
Day's Low.......................... "003"
Day's High......................... "123"
52-Week Low........................ "000"
52-Week High....................... 94.05
Holding Gain % (Real-Time)......... 94.73
Holding Gain (Real-Time)........... 83.31
Order Book (Real-Time)............. 101.29
Market Capitalization.............. "N/A - N/A"
Market Cap (Real-Time)............. N/A
EBITDA............................. "N/A"
Change from 52-Week Low............ 95.097B
% Change from 52-Week Low.......... N/A
Last Trade with Time (Real-Time)... 10.075B
Change % (Real-Time)............... +11.41
Last Trade Size.................... +13.70%
Change from 52-Week High........... "N/A - 94.72"
% Change from 52-Week Low.......... "N/A - +0.38%"
................................... N/A
................................... -6.57
................................... -6.49%
==================================================================
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ]
On Behalf Of Randy Harmelink
Sent: Monday, January 28, 2013 9:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Yup. But I thought the only one was float.
If you have multiple items that might have numeric fields with commas, there would be multiple ways to parse them into individual fields. What I wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser), but I will note that if you open the CSV file with those items in it, EXCEL will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sf6&e=.csv
...returns:
"MMM", 684,453,000
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.com > wrote:
Also, are you aware that Yahoo sometimes uses the thousands separator (yes, a comma!!!) in numbers? If you read this before the market opens on Tuesday, plug in AMAT, with "saa2a5bb2b3b4b6cc1c6c8dd1ee7e8e9" and column headings. Yahoo returns an UNquoted value of 2,000 for Ask Size, which places "2" in Ask Size and "0" in the next column, shifting all column data. It doesn't look like SMF checks the number of items returned and split (using ",") against the number of items requested by the user? If you check this, and the two don't match, then you know Yahoo stuck a comma in where it does not belong, and could do something of your own choice.
As of about 8:36 AM (MST) Yahoo CSV via URL (http://finance.
"MCD"
"MCD"
The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes do anything to flag this garbage data?
Here is a description of the parameters I requested...
COLUMN DISPLAYED DATA
------------
Symbol......
Float Shares......
Day's Low.........
Day's High........
52-Week Low.........
52-Week High........
Holding Gain % (Real-Time).
Holding Gain (Real-Time).
Order Book (Real-Time).
Market Capitalization.
Market Cap (Real-Time).
EBITDA......
Change from 52-Week Low.........
% Change from 52-Week Low.........
Last Trade with Time (Real-Time).
Change % (Real-Time).
Last Trade Size........
Change from 52-Week High........
% Change from 52-Week Low.........
............
............
............
============
From: smf_addin@yahoogrou
On Behalf Of Randy Harmelink
Sent: Monday, January 28, 2013 9:13 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Yup. But I thought the only one was float.
If you have multiple items that might have numeric fields with commas, there would be multiple ways to parse them into individual fields. What I wrote is a fairly simple CSV parser (in fact, it's my generic CSV parser), but I will note that if you open the CSV file with those items in it, EXCEL will also parse the items into separate columns.
It's a Yahoo error in the creation of the CSV file. For example, this:
http://download.
...returns:
"MMM"
Obviously, 4 fields in any definition of a CSV file. EXCEL agrees. :)
On Mon, Jan 28, 2013 at 8:54 PM, bozo bozo@donandcarla.
Also, are you aware that Yahoo sometimes uses the thousands separator (yes, a comma!!!) in numbers? If you read this before the market opens on Tuesday, plug in AMAT, with "saa2a5bb2b3b4
Tue Jan 29, 2013 9:15 am (PST) . Posted by:
"Alain Bigio" albibr
On Tue, Jan 29, 2013 at 1:00 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> This information was in the "Welcome to the group" message that was sent
> to you when you joined:
>
> "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."
>
>
> On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.net.br > wrote:
>
>>
>> I am new comer in this group. I am a brazilian user of the function
>> YF_PRICE() that requires the YF Quote addin. The only difference with the
>> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
>> indicate I am looking into the brazilian stock market
>>
>> I would like to use your function if possible could you please let me
>> know where I can download the addin and how do I introduce the RCHGetYahooQuotes()
>> in my spreadsheet
>>
>>
>
>
--
Alain
alain@bigio.net.br
> **
>
>
> This information was in the "Welcome to the group" message that was sent
> to you when you joined:
>
> "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."
>
>
> On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.
>
>>
>> I am new comer in this group. I am a brazilian user of the function
>> YF_PRICE() that requires the YF Quote addin. The only difference with the
>> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
>> indicate I am looking into the brazilian stock market
>>
>> I would like to use your function if possible could you please let me
>> know where I can download the addin and how do I introduce the RCHGetYahooQuotes(
>> in my spreadsheet
>>
>>
>
>
--
Alain
alain@bigio.
Tue Jan 29, 2013 9:16 am (PST) . Posted by:
"Alain Bigio" albibr
sorry i sent an email without message.
Thank you for the information . I will follow your instructions.
Alain
On Tue, Jan 29, 2013 at 1:00 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> This information was in the "Welcome to the group" message that was sent
> to you when you joined:
>
> "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."
>
>
> On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.net.br > wrote:
>
>>
>> I am new comer in this group. I am a brazilian user of the function
>> YF_PRICE() that requires the YF Quote addin. The only difference with the
>> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
>> indicate I am looking into the brazilian stock market
>>
>> I would like to use your function if possible could you please let me
>> know where I can download the addin and how do I introduce the RCHGetYahooQuotes()
>> in my spreadsheet
>>
>>
>
>
--
Alain
alain@bigio.net.br
Thank you for the information . I will follow your instructions.
Alain
On Tue, Jan 29, 2013 at 1:00 PM, Randy Harmelink rharmelink@gmail.
> **
>
>
> This information was in the "Welcome to the group" message that was sent
> to you when you joined:
>
> "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."
>
>
> On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.
>
>>
>> I am new comer in this group. I am a brazilian user of the function
>> YF_PRICE() that requires the YF Quote addin. The only difference with the
>> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
>> indicate I am looking into the brazilian stock market
>>
>> I would like to use your function if possible could you please let me
>> know where I can download the addin and how do I introduce the RCHGetYahooQuotes(
>> in my spreadsheet
>>
>>
>
>
--
Alain
alain@bigio.
Tue Jan 29, 2013 11:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Nope. It simply parses out the CSV file, as provided by Yahoo. Because
that's what that function does -- parse a CSV file.
The best solution is to avoid those data items that Yahoo doesn't provide
properly, like float.
On Tue, Jan 29, 2013 at 8:59 AM, bozo bozo@donandcarla.com > wrote:
>
> The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes
> do anything to flag this garbage data?
>
that's what that function does -- parse a CSV file.
The best solution is to avoid those data items that Yahoo doesn't provide
properly, like float.
On Tue, Jan 29, 2013 at 8:59 AM, bozo bozo@donandcarla.
>
> The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes
> do anything to flag this garbage data?
>
Wed Jan 30, 2013 12:10 am (PST) . Posted by:
"bozo" calhandon
Thank you Randy.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, January 29, 2013 12:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Nope. It simply parses out the CSV file, as provided by Yahoo. Because that's what that function does -- parse a CSV file.
The best solution is to avoid those data items that Yahoo doesn't provide properly, like float.
On Tue, Jan 29, 2013 at 8:59 AM, bozo bozo@donandcarla.com > wrote:
The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes do anything to flag this garbage data?
From: smf_addin@yahoogrou
Sent: Tuesday, January 29, 2013 12:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo CSV Feed Parameter List
Nope. It simply parses out the CSV file, as provided by Yahoo. Because that's what that function does -- parse a CSV file.
The best solution is to avoid those data items that Yahoo doesn't provide properly, like float.
On Tue, Jan 29, 2013 at 8:59 AM, bozo bozo@donandcarla.
The SMF display of returned data is a mess (sigh). Does SMFGetYahooQuotes do anything to flag this garbage data?
Tue Jan 29, 2013 8:34 am (PST) . Posted by:
"navelhunt" navelhunt
I am aware of the option to skip a row - and i have tried that, but subsquently putting in 1,2,etc into the appropriate field. However, this results in errors and i havent found a way to retrieve any data from subsequent rows.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Check out the documentation for the function -- there is a parameter for
> skipping rows.
>
> On Tue, Jan 29, 2013 at 4:02 AM, navelhunt wrote:
>
> > Hi Randy,
> > Am stuck trying to extract table data from the following link which is
> > used within morningstar.
> >
> >
> > http://insiders.morningstar.com/trading/insider-activity-data2.action?t=AVEO ®ion=USA&culture=en-us&pagesize=100
> >
> > So i can use smfgettagcontent with 4 find criteria, but this is not unique
> > enough as any of the row/column data in that table repeats sometimes, and
> > then the extraction doesnt flow through the page.
> >
> > So i tried rchgettablecell, however, i somehow cant seem to find a way to
> > go to the next row in this table.
> >
> > Wonder if you had any thoughts around how to jump to the next row on this
> > sort of layout.
> >
>
--- In smf_addin@yahoogrou
>
> Check out the documentation for the function -- there is a parameter for
> skipping rows.
>
> On Tue, Jan 29, 2013 at 4:02 AM, navelhunt wrote:
>
> > Hi Randy,
> > Am stuck trying to extract table data from the following link which is
> > used within morningstar.
> >
> >
> > http://insiders.
> >
> > So i can use smfgettagcontent with 4 find criteria, but this is not unique
> > enough as any of the row/column data in that table repeats sometimes, and
> > then the extraction doesnt flow through the page.
> >
> > So i tried rchgettablecell, however, i somehow cant seem to find a way to
> > go to the next row in this table.
> >
> > Wonder if you had any thoughts around how to jump to the next row on this
> > sort of layout.
> >
>
Tue Jan 29, 2013 11:39 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There's something strange about the way the table is coded...hmmm.
You can get the whole table with:
=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/insider-activity-data2.action?t=AVEO®ion=USA&culture=en-us&pagesize=100
",">Transaction",1,"",2)
...or, you'd need to use the smfGetTagContent() function repeatedly. For
example, to get the dates, you get the 15th, 23rd, 31st, etc, on TD table
cells, incrementing by 8, to pick up the dates. You can use the A tags to
get the name and title, and DIV tags to get the prices. And so forth.
Take a look at the smfGetTagContent-Quick-Webpage-Examination.xls workbook
I recently uploaded and try those tags, and you can see what data is out
there and what patterns it has.
On Tue, Jan 29, 2013 at 9:34 AM, navelhunt navelhunt@yahoo.com > wrote:
> I am aware of the option to skip a row - and i have tried that, but
> subsquently putting in 1,2,etc into the appropriate field. However, this
> results in errors and i havent found a way to retrieve any data from
> subsequent rows.
>
You can get the whole table with:
=RCHGetHTMLTable(
http://insiders.
","
...or, you'd need to use the smfGetTagContent(
example, to get the dates, you get the 15th, 23rd, 31st, etc, on TD table
cells, incrementing by 8, to pick up the dates. You can use the A tags to
get the name and title, and DIV tags to get the prices. And so forth.
Take a look at the smfGetTagContent-
I recently uploaded and try those tags, and you can see what data is out
there and what patterns it has.
On Tue, Jan 29, 2013 at 9:34 AM, navelhunt navelhunt@yahoo.
> I am aware of the option to skip a row - and i have tried that, but
> subsquently putting in 1,2,etc into the appropriate field. However, this
> results in errors and i havent found a way to retrieve any data from
> subsequent rows.
>
Tue Jan 29, 2013 9:42 am (PST) . Posted by:
"Steven" stevenletzer
In Google stock screener,I did a simple screen "All Exchanges" > "Utilities; and requested 3 data columns "Company Name", "Symbol" and "Current Ratio". This is the URL:
http://www.google.com/finance?ei=DQQIUfCqK5CklwPU0wE#stockscreener
In a 3x500 array I entered this formula:
RCHGetHTMLTable("http://www.google.com/finance?ei=DQQIUfCqK5CKlwPUOwE#stockscreener ",-1,"",1).
The result was #VALUE in each cell. Any Ideas?
http://www.google.
In a 3x500 array I entered this formula:
RCHGetHTMLTable(
The result was #VALUE in each cell. Any Ideas?
Tue Jan 29, 2013 11:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but the content on that web page is generated, so there's nothing in
the source code of the web page for the add-in to extract. Note that the
content dynamically changes as you alter the criteria, without a change in
the URL.
Also, the reason you got a #VALUE! error is because you're missing the
search string, so your parameters are of the wrong data type (i.e.
incorrect #VALUE!).
On Tue, Jan 29, 2013 at 10:35 AM, Steven stevenletzer@yahoo.com > wrote:
> In Google stock screener,I did a simple screen "All Exchanges" >
> "Utilities; and requested 3 data columns "Company Name", "Symbol" and
> "Current Ratio". This is the URL:
>
> http://www.google.com/finance?ei=DQQIUfCqK5CklwPU0wE#stockscreener
>
> In a 3x500 array I entered this formula:
> RCHGetHTMLTable("
> http://www.google.com/finance?ei=DQQIUfCqK5CKlwPUOwE#stockscreener
> ",-1,"",1).
>
> The result was #VALUE in each cell. Any Ideas?
>
the source code of the web page for the add-in to extract. Note that the
content dynamically changes as you alter the criteria, without a change in
the URL.
Also, the reason you got a #VALUE! error is because you're missing the
search string, so your parameters are of the wrong data type (i.e.
incorrect #VALUE!).
On Tue, Jan 29, 2013 at 10:35 AM, Steven stevenletzer@
> In Google stock screener,I did a simple screen "All Exchanges" >
> "Utilities; and requested 3 data columns "Company Name", "Symbol" and
> "Current Ratio". This is the URL:
>
> http://www.google.
>
> In a 3x500 array I entered this formula:
> RCHGetHTMLTable(
> http://www.google.
> ",-1,"
>
> The result was #VALUE in each cell. Any Ideas?
>
Wed Jan 30, 2013 6:20 am (PST) . Posted by:
"NicholasDavid" davidnicholas738
Please , where can I find the element list.
Wed Jan 30, 2013 6:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's the XLS file that was distributed in the ZIP archive that contained
the add-in....
On Wed, Jan 30, 2013 at 7:20 AM, NicholasDavid nicholasdavid@comcast.net >wrote:
>
> Please , where can I find the element list.
>
the add-in....
On Wed, Jan 30, 2013 at 7:20 AM, NicholasDavid nicholasdavid@
>
> Please , where can I find the element list.
>
Tidak ada komentar:
Posting Komentar