9 New Messages
Digest #2933
Messages
Sat Jan 18, 2014 3:57 am (PST) . Posted by:
smortonm
I notice that the google workaround - which is 99% better than Yahoo - does not bring in mutual fund quotes. Is there a solution to this?
Thanks Again
Sid
Thanks Again
Sid
Sat Jan 18, 2014 7:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=
"&A1,"span",1,"price-panel";))
On Sat, Jan 18, 2014 at 4:57 AM, <smmarder@yahoo.com> wrote:
>
> I notice that the google workaround - which is 99% better than Yahoo -
> does not bring in mutual fund quotes. Is there a solution to this?
>
=smfConvertData(
"&A1,"
On Sat, Jan 18, 2014 at 4:57 AM, <smmarder@yahoo.
>
> I notice that the google workaround - which is 99% better than Yahoo -
> does not bring in mutual fund quotes. Is there a solution to this?
>
Sat Jan 18, 2014 7:20 am (PST) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Thanks for this. I was working on how to get my prices from Google instead of Yahoo.
When I try this line you gave on a regular stock ticker, I get back other characters in addition to the price.
<span/id"ref.656809 l">2.57
(This is for ticker: GURE and the current price is 2.57)
How does this need to be modified for a regular stock?
Thank you!
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, January 18, 2014 10:05 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Get Yahoo quotes
Try:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q="&A1,"span",1,"price-panel";))
On Sat, Jan 18, 2014 at 4:57 AM, <smmarder@yahoo.com> wrote:
I notice that the google workaround - which is 99% better than Yahoo - does not bring in mutual fund quotes. Is there a solution to this?
Thanks for this. I was working on how to get my prices from Google instead of Yahoo.
When I try this line you gave on a regular stock ticker, I get back other characters in addition to the price.
<span/id"ref.656809 l">2.57
(This is for ticker: GURE and the current price is 2.57)
How does this need to be modified for a regular stock?
Thank you!
Jim
From: smf_addin@yahoogrou
Sent: Saturday, January 18, 2014 10:05 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RE: Get Yahoo quotes
Try:
=smfConvertData(
On Sat, Jan 18, 2014 at 4:57 AM, <smmarder@yahoo.
I notice that the google workaround - which is 99% better than Yahoo - does not bring in mutual fund quotes. Is there a solution to this?
Sat Jan 18, 2014 7:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The formula I gave isn't intended for stocks and ETFs, just for mutual
funds. Google presents the prices differently.
You should use the previous formula in this thread for stocks and ETFs.
On Sat, Jan 18, 2014 at 8:20 AM, Jim Ranum <amt2100@gmail.com> wrote:
>
> Thanks for this. I was working on how to get my prices from Google instead
> of Yahoo.
>
> When I try this line you gave on a regular stock ticker, I get back other
> characters in addition to the price.
>
> <span/id"ref.656809 l">2.57
>
> (This is for ticker: GURE and the current price is 2.57)
>
>
>
> How does this need to be modified for a regular stock?
>
>
funds. Google presents the prices differently.
You should use the previous formula in this thread for stocks and ETFs.
On Sat, Jan 18, 2014 at 8:20 AM, Jim Ranum <amt2100@gmail.
>
> Thanks for this. I was working on how to get my prices from Google instead
> of Yahoo.
>
> When I try this line you gave on a regular stock ticker, I get back other
> characters in addition to the price.
>
> <span/id"ref.656809 l">2.57
>
> (This is for ticker: GURE and the current price is 2.57)
>
>
>
> How does this need to be modified for a regular stock?
>
>
Sat Jan 18, 2014 8:22 am (PST) . Posted by:
"Jim Ranum" amt2100
Sorry, I missed that post. The one post I was looking for!
Found it now and works great.
Thanks very much,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, January 18, 2014 10:45 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Get Yahoo quotes
The formula I gave isn't intended for stocks and ETFs, just for mutual funds. Google presents the prices differently.
You should use the previous formula in this thread for stocks and ETFs.
On Sat, Jan 18, 2014 at 8:20 AM, Jim Ranum <amt2100@gmail.com> wrote:
Thanks for this. I was working on how to get my prices from Google instead of Yahoo.
When I try this line you gave on a regular stock ticker, I get back other characters in addition to the price.
<span/id"ref.656809 l">2.57
(This is for ticker: GURE and the current price is 2.57)
How does this need to be modified for a regular stock?
Found it now and works great.
Thanks very much,
Jim
From: smf_addin@yahoogrou
Sent: Saturday, January 18, 2014 10:45 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RE: Get Yahoo quotes
The formula I gave isn't intended for stocks and ETFs, just for mutual funds. Google presents the prices differently.
You should use the previous formula in this thread for stocks and ETFs.
On Sat, Jan 18, 2014 at 8:20 AM, Jim Ranum <amt2100@gmail.
Thanks for this. I was working on how to get my prices from Google instead of Yahoo.
When I try this line you gave on a regular stock ticker, I get back other characters in addition to the price.
<span/id"ref.656809 l">2.57
(This is for ticker: GURE and the current price is 2.57)
How does this need to be modified for a regular stock?
Sat Jan 18, 2014 10:32 am (PST) . Posted by:
smortonm
Perfect!! As usual
Thanks
Sid
Thanks
Sid
Sat Jan 18, 2014 7:19 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The three sites you mention don't look good to me, nor fit your own
criteria...
-- divdata.com had no mutual fund data and an outdated ex-dividend date for
MMM
-- dividendchannel.com had a 6-month old ex-dividend date for SPY
-- dividend.com had a different extraction process for MMM and SPY, and no
mutual fund data
On Mon, Jan 13, 2014 at 11:47 AM, Kermit W. Prather <kermitp@tampabay.rr.com
> wrote:
>
> I am trying to pick up the Ex-dividend date but in searching the elements
> I see the only one for EX-Dividend date is
>
>
>
>
>
> 992
>
> S
>
> YahooKS
>
> Ex-Dividend Date
>
> SMF-Template-Yahoo-Key-Statistics.xls
>
>
>
> Unfortunately, Yahoo Key Statistics does not exist for all stocks, funds,
> preferred stocks, Ishares, and others
>
>
>
> Any chance you might add other Elements for retrieving Ex-Dividend Date?
>
> Dividata.com and dividendchannel.com are free sites that provide
> Ex-dividend dates. Both are excellent sites
>
> Dividend.com offers free and fee services, it also has the EX-dividend
> dates. I use both the premium and free services.
>
>
>
> I know I can pull the EX-Dividend dates with other features of the
> SMF-Addin but I'd like to eliminate having to do that.
>
>
>
> Thanks, Kermit
>
>
>
>
criteria...
-- divdata.com had no mutual fund data and an outdated ex-dividend date for
MMM
-- dividendchannel.
-- dividend.com had a different extraction process for MMM and SPY, and no
mutual fund data
On Mon, Jan 13, 2014 at 11:47 AM, Kermit W. Prather <kermitp@tampabay.
> wrote:
>
> I am trying to pick up the Ex-dividend date but in searching the elements
> I see the only one for EX-Dividend date is
>
>
>
>
>
> 992
>
> S
>
> YahooKS
>
> Ex-Dividend Date
>
> SMF-Template-
>
>
>
> Unfortunately, Yahoo Key Statistics does not exist for all stocks, funds,
> preferred stocks, Ishares, and others
>
>
>
> Any chance you might add other Elements for retrieving Ex-Dividend Date?
>
> Dividata.com and dividendchannel.
> Ex-dividend dates. Both are excellent sites
>
> Dividend.com offers free and fee services, it also has the EX-dividend
> dates. I use both the premium and free services.
>
>
>
> I know I can pull the EX-Dividend dates with other features of the
> SMF-Addin but I'd like to eliminate having to do that.
>
>
>
> Thanks, Kermit
>
>
>
>
Sat Jan 18, 2014 8:37 pm (PST) . Posted by:
cgrablew
I'm getting errors trying to retrieve elements 13879 - 13889 using RCHGetElementNumber. I suspect getting any data from Zacks maybe an issue. Are you aware of issues trying to retrieve these elements.
Thanks,
Chuck
Thanks,
Chuck
Sat Jan 18, 2014 8:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You will need the updated element definitions to get Zacks data. They
changed their website recently:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
Several of those elements were obsoleted.
On Sat, Jan 18, 2014 at 9:36 PM, <cgrablew@gmail.com> wrote:
>
> I'm getting errors trying to retrieve elements 13879 - 13889 using
> RCHGetElementNumber. I suspect getting any data from Zacks maybe an issue.
> Are you aware of issues trying to retrieve these elements.
>
>
>
changed their website recently:
https://groups.
Several of those elements were obsoleted.
On Sat, Jan 18, 2014 at 9:36 PM, <cgrablew@gmail.
>
> I'm getting errors trying to retrieve elements 13879 - 13889 using
> RCHGetElementNumber
> Are you aware of issues trying to retrieve these elements.
>
>
>
Tidak ada komentar:
Posting Komentar