Kamis, 15 Desember 2011

[smf_addin] Digest Number 2047

Messages In This Digest (14 Messages)

1a.
Re: Gogle Results From: wu_ming_sg
1b.
Re: Gogle Results From: Randy Harmelink
1c.
Re: Gogle Results From: wu_ming_sg
1d.
Re: Gogle Results From: Randy Harmelink
1e.
Re: Gogle Results From: V. Shankar
2a.
Data Question From: GregL
2b.
Re: Data Question From: Mike McQuaid
2c.
Re: Data Question From: Randy Harmelink
2d.
Re: Data Question From: Martin Topper
2e.
Re: Data Question From: Greg Lundeen
2f.
Re: Data Question From: Greg Lundeen
2g.
Re: Data Question From: Greg Lundeen
3a.
Intraday data? From: Deborah
3b.
Re: Intraday data? From: Randy Harmelink

Messages

1a.

Re: Gogle Results

Posted by: "wu_ming_sg" nghongchong@hotmail.com   wu_ming_sg

Wed Dec 14, 2011 2:32 am (PST)



Hi,
This may be a bit off topic here but I need your expertise please..
If I have 50 stocks in a column with these formulas in another, excel
will hang at time. I suspect this is due to Google seeing too many links
at one time from one ip, and closing off the connection temporarily.
How can I make it eg. "calculate" 5 stocks and rest for a few seconds
before moving down to the next 5 stocks?
Thank you.

--- In smf_addin@yahoogroups.com, "wu_ming_sg" <nghongchong@...> wrote:
>
> Thank you ! It works :)
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink rharmelink@ wrote:
> >
> > Try something like:
> >
> > =0+smfStrExtr(smfGetTagContent("
> > https://www.google.com/search?q=psl%20holdings%20sgx",
> > "div",-1,">About"),"About "," results")
> >
> > On Tue, Dec 13, 2011 at 3:41 PM, wu_ming_sg nghongchong@ wrote:
> >
> > >
> > >
> > > Is it possible to use ur add-in to extract this info from the
below web
> > > link?
> > >
> > > http://www.google.com/search?q=psl%20holdings%20sgx
> > >
> > > I am looking at extracting the number of 484000 from "About
484,000
> > > results" please.
> > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
1b.

Re: Gogle Results

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Dec 14, 2011 5:47 am (PST)



Only way I can think of would be to use VBA...

On Wed, Dec 14, 2011 at 3:32 AM, wu_ming_sg <nghongchong@hotmail.com> wrote:

>
>
> This may be a bit off topic here but I need your expertise please..
>
> If I have 50 stocks in a column with these formulas in another, excel will
> hang at time.
> I suspect this is due to Google seeing too many links at one time from one
> ip, and closing off the connection temporarily.
>
> How can I make it eg. "calculate" 5 stocks and rest for a few seconds
> before moving down to the next 5 stocks?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
1c.

Re: Gogle Results

Posted by: "wu_ming_sg" nghongchong@hotmail.com   wu_ming_sg

Wed Dec 14, 2011 6:39 am (PST)



Hi,

Are you able to give me a sample please?

thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Only way I can think of would be to use VBA...
>
> On Wed, Dec 14, 2011 at 3:32 AM, wu_ming_sg <nghongchong@...> wrote:
>
> >
> >
> > This may be a bit off topic here but I need your expertise please..
> >
> > If I have 50 stocks in a column with these formulas in another, excel will
> > hang at time.
> > I suspect this is due to Google seeing too many links at one time from one
> > ip, and closing off the connection temporarily.
> >
> > How can I make it eg. "calculate" 5 stocks and rest for a few seconds
> > before moving down to the next 5 stocks?
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
1d.

Re: Gogle Results

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Dec 14, 2011 7:44 am (PST)



Sorry, but no.

On Wed, Dec 14, 2011 at 7:39 AM, wu_ming_sg <nghongchong@hotmail.com> wrote:

> Hi,
>
> Are you able to give me a sample please?
>
> thanks!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
1e.

Re: Gogle Results

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Wed Dec 14, 2011 8:23 am (PST)



don't we get basic details (msn money central) using standard excel web query in excel....it's 20 mins delayed but never gets slow...

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, December 14, 2011 7:17 PM
>Subject: Re: [smf_addin] Re: Gogle Results
>
>
> 
>Only way I can think of would be to use VBA...
>
>
>On Wed, Dec 14, 2011 at 3:32 AM, wu_ming_sg <nghongchong@hotmail.com> wrote:
>
>
>>
>>
>>This may be a bit off topic here but I need your expertise please..
>>
>>
>>If I have 50 stocks in a column with these formulas in another, excel will hang at time. 
>>I suspect this is due to Google seeing too many links at one time from one ip, and closing off the connection temporarily.
>>
>>
>>How can I make it eg.  "calculate" 5 stocks and rest for a few seconds before moving down to the next 5 stocks?
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
2a.

Data Question

Posted by: "GregL" lundeen@prtel.com   tortise_az

Wed Dec 14, 2011 10:01 am (PST)



I'm a new user and all seems to be working just fine. However, I notice a discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance and SMF Add-In, but many are not) What's up, here? Any ideas?

Thanks, GregL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2b.

Re: Data Question

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Wed Dec 14, 2011 10:13 am (PST)



It's the difference between the forward and trailing amounts. See Dividend
section at:

http://finance.yahoo.com/q/ks?s=ABC+Key+Statistics

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of GregL
Sent: Wednesday, December 14, 2011 11:43 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Data Question

I'm a new user and all seems to be working just fine. However, I notice a
discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it
shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance
and SMF Add-In, but many are not) What's up, here? Any ideas?

Thanks, GregL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: Data Question

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Dec 14, 2011 10:13 am (PST)



The $0.52 is an ESTIMATE of what the stock will pay as dividends into the
future. The $0.46 is what the stock HAS PAID as dividends over the past 12
months.

As far as I know, there is no Yahoo code to get the estimated dividend from
the Yahoo CSV interface. They just started carrying that data item in early
2010.

On Wed, Dec 14, 2011 at 9:43 AM, GregL <lundeen@prtel.com> wrote:

> I'm a new user and all seems to be working just fine. However, I notice a
> discrepancy in the data. Can anyone straighten me out:
>
> Here's the function: =RCHGetYahooQuotes("ABC", "d")
> This returns a value of .46 When I look at a quote on YAHOO Finance, it
> shows a dividend of .52
>
> This isn't an isolated case (some quotes are consistent between Y!Finance
> and SMF Add-In, but many are not) What's up, here? Any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2d.

Re: Data Question

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Wed Dec 14, 2011 10:14 am (PST)



$0.46 appears to be the sumn of the last 4 quarterly divs.

$0.52 appears to be the last quarter ($0.13) annualized  13 x 4 = 52

Marty

________________________________
From: GregL <lundeen@prtel.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, December 14, 2011 11:43 AM
Subject: [smf_addin] Data Question


 
I'm a new user and all seems to be working just fine. However, I notice a discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance and SMF Add-In, but many are not) What's up, here? Any ideas?

Thanks, GregL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2e.

Re: Data Question

Posted by: "Greg Lundeen" lundeen@prtel.com   tortise_az

Wed Dec 14, 2011 12:34 pm (PST)



Thanks! Sorry to make you do my research!

Greg

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Martin Topper
Sent: Wednesday, December 14, 2011 11:15 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Data Question

$0.46 appears to be the sumn of the last 4 quarterly divs.

$0.52 appears to be the last quarter ($0.13) annualized 13 x 4 = 52

Marty

_____

From: GregL <lundeen@prtel.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, December 14, 2011 11:43 AM
Subject: [smf_addin] Data Question

I'm a new user and all seems to be working just fine. However, I notice a discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance and SMF Add-In, but many are not) What's up, here? Any ideas?

Thanks, GregL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2f.

Re: Data Question

Posted by: "Greg Lundeen" lundeen@prtel.com   tortise_az

Wed Dec 14, 2011 12:36 pm (PST)



Thanks, Randy:

I assumed I was comparing apples to apples. You know what happens ….

Greg

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, December 14, 2011 11:14 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Data Question

The $0.52 is an ESTIMATE of what the stock will pay as dividends into the future. The $0.46 is what the stock HAS PAID as dividends over the past 12 months.

As far as I know, there is no Yahoo code to get the estimated dividend from the Yahoo CSV interface. They just started carrying that data item in early 2010.

On Wed, Dec 14, 2011 at 9:43 AM, GregL <lundeen@prtel.com> wrote:

I'm a new user and all seems to be working just fine. However, I notice a discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance and SMF Add-In, but many are not) What's up, here? Any ideas?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2g.

Re: Data Question

Posted by: "Greg Lundeen" lundeen@prtel.com   tortise_az

Wed Dec 14, 2011 12:38 pm (PST)



Thanks, Mike:

My stupidity.

Greg

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Mike McQuaid
Sent: Wednesday, December 14, 2011 11:13 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Data Question

It's the difference between the forward and trailing amounts. See Dividend
section at:

http://finance.yahoo.com/q/ks?s=ABC+Key+Statistics

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of GregL
Sent: Wednesday, December 14, 2011 11:43 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Data Question

I'm a new user and all seems to be working just fine. However, I notice a
discrepancy in the data. Can anyone straighten me out:

Here's the function: =RCHGetYahooQuotes("ABC", "d")
This returns a value of .46 When I look at a quote on YAHOO Finance, it
shows a dividend of .52

This isn't an isolated case (some quotes are consistent between Y!Finance
and SMF Add-In, but many are not) What's up, here? Any ideas?

Thanks, GregL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3a.

Intraday data?

Posted by: "Deborah" dcharlotte99@yahoo.com   dcharlotte99

Wed Dec 14, 2011 9:00 pm (PST)



I'd like to download historical intra-day data (20 min and 240 min) say the last 1 to 2 months of data for each of those timeframes. Anyone know a way either free or a paid service to do so?

I have access to eSignal, a paid service but not sure about reprogramming the add-in.

Thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: Intraday data?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Dec 14, 2011 9:54 pm (PST)



BarChart has free intraday data, but not for the length of time you want.
There's a template in the files area that can grab their quotes off of the
chart page.

On Wed, Dec 14, 2011 at 10:00 PM, Deborah <dcharlotte99@yahoo.com> wrote:

> I'd like to download historical intra-day data (20 min and 240 min) say
> the last 1 to 2 months of data for each of those timeframes. Anyone know a
> way either free or a paid service to do so?
>
> I have access to eSignal, a paid service but not sure about reprogramming
> the add-in.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)