Messages In This Digest (24 Messages)
- 1a.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Ron
- 1b.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: sihlai
- 1c.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Randy Harmelink
- 2a.
- smfGetOptionQuotes gets wrong data From: Glen
- 2b.
- Re: smfGetOptionQuotes gets wrong data From: Randy Harmelink
- 2c.
- Re: smfGetOptionQuotes gets wrong data From: Glen Fullmer
- 3a.
- Issue with Excel 2010 and this ADD in From: tim.wisniewski
- 3b.
- Re: Issue with Excel 2010 and this ADD in From: Glen Fullmer
- 4a.
- Morningstar Premium Porfolio Holdings From: Steven
- 4b.
- Re: Morningstar Premium Porfolio Holdings From: Randy Harmelink
- 4c.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4d.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4e.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4f.
- Re: Morningstar Premium Porfolio Holdings From: Randy Harmelink
- 4g.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4h.
- Re: Morningstar Premium Porfolio Holdings From: Randy Harmelink
- 4i.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4j.
- Re: Morningstar Premium Porfolio Holdings From: Steven
- 4k.
- Re: Morningstar Premium Porfolio Holdings From: Randy Harmelink
- 5a.
- Re: smfPricesByDates showing $505,480,256 for today's price From: Martin Topper
- 6a.
- getyahhooquotes dividend code d From: chj.2010
- 6b.
- Re: getyahhooquotes dividend code d From: Randy Harmelink
- 7a.
- how to use smfForecRecalculation macro? From: cocoaacc
- 7b.
- Re: how to use smfForecRecalculation macro? From: Randy Harmelink
Messages
- 1a.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Ron" ronaldj309@cox.net ronaldj309
Wed Jul 20, 2011 4:46 am (PDT)
As I posted earlier: Feel confident the problem is with YAHOO. I use PSM (Personal Stock Monitor) from DTlink. It also gets data from YAHOO and has had the same bad data problem recently. Perhaps someone(s) are abusing the capacity of the YAHOO servers?
--- In smf_addin@yahoogroups.com , "bizmark_ee" <markpadden@...> wrote:
>
> Does using an array formula help anyone currently with this problem? It does not for me. I get it with both array and single-cell formulas, and with both large sheets and tiny (one request) sheets. So there appears to be a genuine problem in the way the add-in is receiving data from Yahoo.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > It might help to do an array-entered formula for all of the data instead of
> > doing individual functions. Yahoo may be doing something on their side if
> > there are too many requests within a short time frame? A few people in the
> > past with problems have found this solved the problems, in addition to
> > making the worksheet run much faster.
> >
> > Also check out item 9.4.2 in the "Links" area of the group.
> >
> > On Sun, Jul 17, 2011 at 8:39 AM, smortonm <smmarder@> wrote:
> >
> > > I am having the same problem which continues to today. When I cut and paste
> > > the =RCHGetYahooQuotes function into the problem cell, it corrects. But many
> > > cell are having the problem. I am sure many others are experiencing this
> > > issue.
> > > Sid
> > >
> >
>
- 1b.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "sihlai" sihlai@yahoo.ca sihlai
Wed Jul 20, 2011 5:35 pm (PDT)
Is there another solution to obtaining quotes from MSN for ETF?
- 1c.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 7:19 pm (PDT)
You could try:
=0+smfGetTagContent("
http://investing.money.msn. com/investments/ etf-list/ ?symbol=
"&Ticker,"span",-1,"'Last' ")
...but I'm not sure how reliable the search string is.
On Wed, Jul 20, 2011 at 5:35 PM, sihlai <sihlai@yahoo.ca > wrote:
> Is there another solution to obtaining quotes from MSN for ETF?
>
- 2a.
-
smfGetOptionQuotes gets wrong data
Posted by: "Glen" gfullmer@cox.net gfullmer
Wed Jul 20, 2011 5:14 am (PDT)
I am getting the wrong quote for:
=smfGetOptionQuotes("ADBE JAN 2012 $35 Put","b",0," Y")
Getting 5.35 vs 6.10 as of Thursday, Jul 14th at 10:30am MST
It appears that the 5.35 is for the ABBE JAN 2012 $34 Put.
This spreadsheet was working previously but now is getting wrong numbers. Ideas?
Glen
- 2b.
-
Re: smfGetOptionQuotes gets wrong data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 8:11 am (PDT)
Possibly -- see items 9.4.2 and 9.5 in the "Links" area of the group.
I just tried your formula here and got the correct quote.
On Thu, Jul 14, 2011 at 10:32 AM, Glen <gfullmer@cox.net > wrote:
> I am getting the wrong quote for:
>
> =smfGetOptionQuotes("ADBE JAN 2012 $35 Put","b",0," Y")
>
> Getting 5.35 vs 6.10 as of Thursday, Jul 14th at 10:30am MST
>
> It appears that the 5.35 is for the ABBE JAN 2012 $34 Put.
>
> This spreadsheet was working previously but now is getting wrong numbers.
> Ideas?
>
- 2c.
-
Re: smfGetOptionQuotes gets wrong data
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Wed Jul 20, 2011 9:17 am (PDT)
On Wed, 2011-07-20 at 08:08 -0700, Randy Harmelink wrote:
>
> Possibly -- see items 9.4.2 and 9.5 in the "Links" area of the group.
It works and you already solved the problem! ;-)
It appears that a post that I posted to the group via the web page last
Thursday just got posted! ;-)
Thanks again, Glen
- 3a.
-
Issue with Excel 2010 and this ADD in
Posted by: "tim.wisniewski" twiztidfreaksho2@hotmail.com tim.wisniewski
Wed Jul 20, 2011 8:03 am (PDT)
I am having an issue with Excel 2010 and this add in. Whenever I try to pull new data I just get ####### in all the data fields. Can anyone Help?
- 3b.
-
Re: Issue with Excel 2010 and this ADD in
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Wed Jul 20, 2011 9:01 am (PDT)
On Wed, 2011-07-20 at 14:09 +0000, tim.wisniewski wrote:
>
> I am having an issue with Excel 2010 and this add in. Whenever I try
> to pull new data I just get ####### in all the data fields. Can anyone
> Help?
Try expanding the field and then tell us what you get.
- 4a.
-
Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 1:21 pm (PDT)
I am trying to use RCHGetHTMLTable to capture the portfolios for closed end funds, both basic and premium holdings for all 100 positions.
This is an example for the symbol AOD
http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
Any ideas?
- 4b.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 1:35 pm (PDT)
Good news and bad news.
Bad news -- the tables on the web page are produced dynamically, so the data
is not within the source code of the web page for the add-in to extract the
data from.
Good news -- this appears to get the file available from the export button
on the web page:
=smfGetCSVFile("
http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
")
On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@yahoo.com > wrote:
> I am trying to use RCHGetHTMLTable to capture the portfolios for closed end
> funds, both basic and premium holdings for all 100 positions.
>
> This is an example for the symbol AOD
>
> http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
>
> Any ideas?
>
- 4c.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 1:39 pm (PDT)
How did you enter the formula? Only the word holdings was returned when I enterest the formula in a cell.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Good news and bad news.
>
> Bad news -- the tables on the web page are produced dynamically, so the data
> is not within the source code of the web page for the add-in to extract the
> data from.
>
> Good news -- this appears to get the file available from the export button
> on the web page:
>
> =smfGetCSVFile("
> http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
> ")
>
> On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@...> wrote:
>
> > I am trying to use RCHGetHTMLTable to capture the portfolios for closed end
> > funds, both basic and premium holdings for all 100 positions.
> >
> > This is an example for the symbol AOD
> >
> > http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
> >
> > Any ideas?
> >
>
- 4d.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 1:43 pm (PDT)
Figured it out thanks.
--- In smf_addin@yahoogroups.com , "Steven" <stevenletzer@...> wrote:
>
> How did you enter the formula? Only the word holdings was returned when I enterest the formula in a cell.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Good news and bad news.
> >
> > Bad news -- the tables on the web page are produced dynamically, so the data
> > is not within the source code of the web page for the add-in to extract the
> > data from.
> >
> > Good news -- this appears to get the file available from the export button
> > on the web page:
> >
> > =smfGetCSVFile("
> > http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
> > ")
> >
> > On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@> wrote:
> >
> > > I am trying to use RCHGetHTMLTable to capture the portfolios for closed end
> > > funds, both basic and premium holdings for all 100 positions.
> > >
> > > This is an example for the symbol AOD
> > >
> > > http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
> > >
> > > Any ideas?
> > >
> >
>
- 4e.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 1:54 pm (PDT)
I figured it out when AOD was the referenced symbol. But could not make it work when the fund symbol was a variable in a cell. For example in cell B2=AOD
smfGetCSVFile("http://portfolios. morningstar. "&$B$2&exportType=com/fund/ holdingsExport? t= details") Obviously I have "" incorrect, but how would it work?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Good news and bad news.
>
> Bad news -- the tables on the web page are produced dynamically, so the data
> is not within the source code of the web page for the add-in to extract the
> data from.
>
> Good news -- this appears to get the file available from the export button
> on the web page:
>
> =smfGetCSVFile("
> http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
> ")
>
> On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@...> wrote:
>
> > I am trying to use RCHGetHTMLTable to capture the portfolios for closed end
> > funds, both basic and premium holdings for all 100 positions.
> >
> > This is an example for the symbol AOD
> >
> > http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
> >
> > Any ideas?
> >
>
- 4f.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 1:58 pm (PDT)
Works fine for me -- I suspect you have some type of issue with the
concatenation. Usually in such cases, I rearrange the URL parameters so the
ticker is the last thing, as it makes it easier to do the concatenation. For
example:
=smfGetCSVFile("
http://portfolios.morningstar. com/fund/ holdingsExport? exportType= details&t=
"&B2)
...which works for me when B2 contains AOD. However, there could be
something going on at Morningstar that would mean another symbol may not
work -- for example, the export file may be created when you GO to the web
page. The add-in might bypass that process by trying to go directly to a
file that hasn't been created. But I don't know of any other ticker symbols
to test with.
On Wed, Jul 20, 2011 at 1:53 PM, Steven <stevenletzer@yahoo.com > wrote:
> I figured it out when AOD was the referenced symbol. But could not make it
> work when the fund symbol was a variable in a cell. For example in cell
> B2=AOD
>
> smfGetCSVFile("http://portfolios. morningstar. "&$B$2&exportType=com/fund/ holdingsExport? t= details")
> Obviously I have "" incorrect, but how would it work?
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Good news and bad news.
> >
> > Bad news -- the tables on the web page are produced dynamically, so the
> data
> > is not within the source code of the web page for the add-in to extract
> the
> > data from.
> >
> > Good news -- this appears to get the file available from the export
> button
> > on the web page:
> >
> > =smfGetCSVFile("
> >
> http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
> > ")
> >
> > On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@...> wrote:
> >
> > > I am trying to use RCHGetHTMLTable to capture the portfolios for closed
> end
> > > funds, both basic and premium holdings for all 100 positions.
> > >
> > > This is an example for the symbol AOD
> > >
> > >
> http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
> > >
> > > Any ideas?
> > >
> >
>
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
- 4g.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 2:17 pm (PDT)
I changed the symbol to UTG and it worked. But the details on the basic web page provides these columns
Holdings, Ticker, Sector, Style, % Portfolio Weight, Shares Owned, Shares Change, Latest Analyst Report, Country, YTD Return, %P/E
The formula returns these columns: Holdings, Weightings, Type, Ticker, Shares Owned,Shares Change, Sector, Price, Day Change,Day high/low, Volume
I am looking to determine the specific countries to avoid the PIGS part of the Eurozone. Therefore I need the country. Do you have another way either with Morningstar or a different source? Morningstar provides the region breakdown, but not a summary of the country breakdown.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Works fine for me -- I suspect you have some type of issue with the
> concatenation. Usually in such cases, I rearrange the URL parameters so the
> ticker is the last thing, as it makes it easier to do the concatenation. For
> example:
>
> =smfGetCSVFile("
> http://portfolios.morningstar. com/fund/ holdingsExport? exportType= details&t=
> "&B2)
>
> ...which works for me when B2 contains AOD. However, there could be
> something going on at Morningstar that would mean another symbol may not
> work -- for example, the export file may be created when you GO to the web
> page. The add-in might bypass that process by trying to go directly to a
> file that hasn't been created. But I don't know of any other ticker symbols
> to test with.
>
> On Wed, Jul 20, 2011 at 1:53 PM, Steven <stevenletzer@...> wrote:
>
> > I figured it out when AOD was the referenced symbol. But could not make it
> > work when the fund symbol was a variable in a cell. For example in cell
> > B2=AOD
> >
> > smfGetCSVFile("http://portfolios. morningstar. "&$B$2&exportType=com/fund/ holdingsExport? t= details")
> > Obviously I have "" incorrect, but how would it work?
> >
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Good news and bad news.
> > >
> > > Bad news -- the tables on the web page are produced dynamically, so the
> > data
> > > is not within the source code of the web page for the add-in to extract
> > the
> > > data from.
> > >
> > > Good news -- this appears to get the file available from the export
> > button
> > > on the web page:
> > >
> > > =smfGetCSVFile("
> > >
> > http://portfolios.morningstar. com/fund/ holdingsExport? t=AOD&exportType =details
> > > ")
> > >
> > > On Wed, Jul 20, 2011 at 1:20 PM, Steven <stevenletzer@> wrote:
> > >
> > > > I am trying to use RCHGetHTMLTable to capture the portfolios for closed
> > end
> > > > funds, both basic and premium holdings for all 100 positions.
> > > >
> > > > This is an example for the symbol AOD
> > > >
> > > >
> > http://portfolios.morningstar. com/fund/ details?region= USA&t=AOD& culture=en- us
> > > >
> > > > Any ideas?
> > > >
> > >
> >
> >
> >
> >
> > --------------------- --------- ------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
- 4h.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 2:49 pm (PDT)
I am getting country -- here are the first two lines (transposed) from my
invocation of the smfGetCSVFile() function:
HoldingsNestle SA Weighting2.85 TypeEQUITY TickerNESN Shares Owned701200 Shares
Change0 SectorConsumer Defensive Price51.15 Day Change0.05|0 Day high/low
51.45-50.9 Volume5831974 52-Wk high/low56.9-48.92 CountrySwitzerland 3-Month
Return-4.75 1-Year Return-0.75 3-Year Return8.41 5-Year Return8.03 Market
Cap Mil166432.7 Morningstar Rating0 YTD Return-4.38 P/E5.05 Maturity
Date0 Coupon
%0 Yield to Maturity0
I did log in using EXCEL's Web Query process. Maybe that is the difference?
Are you not logged in properly for the add-in?
On Wed, Jul 20, 2011 at 2:16 PM, Steven <stevenletzer@yahoo.com > wrote:
> I changed the symbol to UTG and it worked. But the details on the basic
> web page provides these columns
> Holdings, Ticker, Sector, Style, % Portfolio Weight, Shares Owned, Shares
> Change, Latest Analyst Report, Country, YTD Return, %P/E
>
> The formula returns these columns: Holdings, Weightings, Type, Ticker,
> Shares Owned,Shares Change, Sector, Price, Day Change,Day high/low, Volume
>
> I am looking to determine the specific countries to avoid the PIGS part of
> the Eurozone. Therefore I need the country. Do you have another way either
> with Morningstar or a different source? Morningstar provides the region
> breakdown, but not a summary of the country breakdown.
>
- 4i.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 2:56 pm (PDT)
There is another site that summarises the country, here is the URL
http://www.cefconnect.com/Details/ Summary.aspx? ticker=AOD
Under the Tab "Portfolios Charastics" in the lower right od the page is "Country Allocation" The next line is "As of 4/30/2011 reported by fund sponsor" The this table
Country %Portfolio
USA 36.97%
Norway 8.47%
Brazil 7.89%
Sweden 7.34%
Switzerland 6.55%
UK 6.42%
France 5.98%
Finland 4.92%
South Korea 3.82%
Australia 2.98%
This is free site that gets the data from Morningstar. I possibly can do a GetTableCell, that would require that I know all of the countries to do a cell lookup. A GetHTMLTable would be more efficient.
Any ideas?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I am getting country -- here are the first two lines (transposed) from my
> invocation of the smfGetCSVFile() function:
>
> HoldingsNestle SA Weighting2.85 TypeEQUITY TickerNESN Shares Owned701200 Shares
> Change0 SectorConsumer Defensive Price51.15 Day Change0.05|0 Day high/low
> 51.45-50.9 Volume5831974 52-Wk high/low56.9-48.92 CountrySwitzerland 3-Month
> Return-4.75 1-Year Return-0.75 3-Year Return8.41 5-Year Return8.03 Market
> Cap Mil166432.7 Morningstar Rating0 YTD Return-4.38 P/E5.05 Maturity
> Date0 Coupon
> %0 Yield to Maturity0
> I did log in using EXCEL's Web Query process. Maybe that is the difference?
> Are you not logged in properly for the add-in?
>
> On Wed, Jul 20, 2011 at 2:16 PM, Steven <stevenletzer@...> wrote:
>
> > I changed the symbol to UTG and it worked. But the details on the basic
> > web page provides these columns
> > Holdings, Ticker, Sector, Style, % Portfolio Weight, Shares Owned, Shares
> > Change, Latest Analyst Report, Country, YTD Return, %P/E
> >
> > The formula returns these columns: Holdings, Weightings, Type, Ticker,
> > Shares Owned,Shares Change, Sector, Price, Day Change,Day high/low, Volume
> >
> > I am looking to determine the specific countries to avoid the PIGS part of
> > the Eurozone. Therefore I need the country. Do you have another way either
> > with Morningstar or a different source? Morningstar provides the region
> > breakdown, but not a summary of the country breakdown.
> >
>
- 4j.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Wed Jul 20, 2011 3:11 pm (PDT)
I figured it out in columns, is it possible to have the return in rows?
http://www.cefconnect.com/Details/ Summary.aspx? ticker=IGR
--- In smf_addin@yahoogroups.com , "Steven" <stevenletzer@...> wrote:
>
> There is another site that summarises the country, here is the URL
> http://www.cefconnect.com/Details/ Summary.aspx? ticker=AOD
>
> Under the Tab "Portfolios Charastics" in the lower right od the page is "Country Allocation" The next line is "As of 4/30/2011 reported by fund sponsor" The this table
>
> Country %Portfolio
> USA 36.97%
> Norway 8.47%
> Brazil 7.89%
> Sweden 7.34%
> Switzerland 6.55%
> UK 6.42%
> France 5.98%
> Finland 4.92%
> South Korea 3.82%
> Australia 2.98%
>
> This is free site that gets the data from Morningstar. I possibly can do a GetTableCell, that would require that I know all of the countries to do a cell lookup. A GetHTMLTable would be more efficient.
>
> Any ideas?
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > I am getting country -- here are the first two lines (transposed) from my
> > invocation of the smfGetCSVFile() function:
> >
> > HoldingsNestle SA Weighting2.85 TypeEQUITY TickerNESN Shares Owned701200 Shares
> > Change0 SectorConsumer Defensive Price51.15 Day Change0.05|0 Day high/low
> > 51.45-50.9 Volume5831974 52-Wk high/low56.9-48.92 CountrySwitzerland 3-Month
> > Return-4.75 1-Year Return-0.75 3-Year Return8.41 5-Year Return8.03 Market
> > Cap Mil166432.7 Morningstar Rating0 YTD Return-4.38 P/E5.05 Maturity
> > Date0 Coupon
> > %0 Yield to Maturity0
> > I did log in using EXCEL's Web Query process. Maybe that is the difference?
> > Are you not logged in properly for the add-in?
> >
> > On Wed, Jul 20, 2011 at 2:16 PM, Steven <stevenletzer@> wrote:
> >
> > > I changed the symbol to UTG and it worked. But the details on the basic
> > > web page provides these columns
> > > Holdings, Ticker, Sector, Style, % Portfolio Weight, Shares Owned, Shares
> > > Change, Latest Analyst Report, Country, YTD Return, %P/E
> > >
> > > The formula returns these columns: Holdings, Weightings, Type, Ticker,
> > > Shares Owned,Shares Change, Sector, Price, Day Change,Day high/low, Volume
> > >
> > > I am looking to determine the specific countries to avoid the PIGS part of
> > > the Eurozone. Therefore I need the country. Do you have another way either
> > > with Morningstar or a different source? Morningstar provides the region
> > > breakdown, but not a summary of the country breakdown.
> > >
> >
>
- 4k.
-
Re: Morningstar Premium Porfolio Holdings
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 3:37 pm (PDT)
What are you using for the columns? Can you just transpose it?
On Wed, Jul 20, 2011 at 3:11 PM, Steven <stevenletzer@yahoo.com > wrote:
> I figured it out in columns, is it possible to have the return in rows?
>
> http://www.cefconnect.com/Details/ Summary.aspx? ticker=IGR
>
- 5a.
-
Re: smfPricesByDates showing $505,480,256 for today's price
Posted by: "Martin Topper" mtopper@yahoo.com mtopper
Wed Jul 20, 2011 1:46 pm (PDT)
It seems these erroneous and temporary results have some pattern to them.
Stocks are always 505xxxxxx. Mutual funds always 503xxxxxx. When the
RCHGetYahooQuotes array entered formula returns these errors, it also returns 0
for indices.
In addition I have noticed that the number returned is always the same for each
ticker BAC 505545600, KMX 505544704 etc.
SMFForceRecalc returns correct info
Marty
_____________________ _________ __
From: chaim422 <chaim422@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tue, July 19, 2011 6:57:04 PM
Subject: [smf_addin] Re: smfPricesByDates showing $505,480,256 for today's price
Thanks Randy!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When you use today's date, the function uses the RCHGetYahooQuotes()
> function to retrieve the current quote -- because historical quotes only
> goes through the prior day.
>
> If you look at recent message threads in the group archives, you'll notice
> Yahoo current quotes has been flaky and occasionally returning erroneous
> prices recently. I suspect one of their servers has a corrupted database or
> something.
>
> On Tue, Jul 19, 2011 at 2:47 PM, chaim422 <chaim422@...> wrote:
>
> > I have a spreadsheet to track the total return of the stocks in my
> > portfolio using smfPricesByDates. Some stocks show the right price but some
> > stocks show $505,480,256 as today's price.
> >
> > I'm using a separate array of two columns for each stock. For example:
> > smfPricesByDates("BAC, 6/1/11, today()). When I change the date to today()-1
> > it works fine. Any ideas?
> >
>
- 6a.
-
getyahhooquotes dividend code d
Posted by: "chj.2010" chasjohn02@yahoo.com chj.2010
Wed Jul 20, 2011 4:20 pm (PDT)
Hello all - Am trying to pull dividend data using the smf_addin symbols.
The following is extracted from an Excel worksheet.
l1 t8 d r1 q e7 e8
Tick1 Price Target Div Pay Ex EPS11 EPS12
MRO 31.03 40.78 21.70 Jun 10 Jul 1 4.28 4.13
The d symbol is giving the trailing dividend yield, not the actual dividend. The dividend dates also appear to be incorrect.
Yahoo statistics for MRO (Marathon Oil)
Dividends & Splits
Forward Annual Dividend Rate4: 1.00
Forward Annual Dividend Yield4: 3.20%
Trailing Annual Dividend Yield3: 21.70
Trailing Annual Dividend Yield3: 69.50%
5 Year Average Dividend Yield4: N/A
Payout Ratio4: 23.00%
Dividend Date3: Jun 9, 2011
Ex-Dividend Date4: May 16, 2011
- 6b.
-
Re: getyahhooquotes dividend code d
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 4:32 pm (PDT)
Your complaint should be directed to Yahoo -- the add-in is just giving you
what Yahoo is sending. What you are seeing is how Yahoo (or their data
provider) chose to handle the spinoff's affect on the data. The ex-dividend
and payable dates are for the spinoff -- the most recent distribution on the
stock.
On Wed, Jul 20, 2011 at 4:20 PM, chj.2010 <chasjohn02@yahoo.com > wrote:
> Hello all - Am trying to pull dividend data using the smf_addin symbols.
> The following is extracted from an Excel worksheet.
> l1 t8 d r1 q e7 e8
> Tick1 Price Target Div Pay Ex EPS11 EPS12
> MRO 31.03 40.78 21.70 Jun 10 Jul 1 4.28 4.13
>
> The d symbol is giving the trailing dividend yield, not the actual
> dividend. The dividend dates also appear to be incorrect.
>
> Yahoo statistics for MRO (Marathon Oil)
> Dividends & Splits
> Forward Annual Dividend Rate4: 1.00
> Forward Annual Dividend Yield4: 3.20%
> Trailing Annual Dividend Yield3: 21.70
> Trailing Annual Dividend Yield3: 69.50%
> 5 Year Average Dividend Yield4: N/A
> Payout Ratio4: 23.00%
> Dividend Date3: Jun 9, 2011
> Ex-Dividend Date4: May 16, 2011
>
- 7a.
-
how to use smfForecRecalculation macro?
Posted by: "cocoaacc" cocoaacc@yahoo.com.hk cocoaacc
Wed Jul 20, 2011 11:59 pm (PDT)
Dear Sir,
Using =RCHGetYahooQuotes(A2:A100,B1: M1,,NOW() ), I can type F9 to refresh all the data.
I am wondering if you have a formula, so the cells can refresh automatically.
I am wondering if smfForceRecalculation macro is this type of formula I want.
Thank you!
P.S. I love the SMF-addin you created, beautiful!
Will
- 7b.
-
Re: how to use smfForecRecalculation macro?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 12:18 am (PDT)
Check the "Links" area of the group for information on the
smfForceRecalculation macro.
To refresh automatically, you'd need to write your own VBA timing routine,
which would invoke the smfForceRecalculation macro. Check the message
archives. It has been discussed before.
On Wed, Jul 20, 2011 at 11:59 PM, cocoaacc <cocoaacc@yahoo.com.hk > wrote:
>
> Using =RCHGetYahooQuotes(A2:A100,B1: M1,,NOW() ), I can type F9 to refresh
> all the data.
>
> I am wondering if you have a formula, so the cells can refresh
> automatically.
>
> I am wondering if smfForceRecalculation macro is this type of formula I
> want.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar