9 Messages
Digest #3128
Messages
Tue Jul 22, 2014 6:18 am (PDT) . Posted by:
carmine288
Schwab rates approximately 300 of the largest stocks traded in the US and certain foreign nations. Is there an SMF excel that can extract such ratings?
Thanks,
Thanks,
Tue Jul 22, 2014 7:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It all depends on how the data is presented on the web page. Do you have a
sample URL?
On Tue, Jul 22, 2014 at 6:18 AM, carmine.nicoletta@...wrote:
> Schwab rates approximately 3000 of the largest stocks traded in the US
> and certain foreign nations. Is there an SMF excel that can extract such
> ratings?
>
sample URL?
On Tue, Jul 22, 2014 at 6:18 AM, carmine.nicoletta@
> Schwab rates approximately 3000 of the largest stocks traded in the US
> and certain foreign nations. Is there an SMF excel that can extract such
> ratings?
>
Tue Jul 22, 2014 9:22 am (PDT) . Posted by:
carmine288
I'm not sure the sample URL will work for you unless you have an account with Schwab. Do you?
Tue Jul 22, 2014 11:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No, sorry.
I did a search on the group's message archives. The last time the question
came up, those equity ratings were within a PDF document, not displayed on
a web page. So there was no way to extract.
On Tue, Jul 22, 2014 at 9:21 AM, carmine.nicoletta@...wrote:
>
> I'm not sure the sample URL will work for you unless you have an account
> with Schwab. Do you?
>
I did a search on the group's message archives. The last time the question
came up, those equity ratings were within a PDF document, not displayed on
a web page. So there was no way to extract.
On Tue, Jul 22, 2014 at 9:21 AM, carmine.nicoletta@
>
> I'm not sure the sample URL will work for you unless you have an account
> with Schwab. Do you?
>
Tue Jul 22, 2014 9:24 am (PDT) . Posted by:
"Nanci Kurtz" allegrobay100
Thank you so very much. What you've done is just incredible, not just for everyone.
________________________________
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, July 21, 2014 5:58 PM
Subject: Re: [smf_addin] Obsolete element #
Use the RCHGetYahooQuotes() function instead. It can get numerous items on up to 200 ticker symbols with a single Internet access. Much faster than scraping a price off a web page one ticker symbol at a time.
For example, to retrieve just the last traded price:
=RCHGetYahooQuotes("MMM","l1")
On Mon, Jul 21, 2014 at 5:04 PM, Nanci Kurtz nancikurtz@... wrote:
>
>I'm very new to this. Would you please share with me the new element # for "last price" (#25) or closing price? I've searched all over and just cannot figure this out.
>
________________________________
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, July 21, 2014 5:58 PM
Subject: Re: [smf_addin] Obsolete element #
Use the RCHGetYahooQuotes(
For example, to retrieve just the last traded price:
=RCHGetYahooQuotes(
On Mon, Jul 21, 2014 at 5:04 PM, Nanci Kurtz nancikurtz@.
>
>I'm very new to this. Would you please share with me the new element # for "last price" (#25) or closing price? I've searched all over and just cannot figure this out.
>
Tue Jul 22, 2014 10:30 am (PDT) . Posted by:
tcdriscoll
Hello RCH users,
I'm trying to pull tables directly from sec filings using the GetHTMLTable command, but I can't get it to work. I can get the same command to work on Yahoo and Google finance pages, and I've been using other RCH commands for a few years, so I believe my installation is working correctly.
I viewed the source of the page from the sec edgar archives (http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm#s2F6446A8FFFB337AE9678F806B3D9E56), and the header states the doc type is html public. I viewed the source of this page to confirm where the <table and </table codes are located in the html, and used a unique text string within my table of interest to Find Begin. Begin Direction and End Direction are -1 and 1, respectively. Trying to keep it simple just to show that I can pull a table, but I get nothing in my excel sheet.
Any suggestions or input appreciated.
tom
I'm trying to pull tables directly from sec filings using the GetHTMLTable command, but I can't get it to work. I can get the same command to work on Yahoo and Google finance pages, and I've been using other RCH commands for a few years, so I believe my installation is working correctly.
I viewed the source of the page from the sec edgar archives (http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm#s2F6446A8FFFB337AE9678F806B3D9E56), and the header states the doc type is html public. I viewed the source of this page to confirm where the <table and </table codes are located in the html, and used a unique text string within my table of interest to Find Begin. Begin Direction and End Direction are -1 and 1, respectively. Trying to keep it simple just to show that I can pull a table, but I get nothing in my excel sheet.
Any suggestions or input appreciated.
tom
Tue Jul 22, 2014 11:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I was able to extract a table with:
=RCHGetHTMLTable("
http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm",">Current
Assets",-1,"",1)
Note that your URL below contains a positional indicator -- the "#" and
everything that follows. The protocol the add-in calls to retrieve data
from the Internet doesn't typically work right with those. So I tried it
without it, and it worked fine.
On Tue, Jul 22, 2014 at 10:30 AM, tcdriscoll@... wrote:
>
> I'm trying to pull tables directly from sec filings using the GetHTMLTable
> command, but I can't get it to work. I can get the same command to work on
> Yahoo and Google finance pages, and I've been using other RCH commands for
> a few years, so I believe my installation is working correctly.
>
> I viewed the source of the page from the sec edgar archives (
> http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm#s2F6446A8FFFB337AE9678F806B3D9E56),
> and the header states the doc type is html public. I viewed the source of
> this page to confirm where the <table and </table codes are located in the
> html, and used a unique text string within my table of interest to Find
> Begin. Begin Direction and End Direction are -1 and 1, respectively. Trying
> to keep it simple just to show that I can pull a table, but I get nothing
> in my excel sheet.
>
=RCHGetHTMLTable("
http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm",">Current
Assets",-1,"",1)
Note that your URL below contains a positional indicator -- the "#" and
everything that follows. The protocol the add-in calls to retrieve data
from the Internet doesn't typically work right with those. So I tried it
without it, and it worked fine.
On Tue, Jul 22, 2014 at 10:30 AM, tcdriscoll@... wrote:
>
> I'm trying to pull tables directly from sec filings using the GetHTMLTable
> command, but I can't get it to work. I can get the same command to work on
> Yahoo and Google finance pages, and I've been using other RCH commands for
> a few years, so I believe my installation is working correctly.
>
> I viewed the source of the page from the sec edgar archives (
> http://www.sec.gov/Archives/edgar/data/913077/000091307714000017/affx-20140331x10q.htm#s2F6446A8FFFB337AE9678F806B3D9E56),
> and the header states the doc type is html public. I viewed the source of
> this page to confirm where the <table and </table codes are located in the
> html, and used a unique text string within my table of interest to Find
> Begin. Begin Direction and End Direction are -1 and 1, respectively. Trying
> to keep it simple just to show that I can pull a table, but I get nothing
> in my excel sheet.
>
Tue Jul 22, 2014 11:53 am (PDT) . Posted by:
tcdriscoll
Thanks Randy. Yep, worked for me too. My mistake was I copied the url from the source code tab, not the original url. Stupid mistake, thanks much for the help.
tom
tom
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar