7 Messages
Digest #3993
Messages
Tue May 2, 2017 4:52 pm (PDT) . Posted by:
nednediston
Check this site out for historical earnings dates and some estimates. http://busystock.com/i.php?s=NVDA http://busystock.com/i.php?s=NVDA
Tue May 2, 2017 5:18 pm (PDT) . Posted by:
mikemcq802
=(RCHGetElementNumber("IBM",979) is returning 3960 instead of 3.96M.
I tried using =RCHGetTableCell(url,1,"Avg Vol (3") and it also returns a string of 3960. I was trying to use this instead of the GetElementNumber and adjust it for the trailing "M" but the "M" isn't returned. The url in this case was:
https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM
I am using 2017-05-01 as I just upgraded to fix some other issues you just corrected with Yahoo data.
Other tickers with lower volume don't have an "M" and appear to be fine.
Thanks.
I tried using =RCHGetTableCell(url,1,"Avg Vol (3") and it also returns a string of 3960. I was trying to use this instead of the GetElementNumber and adjust it for the trailing "M" but the "M" isn't returned. The url in this case was:
https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM
I am using 2017-05-01 as I just upgraded to fix some other issues you just corrected with Yahoo data.
Other tickers with lower volume don't have an "M" and appear to be fine.
Thanks.
Tue May 2, 2017 5:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, all "M" and :"B" suffix combinations are returned as
thousands, because that was the context that made sense when they were
first implemented. The workaround would be to use the smfGetTagContent()
function and parse it yourself.
=smfGetTagContent("https://finance.yahoo.com/q/ks?s=IBM","td",1,">AVG VOL
(3 MONTH)")
On Tue, May 2, 2017 at 5:18 PM, mikemcq802@
...wrote:
> =(RCHGetElementNumber("IBM",979) is returning 3960 instead of 3.96M.
>
> I tried using =RCHGetTableCell(url,1,"Avg Vol (3") and it also returns a
> string of 3960. I was trying to use this instead of the GetElementNumber
> and adjust it for the trailing "M" but the "M" isn't returned. The url in
> this case was:
>
> https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM
>
> I am using 2017-05-01 as I just upgraded to fix some other issues you just
> corrected with Yahoo data.
>
> Other tickers with lower volume don't have an "M" and appear to be fine.
>
>
thousands, because that was the context that made sense when they were
first implemented. The workaround would be to use the smfGetTagContent()
function and parse it yourself.
=smfGetTagContent("https://finance.yahoo.com/q/ks?s=IBM","td",1,">AVG VOL
(3 MONTH)")
On Tue, May 2, 2017 at 5:18 PM, mikemcq802@
...wrote:
> =(RCHGetElementNumber("IBM",979) is returning 3960 instead of 3.96M.
>
> I tried using =RCHGetTableCell(url,1,"Avg Vol (3") and it also returns a
> string of 3960. I was trying to use this instead of the GetElementNumber
> and adjust it for the trailing "M" but the "M" isn't returned. The url in
> this case was:
>
> https://finance.yahoo.com/quote/IBM/key-statistics?p=IBM
>
> I am using 2017-05-01 as I just upgraded to fix some other issues you just
> corrected with Yahoo data.
>
> Other tickers with lower volume don't have an "M" and appear to be fine.
>
>
Tue May 2, 2017 5:58 pm (PDT) . Posted by:
hsadvisor1
Sorry Randy. What I meant to say was that Morningstar functions are now lost. For example RCHgetelementnumber 4717 (Net stock % for a fund) etc. return undefinable message.
When I had the original issue with Yahoo data, Morningstar Mutual Fund data was still coming in. Then I re-installed the new 5/01/17 version and now I don't get either Yahoo or Morningstar data. This is despite the fact that the correct version shows up when I put in RCHGETELEMENTNUMBER("VERSION"). I'm totally stumped.
I copied the version that shows in my spreadsheet. see below..
I too must add my praise for your tireless efforts to help us out here as we meander through the wilderness. Thanks for any help you can provide.
Harry
Stock Market Functions add-in, Version 2.1.2017.05.01 (C:\Program Files (x86)\Add-ins; Windows (32-bit) NT 5.01; 14.0; ; ; 1)
When I had the original issue with Yahoo data, Morningstar Mutual Fund data was still coming in. Then I re-installed the new 5/01/17 version and now I don't get either Yahoo or Morningstar data. This is despite the fact that the correct version shows up when I put in RCHGETELEMENTNUMBER
I copied the version that shows in my spreadsheet. see below..
I too must add my praise for your tireless efforts to help us out here as we meander through the wilderness. Thanks for any help you can provide.
Harry
Stock Market Functions add-in, Version 2.1.2017.05.
Tue May 2, 2017 6:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What do you get with:
=RCHGetElementNumber("VFINX",4717)
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",0,">Asset
Allocation",,,">US Stock|>Stock")
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",1,">Asset
Allocation",,,">US Stock|>Stock")
=RCHGetWebData("http://portfolios.morningstar.com/fund/summary?t=VFINX",">US
Stock")
A possible issue -- have you visited the website in the EXCEL Web Query
dialog (alt+d+d+w)? Morningstar is one of those sites that occasionally
does a redirection on your first visit on a given day, and that "first
visit" flag is in effect until cleared by a cookie created by a browser.
Sometimes when I get an "Error" on something from Morningstar, I visit the
site in the Query dialog, cancel out, and then run the
smfForceRecalculation macro to force the web page to be retrieved again.
On Tue, May 2, 2017 at 5:58 PM, hsadvisor1@
...wrote:
> Sorry Randy. What I meant to say was that Morningstar functions are now
> lost. For example RCHgetelementnumber 4717 (Net stock % for a fund) etc.
> return undefinable message.
>
> When I had the original issue with Yahoo data, Morningstar Mutual Fund
> data was still coming in. Then I re-installed the new 5/01/17 version and
> now I don't get either Yahoo or Morningstar data. This is despite the fact
> that the correct version shows up when I put in
> RCHGETELEMENTNUMBER("VERSION"). I'm totally stumped.
>
> I copied the version that shows in my spreadsheet. see below..
>
> I too must add my praise for your tireless efforts to help us out here as
> we meander through the wilderness. Thanks for any help you can provide.
>
>
=RCHGetElementNumber("VFINX",4717)
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",0,">Asset
Allocation",,,">US Stock|>Stock")
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",1,">Asset
Allocation",,,">US Stock|>Stock")
=RCHGetWebData("http://portfolios.morningstar.com/fund/summary?t=VFINX","
Stock")
A possible issue -- have you visited the website in the EXCEL Web Query
dialog (alt+d+d+w)? Morningstar is one of those sites that occasionally
does a redirection on your first visit on a given day, and that "first
visit" flag is in effect until cleared by a cookie created by a browser.
Sometimes when I get an "Error" on something from Morningstar, I visit the
site in the Query dialog, cancel out, and then run the
smfForceRecalculati
On Tue, May 2, 2017 at 5:58 PM, hsadvisor1@
...wrote:
> Sorry Randy. What I meant to say was that Morningstar functions are now
> lost. For example RCHgetelementnumber 4717 (Net stock % for a fund) etc.
> return undefinable message.
>
> When I had the original issue with Yahoo data, Morningstar Mutual Fund
> data was still coming in. Then I re-installed the new 5/01/17 version and
> now I don't get either Yahoo or Morningstar data. This is despite the fact
> that the correct version shows up when I put in
> RCHGETELEMENTNUMBER
>
> I copied the version that shows in my spreadsheet. see below..
>
> I too must add my praise for your tireless efforts to help us out here as
> we meander through the wilderness. Thanks for any help you can provide.
>
>
Tue May 2, 2017 7:03 pm (PDT) . Posted by:
cawley1647@rogers.com
Randy,
I was wondering if Zacks has changed something? The earnings announcements has stopped working for me. Maybe it was something that I did, but I don't think so as it has stopped on two of my computers.
I use the top line only to get the most recent earnings date.
like this: =RCHGetElementNumber(Ticker,1290), but I change the word ticker to A1 or A2 etc. where I have the ticker for each of my holdings. Suddenly I get and "error" return instead of the date.
Thanks for all that you do.
I was wondering if Zacks has changed something? The earnings announcements has stopped working for me. Maybe it was something that I did, but I don't think so as it has stopped on two of my computers.
I use the top line only to get the most recent earnings date.
like this: =RCHGetElementNumbe
Thanks for all that you do.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar