5 New Messages
Digest #2682
Messages
Fri Jul 5, 2013 6:02 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Why not use this link and pull all the sector for a symbol, such as IBM or
any other
http://www.barchart.com/stocks/sectors/finder.php?sym=IBM
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of T
Sent: Friday, July 05, 2013 2:15 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Barchart Sectors
I'm looking to get the sectors for each stock that is listed on
barchart.com. An example of this would be
http://www.barchart.com/quotes/stocks/AAPL where it says sectors there is a
highlighted link that says "Computer - Micro" for AAPL how do I retrieve
that information for other stocks as well.
Thanks in advance,
Thomas
------------------------------------
Yahoo! Groups Links
any other
http://www.barchart
-----Original Message-----
From: smf_addin@yahoogrou
Of T
Sent: Friday, July 05, 2013 2:15 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Barchart Sectors
I'm looking to get the sectors for each stock that is listed on
barchart.com. An example of this would be
http://www.barchart
highlighted link that says "Computer - Micro" for AAPL how do I retrieve
that information for other stocks as well.
Thanks in advance,
Thomas
------------
Yahoo! Groups Links
Fri Jul 5, 2013 10:04 am (PDT) . Posted by:
"chrisksjdfsdlfhakljifsd" chrisksjdfsdlfhakljifsd
Hello,
I'm running a report for "big movers" close to when the market opens.
When using the function "=RCHGetYahooQuotes(SYMBOL,"l1")" I find that it takes 20-30 minutes after the market open for data to become accurate. After the initial wait it runs accurately for the day.
Is there a better function to use to get accurate information close to the open.
Thanks,
Chris
I'm running a report for "big movers" close to when the market opens.
When using the function "=RCHGetYahooQ
Is there a better function to use to get accurate information close to the open.
Thanks,
Chris
Fri Jul 5, 2013 10:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of the RCHGetYahooQuotes() are delayed unless you're paying for and
create the security cookies to be able to access Yahoo's real-time quotes
plan.
However, you can extract the real-time quotes from their web page, but it's
a much slower process than an array-entered RCHGetYahooQuotes(). And they
seem to change the web page coding, so what works one day may not work the
next.
Right now, this seems to work, for real-time last trade amount and time:
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
"&D3,"span",0,"yfs_l84_"))
=smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=
"&D3,"span",0,"yfs_t53_"),">","~")
...for a ticker symbol in cell D3.
On Fri, Jul 5, 2013 at 8:25 AM, chrisksjdfsdlfhakljifsd <
chris.ccmcma@gmail.com > wrote:
>
> I'm running a report for "big movers" close to when the market opens.
> When using the function "=RCHGetYahooQuotes(SYMBOL,"l1")" I find that it
> takes 20-30 minutes after the market open for data to become accurate.
> After the initial wait it runs accurately for the day.
>
> Is there a better function to use to get accurate information close to the
> open.
>
create the security cookies to be able to access Yahoo's real-time quotes
plan.
However, you can extract the real-time quotes from their web page, but it's
a much slower process than an array-entered RCHGetYahooQuotes(
seem to change the web page coding, so what works one day may not work the
next.
Right now, this seems to work, for real-time last trade amount and time:
=smfConvertData(
"&D3,"
=smfStrExtr(
"&D3,"
...for a ticker symbol in cell D3.
On Fri, Jul 5, 2013 at 8:25 AM, chrisksjdfsdlfhaklj
chris.ccmcma@
>
> I'm running a report for "big movers" close to when the market opens.
> When using the function "=RCHGetYahooQ
> takes 20-30 minutes after the market open for data to become accurate.
> After the initial wait it runs accurately for the day.
>
> Is there a better function to use to get accurate information close to the
> open.
>
Fri Jul 5, 2013 10:17 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
today, when i tried to extract data from reuters, it seems that no matter which format, rchgetelement or rchgettablecell,
tried most of the common stocks but
the results is an ERROR.
could it be some fault in the add in?
or reuters?
today, when i tried to extract data from reuters, it seems that no matter which format, rchgetelement or rchgettablecell,
tried most of the common stocks but
the results is an ERROR.
could it be some fault in the add in?
or reuters?
Sat Jul 6, 2013 1:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Reuters is often in update mode during the weekend, and since this is a
holiday weekend...
I just tried ticker MMM in SMF-Template-Reuters-Ratios-Comparison.xls, and
it appears to be working fine.
On Fri, Jul 5, 2013 at 10:17 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> today, when i tried to extract data from reuters, it seems that no matter
> which format, rchgetelement or rchgettablecell,
>
> tried most of the common stocks but
>
> the results is an ERROR.
>
> could it be some fault in the add in?
> or reuters?
>
holiday weekend...
I just tried ticker MMM in SMF-Template-
it appears to be working fine.
On Fri, Jul 5, 2013 at 10:17 PM, weekeewawa <weekeewawa@yahoo.
>
> today, when i tried to extract data from reuters, it seems that no matter
> which format, rchgetelement or rchgettablecell,
>
> tried most of the common stocks but
>
> the results is an ERROR.
>
> could it be some fault in the add in?
> or reuters?
>
Tidak ada komentar:
Posting Komentar