11 Messages
Digest #3029
Messages
Tue Apr 1, 2014 4:48 am (PDT) . Posted by:
lawleesh
Hi Randy I use smfPricesbydate to download prices from Yahoo. Some stock prices are not available in Yahoo but available in Google Finance. For example,
https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE
Is there a way to use a similar function to extract Google stock prices?
regards
LL
https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE
Is there a way to use a similar function to extract Google stock prices?
regards
LL
Tue Apr 1, 2014 5:08 am (PDT) . Posted by:
mikemcq802
The ticker for that on Yahoo is different. Try:
http://finance.yahoo.com/q?s=Q1P.SI&ql=1 http://finance.yahoo.com/q?s=Q1P.SI&ql=1
http://finance.yahoo.com/q?s=Q1P.SI&ql=1 http://finance.yahoo.com/q?s=Q1P.SI&ql=1
Tue Apr 1, 2014 5:17 am (PDT) . Posted by:
lawleesh
Hi Mike When I click on historical prices, it says not available.
http://finance.yahoo.com/q/hp?s=Q1P.SI+Historical+Prices http://finance.yahoo.com/q/hp?s=Q1P.SI+Historical+Prices
Therefore, was wondering if the smfPricesbydate or similar function could use Google data instead.
regards
LL
http://finance.yahoo.com/q/hp?s=Q1P.SI+Historical+Prices http://finance.yahoo.com/q/hp?s=Q1P.SI+Historical+Prices
Therefore, was wondering if the smfPricesbydate or similar function could use Google data instead.
regards
LL
Tue Apr 1, 2014 5:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to do it yourself, with general add-in functions. Normally, I
would refer you here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
However, Google doesn't carry a CSV file for the equity you cite. That is,
if you look here:
https://www.google.com/finance/historical?q=MMM
...you'll see a "Download to Spreadsheet" option over on the right hand
side of the page. Your ticker symbol, SGX:Q1P, has no "Download to
Spreadsheet" option. That means you'd need to get the historical quotes by
pulling them off of the web pages.
So, to simulate smfPricesByDates(), you'd need to get each daily quote, one
at a time. For example, to get the closing quotes as of 2013-04-07:
=smfConvertData(smfGetTagContent("
https://www.google.com/finance/historical?q=SGX:Q1P&startdate=Mar+31,+2013&enddate=Apr+7,+2013
","td",5,">Date","<tr"))
Note that 2013-04-07 was not an actual trading date. That's why I set the
"startdate" 1 week earlier, so I was sure to get quotes. If I had set the
"startdate" and "enddate" to 4013-04-07, I wouldn't have found any data.
If you put the date in cell F7, you could create the URL with the TEXT()
function, as follows:
=smfConvertData(smfGetTagContent("
https://www.google.com/finance/historical?q=SGX:Q1P&startdate=
"&TEXT(F7-7,"mmm+d,+yyyy")&"&enddate="&TEXT(F7,"mmm+d,+yyyy"),"td",5,">Date","<tr"))
Also note that means one Internet access for each historical quote, while
smfPricesByDates() would get a number of historical quotes with one
Internet access.
On Tue, Apr 1, 2014 at 4:48 AM, <lawrence.leesh@gmail.com> wrote:
> I use smfPricesbydate to download prices from Yahoo. Some stock prices
> are not available in Yahoo but available in Google Finance. For example,
>
> https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE
> Is there a way to use a similar function to extract Google stock prices?
>
>
would refer you here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
However, Google doesn't carry a CSV file for the equity you cite. That is,
if you look here:
https://www.google.com/finance/historical?q=MMM
...you'll see a "Download to Spreadsheet" option over on the right hand
side of the page. Your ticker symbol, SGX:Q1P, has no "Download to
Spreadsheet" option. That means you'd need to get the historical quotes by
pulling them off of the web pages.
So, to simulate smfPricesByDates(), you'd need to get each daily quote, one
at a time. For example, to get the closing quotes as of 2013-04-07:
=smfConvertData(smfGetTagContent("
https://www.google.com/finance/historical?q=SGX:Q1P&startdate=Mar+31,+2013&enddate=Apr+7,+2013
","td",5,">Date","<tr"))
Note that 2013-04-07 was not an actual trading date. That's why I set the
"startdate" 1 week earlier, so I was sure to get quotes. If I had set the
"startdate" and "enddate" to 4013-04-07, I wouldn't have found any data.
If you put the date in cell F7, you could create the URL with the TEXT()
function, as follows:
=smfConvertData(smfGetTagContent("
https://www.google.com/finance/historical?q=SGX:Q1P&startdate=
"&TEXT(F7-7,"mmm+d,+yyyy")&"&enddate="&TEXT(F7,"mmm+d,+yyyy"),"td",5,">Date","<tr"))
Also note that means one Internet access for each historical quote, while
smfPricesByDates() would get a number of historical quotes with one
Internet access.
On Tue, Apr 1, 2014 at 4:48 AM, <lawrence.leesh@gmail.com> wrote:
> I use smfPricesbydate to download prices from Yahoo. Some stock prices
> are not available in Yahoo but available in Google Finance. For example,
>
> https://www.google.com/finance/historical?q=SGX%3AQ1P&ei=c6Y6U5ikG8KMkgXKtAE
> Is there a way to use a similar function to extract Google stock prices?
>
>
Tue Apr 1, 2014 5:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Still no historical quotes though...
On Tue, Apr 1, 2014 at 5:07 AM, <mikemcq802@yahoo.com> wrote:
>
> The ticker for that on Yahoo is different. Try:
> http://finance.yahoo.com/q?s=Q1P.SI&ql=1
>
On Tue, Apr 1, 2014 at 5:07 AM, <mikemcq802@yahoo.com> wrote:
>
> The ticker for that on Yahoo is different. Try:
> http://finance.yahoo.com/q?s=Q1P.SI&ql=1
>
Tue Apr 1, 2014 6:20 am (PDT) . Posted by:
lawleesh
Hi Randy Was a daunting task but followed your detailed instructions and managed to do it.
Many thanks
LL
Many thanks
LL
Tue Apr 1, 2014 11:53 am (PDT) . Posted by:
"Darryl Bonfessuto"
Hello Randy,
Where can I find manual/codes/abrev for different parameters ie % change, PE… etc.. in excel
Thanks
Darryl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 01, 2014 8:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: historical stock prices
Still no historical quotes though...
On Tue, Apr 1, 2014 at 5:07 AM, <mikemcq802@yahoo.com <mailto:mikemcq802@yahoo.com> > wrote:
The ticker for that on Yahoo is different. Try:
http://finance.yahoo.com/q?s=Q1P.SI <http://finance.yahoo.com/q?s=Q1P.SI&ql=1> &ql=1
Where can I find manual/codes/abrev for different parameters ie % change, PE… etc.. in excel
Thanks
Darryl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 01, 2014 8:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: historical stock prices
Still no historical quotes though...
On Tue, Apr 1, 2014 at 5:07 AM, <mikemcq802@yahoo.com <mailto:mikemcq802@yahoo.com> > wrote:
The ticker for that on Yahoo is different. Try:
http://finance.yahoo.com/q?s=Q1P.SI <http://finance.yahoo.com/q?s=Q1P.SI&ql=1> &ql=1
Tue Apr 1, 2014 12:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of the documentation has been moved to the web site:
http://ogres-crypt.com/SMF/Documentation/#Yahoo
Sounds like you're asking about the RCHGetYahooQuotes() function...
On Tue, Apr 1, 2014 at 11:15 AM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> Hello Randy,
>
> Where can I find manual/codes/abrev for different parameters ie %
> change, PE… etc.. in excel
>
>
>
> Thanks
>
> Darryl
>
http://ogres-crypt.com/SMF/Documentation/#Yahoo
Sounds like you're asking about the RCHGetYahooQuotes() function...
On Tue, Apr 1, 2014 at 11:15 AM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> Hello Randy,
>
> Where can I find manual/codes/
> change, PE… etc.. in excel
>
>
>
> Thanks
>
> Darryl
>
Tue Apr 1, 2014 12:35 pm (PDT) . Posted by:
"Darryl Bonfessuto"
Yes Randy
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 01, 2014 3:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: historical stock prices
All of the documentation has been moved to the web site:
http://ogres-crypt.com/SMF/Documentation/#Yahoo
Sounds like you're asking about the RCHGetYahooQuotes() function...
On Tue, Apr 1, 2014 at 11:15 AM, Darryl Bonfessuto <dmb7111@gmail.com <mailto:dmb7111@gmail.com> > wrote:
Hello Randy,
Where can I find manual/codes/abrev for different parameters ie % change, PE… etc.. in excel
Thanks
Darryl
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 01, 2014 3:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: historical stock prices
All of the documentation has been moved to the web site:
http://ogres-crypt.com/SMF/Documentation/#Yahoo
Sounds like you're asking about the RCHGetYahooQuotes() function...
On Tue, Apr 1, 2014 at 11:15 AM, Darryl Bonfessuto <dmb7111@gmail.com <mailto:dmb7111@gmail.com> > wrote:
Hello Randy,
Where can I find manual/codes/
Thanks
Darryl
Tue Apr 1, 2014 4:25 pm (PDT) . Posted by:
jharlan
Anyone know how I can use the "=RCHGetHTMLtable()" to obtain patent data from Google Patents?
Specifically, I'm interested in pulling in title, various dates, etc.
Maybe this is the right function and/or right forum.
Thanks in advance, Jim
Specifically, I'm interested in pulling in title, various dates, etc.
Maybe this is the right function and/or right forum.
Thanks in advance, Jim
Tue Apr 1, 2014 4:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
More details, please. Sample URL?
RCHGetHTMLTable() doesn't work on some of the tables on Google Finance
pages, because they don't completely code all of the table tags.
On Tue, Apr 1, 2014 at 4:25 PM, <jharlan@yahoo.com> wrote:
>
> Anyone know how I can use the "=RCHGetHTMLtable()" to obtain patent data
> from Google Patents?
>
> Specifically, I'm interested in pulling in title, various dates, etc.
>
> Maybe this is the right function and/or right forum.
>
>
RCHGetHTMLTable() doesn't work on some of the tables on Google Finance
pages, because they don't completely code all of the table tags.
On Tue, Apr 1, 2014 at 4:25 PM, <jharlan@yahoo.com> wrote:
>
> Anyone know how I can use the "=RCHGetHTMLta
> from Google Patents?
>
> Specifically, I'm interested in pulling in title, various dates, etc.
>
> Maybe this is the right function and/or right forum.
>
>
Tidak ada komentar:
Posting Komentar