15 Messages
Digest #4305
Messages
Mon Feb 12, 2018 11:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I have no control over which fields are available. That is
defined by the Yahoo API that the function uses.
On Mon, Feb 12, 2018 at 11:44 AM, rr76012@
...
wrote:
> I have been using your "smfGetYahooPortfolioView - Example.xls"
>
> but I am not sure if I am missing if you put the Yahoo - 5 Year Average
> Dividend Yield.
>
> You have used this field on your previous spreadsheet.
>
> If you would Pls consider putting this field on your future upgrades on
> your
>
> "smfGetYahooPortfolioView - Example.xls".
>
> I have placed a link and copy to the yahoo website.
>
> https://finance.yahoo.com/quote/EXC/key-statistics
>
> Dividends & Splits
> Forward Annual Dividend Rate 4 1.38
> Forward Annual Dividend Yield 4 3.74%
> Trailing Annual Dividend Rate 3 1.30
> Trailing Annual Dividend Yield 3 3.52%
> 5 Year Average Dividend Yield 4 4.07
>
>
>
defined by the Yahoo API that the function uses.
On Mon, Feb 12, 2018 at 11:44 AM, rr76012@
...
wrote:
> I have been using your "smfGetYahooPortfolioView - Example.xls"
>
> but I am not sure if I am missing if you put the Yahoo - 5 Year Average
> Dividend Yield.
>
> You have used this field on your previous spreadsheet.
>
> If you would Pls consider putting this field on your future upgrades on
> your
>
> "smfGetYahooPortfolioView - Example.xls".
>
> I have placed a link and copy to the yahoo website.
>
> https://finance.yahoo.com/quote/EXC/key-statistics
>
> Dividends & Splits
> Forward Annual Dividend Rate 4 1.38
> Forward Annual Dividend Yield 4 3.74%
> Trailing Annual Dividend Rate 3 1.30
> Trailing Annual Dividend Yield 3 3.52%
> 5 Year Average Dividend Yield 4 4.07
>
>
>
Tue Feb 13, 2018 8:29 am (PST) . Posted by:
rr76012
Hi Randy,
Thank You.
Do have any suggestions using smf to get the 5-Year Average Dividend Yield easily?
Randy, as always, thanks.
rr76012
Thank You.
Do have any suggestions using smf to get the 5-Year Average Dividend Yield easily?
Randy, as always, thanks.
rr76012
Tue Feb 13, 2018 8:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't know of any source that allows mass retrieval of it.
On Tue, Feb 13, 2018 at 9:29 AM, rr76012@
...
wrote:
>
> Do have any suggestions using smf to get the 5-Year Average Dividend Yield
> easily?
>
>
>
On Tue, Feb 13, 2018 at 9:29 AM, rr76012@
...
wrote:
>
> Do have any suggestions using smf to get the 5-Year Average Dividend Yield
> easily?
>
>
>
Mon Feb 12, 2018 1:25 pm (PST) . Posted by:
joelfp2000
Randy,
Thanks for all that you do to keep this group going.
I'm trying to grab the M* 30 day SEC yield off of the M* quote page. I can pick off the 12 month trailing yield and the fund expenses, but not the 30 day SEC yield.
=smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t="&$A$2,
What do I need to change to grab the 30 day SEC yield?
Thanks so much!
Joel
Mon Feb 12, 2018 3:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=VFINX","span",1,"30-Day
SEC Yield",,,,1)
On Mon, Feb 12, 2018 at 2:25 PM, joel.andrews@
...
wrote:
> I'm trying to grab the M* 30 day SEC yield off of the M* quote page. I
> can pick off the 12 month trailing yield and the fund expenses, but not the
> 30 day SEC yield.
>
> =smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=
> "&$A$2,"span",-1,"vkey=""FeeLevel""")
>
> What do I need to change to grab the 30 day SEC yield?
>
>
>
=smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=VFINX","span",1,"30-Day
SEC Yield",,,,1)
On Mon, Feb 12, 2018 at 2:25 PM, joel.andrews@
...
wrote:
> I'm trying to grab the M* 30 day SEC yield off of the M* quote page. I
> can pick off the 12 month trailing yield and the fund expenses, but not the
> 30 day SEC yield.
>
> =smfGetTagContent("http://quotes.morningstar.com/fundq/c-header?t=
> "&$A$2,
>
> What do I need to change to grab the 30 day SEC yield?
>
>
>
Mon Feb 12, 2018 8:26 pm (PST) . Posted by:
ajtalukdar
Thanks for pointing me to GuruFocus. Looks like they have everything I need .. and more. Best.
Tue Feb 13, 2018 3:27 am (PST) . Posted by:
rosendojose
Hi Randy,
Once again I need your precious help.
I have several small complex little portfolios where I need to withdraw and add actions and for the information of the daily variations I use:
* = rchgetelementnumber (A664,2151) => error message "error"
* = smfPricesByDates ("^ GSPC", K518) => error message "N / A"
I am also having errors in several rchgetelementnumber formulas.
I have Windows 10 and Office 2016 and until the last weekend had no problem.
Any suggestions on what's going wrong?
Many thanks.
Rosendo José
Once again I need your precious help.
I have several small complex little portfolios where I need to withdraw and add actions and for the information of the daily variations I use:
* = rchgetelementnumber (A664,2151) => error message "error"
* = smfPricesByDates ("^ GSPC", K518) => error message "N / A"
I am also having errors in several rchgetelementnumber formulas.
I have Windows 10 and Office 2016 and until the last weekend had no problem.
Any suggestions on what's going wrong?
Many thanks.
Rosendo José
Tue Feb 13, 2018 8:49 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Both of these are working fine here:
=RCHGetElementNumber("MMM";,2151)
=smfPricesByDates("^GSPC";,"12/31/2017")
I'm not sure why you would try to get the current price of something from
IBD. smfGetYahooPortfolioView() would be the better way, since you can get
numerous items for numerous tickers, all with one Internet access. Did you
create the IE security cookie for IE? Much of their data does require you
to be a paid subscriber. I don't think current price requires it, but they
could be redirecting you to an advertising splash screen -- some sites do
this from time to time on your first visit to the web site on a given day.
But "first visit" is toggled off via cookie, which requires IE browser
processing. Since the add-in just retrieves source code, it wouldn't create
such a cookie.
As for the second function, "^ GSPC" is not a valid ticker symbol..
On Tue, Feb 13, 2018 at 4:27 AM, rosendo.jose@
..
wrote:
> Once again I need your precious help.
>
> I have several small complex little portfolios where I need to withdraw
> and add actions and for the information of the daily variations I use:
>
> * = rchgetelementnumber (A664,2151) => error message "error"
>
> * = smfPricesByDates ("^ GSPC", K518) => error message "N / A"
>
> I am also having errors in several rchgetelementnumber formulas.
>
> I have Windows 10 and Office 2016 and until the last weekend had no
> problem.
>
> Any suggestions on what's going wrong?
>
>
>
=RCHGetElementNumbe
=smfPricesByDates(
I'm not sure why you would try to get the current price of something from
IBD. smfGetYahooPortfoli
numerous items for numerous tickers, all with one Internet access. Did you
create the IE security cookie for IE? Much of their data does require you
to be a paid subscriber. I don't think current price requires it, but they
could be redirecting you to an advertising splash screen -- some sites do
this from time to time on your first visit to the web site on a given day.
But "first visit" is toggled off via cookie, which requires IE browser
processing. Since the add-in just retrieves source code, it wouldn't create
such a cookie.
As for the second function, "^ GSPC" is not a valid ticker symbol..
On Tue, Feb 13, 2018 at 4:27 AM, rosendo.jose@
..
wrote:
> Once again I need your precious help.
>
> I have several small complex little portfolios where I need to withdraw
> and add actions and for the information of the daily variations I use:
>
> * = rchgetelementnumber (A664,2151) => error message "error"
>
> * = smfPricesByDates ("^ GSPC", K518) => error message "N / A"
>
> I am also having errors in several rchgetelementnumber formulas.
>
> I have Windows 10 and Office 2016 and until the last weekend had no
> problem.
>
> Any suggestions on what's going wrong?
>
>
>
Wed Feb 14, 2018 6:17 am (PST) . Posted by:
rosendojose
Thanks Randy. Strangely, at the end of the night I opened the file and everything worked ok. There was probably a temporary problem on the site itself.
I'll take the hint and explore smfGetYahooPortfolioView ().
In the beginning I used Rchgetelementnumber "25" (MSN). When it became obsolete, I switched to the RCHGetYahooQuotes "L1". Finally, I started using the element "2151".
But I confess I still do not know smfGetYahooPortfolioView () ...
Regarding "^ GSPC" is the symbol that I use to get information from the SPX500 (Yahoo). It works as one of my portfolio benchmarks.
Once again, thank you for everything and for your infinite availability.
Yours
Rosendo José
I'll take the hint and explore smfGetYahooPortfoli
In the beginning I used Rchgetelementnumber "25" (MSN). When it became obsolete, I switched to the RCHGetYahooQuotes "L1"
But I confess I still do not know smfGetYahooPortfoli
Regarding "^ GSPC" is the symbol that I use to get information from the SPX500 (Yahoo). It works as one of my portfolio benchmarks.
Once again, thank you for everything and for your infinite availability.
Yours
Rosendo José
Thu Feb 15, 2018 4:39 pm (PST) . Posted by:
eadamy
I am using SMF from RCH_Stock_Market_Functions-2.1.2018.01.24 under Excel 10 on W10. I am getting bad real-time quotes from Y! using the following code:
arrTickerQuotes = smfGetYahooPortfolioView(pTickers:=sSymbolsString, _
pItems:="0115162126", _
pHeader:=0, _
pDim1:=UBound(varrSymbols, 1), _
pDim2:=5)
while the following code returns correct quotes:
arrTickerQuotes = smfGetBarchartPortfolioView(pTickers:=sSymbolsString, _
pItems:="001009016012080", _
pHeader:=0, _
pDim1:=UBound(varrSymbols, 1), _
pDim2:=5)
These are the item values I am using:
' Yahoo BarCharts
' Ticker 01 001
' Last price 15 009
' Last trade date 16 016
' Volume 21 012
' Average Volume ( 3 months) 26 080
At 3pm Eastern today, Y was returning a Last value for SPY of 272.30 versus the closing value of 273.03 shown on Y webpage. Barcharts correctly returned 272.03. RSP returned 101.89 versus 102.13 from the Y webpage and Barcharts. I had the same problem with a dozen symbols.
I can switch between the two by toggling a constant so it is no problem to use Barcharts but I thought I'd better alert you to the issue. I first noticed this a week or so ago but my SMF version was not up to date and by the time I updated, the final EOD values were in so I could not do further testing. I've noticed anomalies in the interim but this is the first opportunity I've had to isolate the problem.
Earl
arrTickerQuotes = smfGetYahooPortfoli
pItems:="
pHeader:=0, _
pDim1:=UBound(
pDim2:=5)
while the following code returns correct quotes:
arrTickerQuotes = smfGetBarchartPortf
pItems:="
pHeader:=0, _
pDim1:=UBound(
pDim2:=5)
These are the item values I am using:
' Yahoo BarCharts
' Ticker 01 001
' Last price 15 009
' Last trade date 16 016
' Volume 21 012
' Average Volume ( 3 months) 26 080
At 3pm Eastern today, Y was returning a Last value for SPY of 272.30 versus the closing value of 273.03 shown on Y webpage. Barcharts correctly returned 272.03. RSP returned 101.89 versus 102.13 from the Y webpage and Barcharts. I had the same problem with a dozen symbols.
I can switch between the two by toggling a constant so it is no problem to use Barcharts but I thought I'd better alert you to the issue. I first noticed this a week or so ago but my SMF version was not up to date and by the time I updated, the final EOD values were in so I could not do further testing. I've noticed anomalies in the interim but this is the first opportunity I've had to isolate the problem.
Earl
Thu Feb 15, 2018 4:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Prior to the close, field #16 in both functions should have a time
component. Do they both correspond to real time, or show a delay?
You do have your Internet Options set to always get a fresh copy of the web
page, right? Otherwise, you may get cached copies of web pages.
Are you running the smfForceRecalculation before having VBA run the
functions? If not, the add-in may just be extracting data from a copy of a
previously retrieved web page.
On Thu, Feb 15, 2018 at 5:39 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am using SMF from RCH_Stock_Market_Functions-2.1.2018.01.24 under Excel
> 10 on W10. I am getting bad real-time quotes from Y! using the following
> code:
>
>
> arrTickerQuotes = smfGetYahooPortfolioView(pTickers:=sSymbolsString,
> _
>
>
> pItems:="0115162126", _
>
> pHeader:=0, _
>
>
> pDim1:=UBound(varrSymbols, 1), _
>
> pDim2:=5)
>
>
> while the following code returns correct quotes:
>
> arrTickerQuotes = smfGetBarchartPortfolioView(pTickers:=sSymbolsString,
> _
>
>
> pItems:="001009016012080", _
>
> pHeader:=0, _
>
>
> pDim1:=UBound(varrSymbols, 1), _
>
> pDim2:=5)
>
> These are the item values I am using:
>
> ' Yahoo BarCharts
>
> ' Ticker 01 001
>
> ' Last price 15 009
>
> ' Last trade date 16 016
>
> ' Volume 21 012
>
> ' Average Volume ( 3 months) 26 080
>
>
> At 3pm Eastern today, Y was returning a Last value for SPY of 272.30
> versus the closing value of 273.03 shown on Y webpage. Barcharts correctly
> returned 272.03. RSP returned 101.89 versus 102.13 from the Y webpage and
> Barcharts. I had the same problem with a dozen symbols.
>
> I can switch between the two by toggling a constant so it is no problem to
> use Barcharts but I thought I'd better alert you to the issue. I first
> noticed this a week or so ago but my SMF version was not up to date and by
> the time I updated, the final EOD values were in so I could not do further
> testing. I've noticed anomalies in the interim but this is the first
> opportunity I've had to isolate the problem.
>
component. Do they both correspond to real time, or show a delay?
You do have your Internet Options set to always get a fresh copy of the web
page, right? Otherwise, you may get cached copies of web pages.
Are you running the smfForceRecalculation before having VBA run the
functions? If not, the add-in may just be extracting data from a copy of a
previously retrieved web page.
On Thu, Feb 15, 2018 at 5:39 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am using SMF from RCH_Stock_Market_
> 10 on W10. I am getting bad real-time quotes from Y! using the following
> code:
>
>
> arrTickerQuotes = smfGetYahooPortfoli
> _
>
>
> pItems:="
>
> pHeader:=0, _
>
>
> pDim1:=UBound(
>
> pDim2:=5)
>
>
> while the following code returns correct quotes:
>
> arrTickerQuotes = smfGetBarchartPortf
> _
>
>
> pItems:="
>
> pHeader:=0, _
>
>
> pDim1:=UBound(
>
> pDim2:=5)
>
> These are the item values I am using:
>
> ' Yahoo BarCharts
>
> ' Ticker 01 001
>
> ' Last price 15 009
>
> ' Last trade date 16 016
>
> ' Volume 21 012
>
> ' Average Volume ( 3 months) 26 080
>
>
> At 3pm Eastern today, Y was returning a Last value for SPY of 272.30
> versus the closing value of 273.03 shown on Y webpage. Barcharts correctly
> returned 272.03. RSP returned 101.89 versus 102.13 from the Y webpage and
> Barcharts. I had the same problem with a dozen symbols.
>
> I can switch between the two by toggling a constant so it is no problem to
> use Barcharts but I thought I'd better alert you to the issue. I first
> noticed this a week or so ago but my SMF version was not up to date and by
> the time I updated, the final EOD values were in so I could not do further
> testing. I've noticed anomalies in the interim but this is the first
> opportunity I've had to isolate the problem.
>
Thu Feb 15, 2018 5:49 pm (PST) . Posted by:
lewglenn
Where can I find info on smfForceRecalculation?
Thu Feb 15, 2018 6:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See the "Tips and FAQs" page on the web site.
On Thu, Feb 15, 2018 at 6:49 PM, lewglenn@
...
wrote:
>
> Where can I find info on smfForceRecalculation?
>
>
On Thu, Feb 15, 2018 at 6:49 PM, lewglenn@
...
wrote:
>
> Where can I find info on smfForceRecalculati
>
>
Fri Feb 16, 2018 7:39 am (PST) . Posted by:
eadamy
> Prior to the close, field #16 in both functions should have a time component. Do they both correspond to real time, or show a delay?
I've been running it with Y this morning and the long date number for SPY is increasing along with changes in price so I'm not seeing the issue right now.
> You do have your Internet Options set to always get a fresh copy of the web page, right? Otherwise, you may get cached copies of web pages.
Chrome is my primary browser. I've had cache issues from time to time and I've never been able to find a setting which ignores or disables web page caching. Chrome caching has, at times, caused issues while performing maintenance on my Wordpress website although not recently. I've even tried various add-ins to automatically clear the Chroome cache but none have proven satisfactory.
That said, all of this processing is taking place entirely within Excel 10 VBA; however your comment appears to suggest that smfGetYahooPortfolioView is somehow sharing code or workspace with the browser workspace? I am frankly out of my comfort zone on this. I do have both FireFox and Edge installed. I took a look in Edge and did not see any settings to request a fresh copy of the web page nor do I see anything in W10 which would control this.
I have been using this Model for several years and this
> Are you running the smfForceRecalculation before having VBA run the functions? If not, the add-in may just be extracting data from a copy of a previously retrieved web page.
My application is structed in layers to provide access to multiple quote streams:
> Model >> call/ref >> QuoteServer.xlam >> call/ref >> RCH_SMF.xla(smfGYPV)
The only time a request reaches SMF is at the beginning of a Model run when the Model requests fresh RT quotes for the symbols which will be used in the run. Both QuoteServer and SMF go out of scope when the RT quotes are returned. I know for a fact that there are no active variables or arrays left in QuoteServer and I see no reason why the same would not hold true for RCH_SMF.
Model has no active/dynamic worksheets. Parameters are collected from passive worksheets, all calculations are performed in arrays, and the arrays are then formatted and output to static worksheets. So there is nothing for smfForceRecalculation to do and it could potentially introduce some unwanted wildcards into the situation.
Earl
I've been running it with Y this morning and the long date number for SPY is increasing along with changes in price so I'm not seeing the issue right now.
> You do have your Internet Options set to always get a fresh copy of the web page, right? Otherwise, you may get cached copies of web pages.
Chrome is my primary browser. I've had cache issues from time to time and I've never been able to find a setting which ignores or disables web page caching. Chrome caching has, at times, caused issues while performing maintenance on my Wordpress website although not recently. I've even tried various add-ins to automatically clear the Chroome cache but none have proven satisfactory.
That said, all of this processing is taking place entirely within Excel 10 VBA; however your comment appears to suggest that smfGetYahooPortfoli
I have been using this Model for several years and this
> Are you running the smfForceRecalculati
My application is structed in layers to provide access to multiple quote streams:
> Model >> call/ref >> QuoteServer.
The only time a request reaches SMF is at the beginning of a Model run when the Model requests fresh RT quotes for the symbols which will be used in the run. Both QuoteServer and SMF go out of scope when the RT quotes are returned. I know for a fact that there are no active variables or arrays left in QuoteServer and I see no reason why the same would not hold true for RCH_SMF.
Model has no active/dynamic worksheets. Parameters are collected from passive worksheets, all calculations are performed in arrays, and the arrays are then formatted and output to static worksheets. So there is nothing for smfForceRecalculati
Earl
Fri Feb 16, 2018 8:01 am (PST) . Posted by:
eadamy
Something really weird is going on. I've been running the Model every 5-10 minutes and the problem has not only re-appeared but gone backwards. This is actual sequence of requests for SPY spaced 5-10 minutes apart. The long number is the date/time code returned by smfGetYahooPortfolioView
1518794185 273.02
1518794956 273.4575
1518794956 273.4575
1518794956 273.4575
1518794185 273.02
In viewing other quotes returned in the same batch, I see numbers ending 4185 and below.
Earl
1518794185 273.02
1518794956 273.4575
1518794956 273.4575
1518794956 273.4575
1518794185 273.02
In viewing other quotes returned in the same batch, I see numbers ending 4185 and below.
Earl
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar