13 New Messages
Digest #2683
Messages
Sat Jul 6, 2013 6:03 am (PDT) . Posted by:
"smithjhhic" smithjhhic
ETFScreen data Elements (i.e. 1084) are not longer working for me. I was wondering if anyone else is having same error. Appreciate any help.
v/r,
Jeff
v/r,
Jeff
Sat Jul 6, 2013 8:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They were redirecting "http://etfscreen.com " URLs to "
http://www.etfscreen.com ", which caused it to stop working.
I updated the element definitions in file smf-elements-9.txt. The new file
is in the "Works in Progress" folder.
After updating that file in your SMF folder, you either need to exit and
restart EXCEL, or run the smfForceRecalculation macro (see LINKS area of
group for more info) to have it reload the element definitions.
On Sat, Jul 6, 2013 at 6:03 AM, smithjhhic <smithjhhic@yahoo.com > wrote:
> ETFScreen data Elements (i.e. 1084) are not longer working for me. I was
> wondering if anyone else is having same error. Appreciate any help.
>
http://www.etfscree
I updated the element definitions in file smf-elements-
is in the "Works in Progress" folder.
After updating that file in your SMF folder, you either need to exit and
restart EXCEL, or run the smfForceRecalculati
group for more info) to have it reload the element definitions.
On Sat, Jul 6, 2013 at 6:03 AM, smithjhhic <smithjhhic@yahoo.
> ETFScreen data Elements (i.e. 1084) are not longer working for me. I was
> wondering if anyone else is having same error. Appreciate any help.
>
Sat Jul 6, 2013 10:06 am (PDT) . Posted by:
"smithjhhic" smithjhhic
Randy,
Thank you very much for the update. Works great.
Jeff
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> They were redirecting "http://etfscreen.com " URLs to "
> http://www.etfscreen.com ", which caused it to stop working.
>
> I updated the element definitions in file smf-elements-9.txt. The new file
> is in the "Works in Progress" folder.
>
> After updating that file in your SMF folder, you either need to exit and
> restart EXCEL, or run the smfForceRecalculation macro (see LINKS area of
> group for more info) to have it reload the element definitions.
>
> On Sat, Jul 6, 2013 at 6:03 AM, smithjhhic <smithjhhic@...> wrote:
>
> > ETFScreen data Elements (i.e. 1084) are not longer working for me. I was
> > wondering if anyone else is having same error. Appreciate any help.
> >
>
Thank you very much for the update. Works great.
Jeff
--- In smf_addin@yahoogrou
>
> They were redirecting "http://etfscreen.
> http://www.etfscree
>
> I updated the element definitions in file smf-elements-
> is in the "Works in Progress" folder.
>
> After updating that file in your SMF folder, you either need to exit and
> restart EXCEL, or run the smfForceRecalculati
> group for more info) to have it reload the element definitions.
>
> On Sat, Jul 6, 2013 at 6:03 AM, smithjhhic <smithjhhic@
>
> > ETFScreen data Elements (i.e. 1084) are not longer working for me. I was
> > wondering if anyone else is having same error. Appreciate any help.
> >
>
Sat Jul 6, 2013 6:36 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
now it works.
it is quite surprising for me. It seems that when i search asian stock exchanges, there are always problems fully extracting the data
in another extraction in wall street journal, i have also problem extracting the full income statement, balance sheet and cash flow for example
http://quotes.wsj.com/HK/XHKG/2388?mod=DNH_S_cq
where only the special code ''?mod=DNH_S_cq'' causes improper extraction of the datas
do u have any idea what causes it?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>
now it works.
it is quite surprising for me. It seems that when i search asian stock exchanges, there are always problems fully extracting the data
in another extraction in wall street journal, i have also problem extracting the full income statement, balance sheet and cash flow for example
http://quotes.
where only the special code ''?mod=
do u have any idea what causes it?
--- In smf_addin@yahoogrou
>
> Reuters is often in update mode during the weekend, and since this is a
> 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@
>
> >
> > 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 8:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a clue. Sorry.
On Sat, Jul 6, 2013 at 6:36 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> in another extraction in wall street journal, i have also problem
> extracting the full income statement, balance sheet and cash flow for
> example
>
> http://quotes.wsj.com/HK/XHKG/2388?mod=DNH_S_cq
>
> where only the special code ''?mod=DNH_S_cq'' causes improper extraction
> of the datas
>
> do u have any idea what causes it?
>
On Sat, Jul 6, 2013 at 6:36 AM, weekeewawa <weekeewawa@yahoo.
>
> in another extraction in wall street journal, i have also problem
> extracting the full income statement, balance sheet and cash flow for
> example
>
> http://quotes.
>
> where only the special code ''?mod=
> of the datas
>
> do u have any idea what causes it?
>
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/
Uploaded by : rharmelink <rharmelink@gmail.
Description : Updated ETFScreen element definitions (changed http://etfscreen.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Sat Jul 6, 2013 11:56 am (PDT) . Posted by:
"gshell422" gshell422
How do I use SMF Add in to insert the latest price for specific market indices? I tried =RCHGetYahooQuotes("^DJI","l1")and it returns "Missing Symbols List". Any suggestions? also would like ^IXIC and ^GSPC.
Thanks
Thanks
Sat Jul 6, 2013 12:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
^IXIC and ^GSPC should work fine.
The ^DJI problem is because last year Dow Jones licensing agreements said
that Yahoo could no longer provide Dow Jones data in their CSV file format,
which is what the RCHGetYahooQuotes() and RCHGetYahooHistory() functions
use.
You can extract the ^DJI index data from their current quote web page, but
the means can vary depending on whether you are accessing it pre-market,
post-market, or during trading hours. And they seem to change the
presentation often enough that it's a pain to keep current.
I personally just stick to the ETF equivalents these days. Much easier to
deal with, are more easily traded, options are more easily accessible, and
they include the effects of dividends.
On Sat, Jul 6, 2013 at 11:53 AM, gshell422 <gshell422@yahoo.com > wrote:
> How do I use SMF Add in to insert the latest price for specific market
> indices? I tried =RCHGetYahooQuotes("^DJI","l1")and it returns "Missing
> Symbols List". Any suggestions? also would like ^IXIC and ^GSPC.
>
The ^DJI problem is because last year Dow Jones licensing agreements said
that Yahoo could no longer provide Dow Jones data in their CSV file format,
which is what the RCHGetYahooQuotes(
use.
You can extract the ^DJI index data from their current quote web page, but
the means can vary depending on whether you are accessing it pre-market,
post-market, or during trading hours. And they seem to change the
presentation often enough that it's a pain to keep current.
I personally just stick to the ETF equivalents these days. Much easier to
deal with, are more easily traded, options are more easily accessible, and
they include the effects of dividends.
On Sat, Jul 6, 2013 at 11:53 AM, gshell422 <gshell422@yahoo.
> How do I use SMF Add in to insert the latest price for specific market
> indices? I tried =RCHGetYahooQuotes(
> Symbols List". Any suggestions? also would like ^IXIC and ^GSPC.
>
Sat Jul 6, 2013 12:58 pm (PDT) . Posted by:
"gshell422" gshell422
Thank you for the quick reply. I use the indices simply as a historical reference in some of my files. I was able to get the ^IXIC and ^GSPC as you suggested. I would note the ^DJI works perfectly fine directly on Yahoo's web site. I then tried to get the DOW using:
=RCHGetElementNumber("$INDU",25). This returns a value of 14,988.55 from MSN which is the 'previous close' from July 3, rather than the last price of 15,135.84 (the close of July 5). Any suggestions?
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> ^IXIC and ^GSPC should work fine.
>
> The ^DJI problem is because last year Dow Jones licensing agreements said
> that Yahoo could no longer provide Dow Jones data in their CSV file format,
> which is what the RCHGetYahooQuotes() and RCHGetYahooHistory() functions
> use.
>
> You can extract the ^DJI index data from their current quote web page, but
> the means can vary depending on whether you are accessing it pre-market,
> post-market, or during trading hours. And they seem to change the
> presentation often enough that it's a pain to keep current.
>
> I personally just stick to the ETF equivalents these days. Much easier to
> deal with, are more easily traded, options are more easily accessible, and
> they include the effects of dividends.
>
> On Sat, Jul 6, 2013 at 11:53 AM, gshell422 <gshell422@...> wrote:
>
> > How do I use SMF Add in to insert the latest price for specific market
> > indices? I tried =RCHGetYahooQuotes("^DJI","l1")and it returns "Missing
> > Symbols List". Any suggestions? also would like ^IXIC and ^GSPC.
> >
>
=RCHGetElementNumbe
Thanks
--- In smf_addin@yahoogrou
>
> ^IXIC and ^GSPC should work fine.
>
> The ^DJI problem is because last year Dow Jones licensing agreements said
> that Yahoo could no longer provide Dow Jones data in their CSV file format,
> which is what the RCHGetYahooQuotes(
> use.
>
> You can extract the ^DJI index data from their current quote web page, but
> the means can vary depending on whether you are accessing it pre-market,
> post-market, or during trading hours. And they seem to change the
> presentation often enough that it's a pain to keep current.
>
> I personally just stick to the ETF equivalents these days. Much easier to
> deal with, are more easily traded, options are more easily accessible, and
> they include the effects of dividends.
>
> On Sat, Jul 6, 2013 at 11:53 AM, gshell422 <gshell422@
>
> > How do I use SMF Add in to insert the latest price for specific market
> > indices? I tried =RCHGetYahooQuotes(
> > Symbols List". Any suggestions? also would like ^IXIC and ^GSPC.
> >
>
Sat Jul 6, 2013 3:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, when MSN redesigned their print page last year, the changed
the definition of "Last Price" to be the previous day's close.
The Yahoo "Market Overview" page might be the easiest:
=RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview ",1,">Dow")
=RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview
",1,">NASDAQ")
=RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview ",1,">S&P
500")
On Sat, Jul 6, 2013 at 12:58 PM, gshell422 <gshell422@yahoo.com > wrote:
> Thank you for the quick reply. I use the indices simply as a historical
> reference in some of my files. I was able to get the ^IXIC and ^GSPC as you
> suggested. I would note the ^DJI works perfectly fine directly on Yahoo's
> web site. I then tried to get the DOW using:
> =RCHGetElementNumber("$INDU",25). This returns a value of 14,988.55 from
> MSN which is the 'previous close' from July 3, rather than the last price
> of 15,135.84 (the close of July 5). Any suggestions?
>
the definition of "Last Price" to be the previous day's close.
The Yahoo "Market Overview" page might be the easiest:
=RCHGetTableCell(
=RCHGetTableCell(
",1,"
=RCHGetTableCell(
500")
On Sat, Jul 6, 2013 at 12:58 PM, gshell422 <gshell422@yahoo.
> Thank you for the quick reply. I use the indices simply as a historical
> reference in some of my files. I was able to get the ^IXIC and ^GSPC as you
> suggested. I would note the ^DJI works perfectly fine directly on Yahoo's
> web site. I then tried to get the DOW using:
> =RCHGetElementNumbe
> MSN which is the 'previous close' from July 3, rather than the last price
> of 15,135.84 (the close of July 5). Any suggestions?
>
Sat Jul 6, 2013 8:19 pm (PDT) . Posted by:
"Jacob Jose" pepecan47
Is there any website that I can pull, using the SMF Add-In, the "S&P Quality Ranking" and "S&P Credit Ranking" for a stock?
Regards,
Jose L. Jacob
Regards,
Jose L. Jacob
Sat Jul 6, 2013 11:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
None that I know of. Anyone else know of a source?
On Sat, Jul 6, 2013 at 8:18 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> Is there any website that I can pull, using the SMF Add-In, the "S&P
> Quality Ranking" and "S&P Credit Ranking" for a stock?
>
On Sat, Jul 6, 2013 at 8:18 PM, Jacob Jose <pepecan47@yahoo.
>
> Is there any website that I can pull, using the SMF Add-In, the "S&P
> Quality Ranking" and "S&P Credit Ranking" for a stock?
>
Sat Jul 6, 2013 11:19 pm (PDT) . Posted by:
"T" thomas777crown
Thanks this worked perfectly.
Cheers
T
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Suppose we put the ticker symbol in cell B6. In cell C6, we can extract the
> sector code with:
>
> =smfStrExtr(smfGetTagContent("http://www.barchart.com/quotes/stocks/
> "&B6,"td",-1,
> "Market Cap","/stocks/sectors/"),"/sectors/","?sym=")
>
> Then, depending on which view of the sectors you want:
>
> =RCHGetHTMLTable("http://www.barchart.com/stocks/sectors/
> "&$C$6,">Links",-1,"",1)
> =RCHGetHTMLTable("http://www.barchart.com/stocks/sectors/
> "&$C$6&"?view=technical",">Links",-1,"",1)
> =RCHGetHTMLTable("http://www.barchart.com/stocks/sectors/
> "&$C$6&"?view=performance",">Links",-1,"",1)
> =RCHGetHTMLTable("http://www.barchart.com/stocks/sectors/
> "&$C$6&"?view=fundamental",">Links",-1,"",1)
>
> If you'd also like the name of the sector:
>
> =smfGetTagContent("http://www.barchart.com/quotes/stocks/ "&B6,"a",0,"Market
> Cap","/stocks/sectors/")
>
> On Thu, Jul 4, 2013 at 11:15 PM, T <thomas777crown@...> wrote:
>
> > 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.
> >
>
Cheers
T
--- In smf_addin@yahoogrou
>
> Suppose we put the ticker symbol in cell B6. In cell C6, we can extract the
> sector code with:
>
> =smfStrExtr(
> "&B6,"
> "Market Cap","
>
> Then, depending on which view of the sectors you want:
>
> =RCHGetHTMLTable(
> "&$C$6,
> =RCHGetHTMLTable(
> "&$C$6&"
> =RCHGetHTMLTable(
> "&$C$6&"
> =RCHGetHTMLTable(
> "&$C$6&"
>
> If you'd also like the name of the sector:
>
> =smfGetTagContent(
> Cap","
>
> On Thu, Jul 4, 2013 at 11:15 PM, T <thomas777crown@
>
> > 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
> > a highlighted link that says "Computer - Micro" for AAPL how do I retrieve
> > that information for other stocks as well.
> >
>
Tidak ada komentar:
Posting Komentar