15 Messages
Digest #4201
4a
Re: with smfGetYahooPortfolio add the Price/Book Value Metric P/BV by "Randy Harmelink" rharmelink
Messages
Fri Nov 3, 2017 10:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you using non-USA regional settings? What do you get with:
=RCHGetElementNumber("Version")
I've not seen the behavior you're describing.
On Fri, Nov 3, 2017 at 5:06 AM, gustav@juhler.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Hi all, I have a question regarding the function: smfGetYahooPortfolioView.
>
> The price values are ignoring any tailing zeroes, such that the price
> "1230" will be displayed as "123", this is a problem, since it is not
> consistent when e.g. the price fluctuates to "1231", then it will be
> displayed as "1231".
>
> I hope it makes sense, and that you can help me with a workaround?
>
>
>
=RCHGetElementNumber("Version")
I've not seen the behavior you're describing.
On Fri, Nov 3, 2017 at 5:06 AM, gustav@juhler.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Hi all, I have a question regarding the function: smfGetYahooPortfoli
>
> The price values are ignoring any tailing zeroes, such that the price
> "1230" will be displayed as "123"
> consistent when e.g. the price fluctuates to "1231"
> displayed as "1231"
>
> I hope it makes sense, and that you can help me with a workaround?
>
>
>
Fri Nov 3, 2017 10:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This has been the topic of the last few hundred messages on the Yahoo
group. :)
See the recent announcements on the blog:
https://smf-add-in.blogspot.com/
If you know of a suitable replacement source, I'm all ears? At this point,
the most viable alternatives I've seen are to create watch lists or
portfolios on other services, and export the data (usually manually).
On Fri, Nov 3, 2017 at 5:46 AM, timbowers23@
...
wrote:
> Within the last few days RCHGetYahooQuotes stopped returning data. Today
> after some finagling I got this message:
>
> Yahoo! - 403 Forbidden -- error 403
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being
> discontinued. For all future markets and equities data research, please
> refer to finance.yahoo.com.
>
> Appears to be time to try some other avenue for stock and mutual fund
> quotes. Does anybody have any suggestions?
>
>
>
group. :)
See the recent announcements on the blog:
https://smf-add-in.blogspot.com/
If you know of a suitable replacement source, I'm all ears? At this point,
the most viable alternatives I've seen are to create watch lists or
portfolios on other services, and export the data (usually manually).
On Fri, Nov 3, 2017 at 5:46 AM, timbowers23@
...
wrote:
> Within the last few days RCHGetYahooQuotes stopped returning data. Today
> after some finagling I got this message:
>
> Yahoo! - 403 Forbidden -- error 403
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being
> discontinued. For all future markets and equities data research, please
> refer to finance.yahoo.
>
> Appears to be time to try some other avenue for stock and mutual fund
> quotes. Does anybody have any suggestions?
>
>
>
Fri Nov 3, 2017 11:10 am (PDT) . Posted by:
roger.donaldson
Another financial software had the following commnet
We have posted a new update for xys - that utilizes Google Finance for continued free pricing of your securities (as available from Google).
Don't know if that helps.
We have posted a new update for xys - that utilizes Google Finance for continued free pricing of your securities (as available from Google).
Don't know if that helps.
Fri Nov 3, 2017 11:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of a way to get batch quotes from Google. I think you can get
a list of about 10 tickers, but that's it, and it is still extractions from
scripted data. They are even unplugging their portfolio feature.
On Fri, Nov 3, 2017 at 11:09 AM, roger.donaldson@
...
wrote:
>
> Another financial software had the following commnet
> We have posted a new update for xys - that utilizes Google Finance for
> continued free pricing of your securities (as available from Google).
> Don't know if that helps.
>
a list of about 10 tickers, but that's it, and it is still extractions from
scripted data. They are even unplugging their portfolio feature.
On Fri, Nov 3, 2017 at 11:09 AM, roger.donaldson@
...
wrote:
>
> Another financial software had the following commnet
> We have posted a new update for xys - that utilizes Google Finance for
> continued free pricing of your securities (as available from Google).
> Don't know if that helps.
>
Fri Nov 3, 2017 10:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo dropping the current quotes API forced me to release the update to
smfGetYahooPortfolioView() early, so it is missing some things that I was
looking at adding or changing. They are still in the pipeline.
Here is a list of additional fields that appear to be available:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33528
On Fri, Nov 3, 2017 at 8:59 AM, warrenth@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> There are a couple of data fields that were available in
> RCHGetYahooQuote() that don't seem to have made it into
> smfGetYahooPortfolioView() and I was wondering if they could be added. The
> two that I'd be interested in are 52 week high and 52 week low.
>
> Thanks in advance for your consideration of these changes.
>
smfGetYahooPortfolioView() early, so it is missing some things that I was
looking at adding or changing. They are still in the pipeline.
Here is a list of additional fields that appear to be available:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33528
On Fri, Nov 3, 2017 at 8:59 AM, warrenth@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> There are a couple of data fields that were available in
> RCHGetYahooQuote(
> smfGetYahooPortfoli
> two that I'd be interested in are 52 week high and 52 week low.
>
> Thanks in advance for your consideration of these changes.
>
Fri Nov 3, 2017 10:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo dropping the current quotes API forced me to release the update to
smfGetYahooPortfolioView() early, so it is missing some things that I was
looking at adding or changing. They are still in the pipeline.
Here is a list of additional fields that appear to be available:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33528
On Fri, Nov 3, 2017 at 9:31 AM, rr76012@
...
wrote:
> re: request to add P/BV metric to the smfGetYahooPortfolio function.
>
> If possible could/would you add to your " smfGetYahooPortfolio "
> spreadsheet the ability to download the "Price/Book Value" metric".
> I noticed you have the "Price/Sales", "P/S metric", but I use the "Price
> to Book Metric" the "P/BV".
>
> I know you are extremely busy and presently working on the
> "smfGetYahooPortfolio".
>
>
smfGetYahooPortfolioView() early, so it is missing some things that I was
looking at adding or changing. They are still in the pipeline.
Here is a list of additional fields that appear to be available:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33528
On Fri, Nov 3, 2017 at 9:31 AM, rr76012@
...
wrote:
> re: request to add P/BV metric to the smfGetYahooPortfoli
>
> If possible could/would you add to your " smfGetYahooPortfoli
> spreadsheet the ability to download the "Price/
> I noticed you have the "Price/
> to Book Metric" the "P/BV"
>
> I know you are extremely busy and presently working on the
> "smfGetYahooPo
>
>
Fri Nov 3, 2017 10:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Yahoo has announced the current quotes API is dead.
Right now, the smfGetYahooPortfolioView() function is looking like the
replacement.
At some point, I may be able to resurrect RCHGetYahooQuotes() to use the
JSON file feeding smfGetYahooPortfolioView(), but that is nowhere in the
near future. I'm too busy addressing issues with
smfGetYahooPortfolioView().
On Fri, Nov 3, 2017 at 9:37 AM, 'Dennis Sesar' dennis@
...
wrote:
>
> Any ETA on the Yahoo problem fix?
>
Right now, the smfGetYahooPortfoli
replacement.
At some point, I may be able to resurrect RCHGetYahooQuotes(
JSON file feeding smfGetYahooPortfoli
near future. I'm too busy addressing issues with
smfGetYahooPortfoli
On Fri, Nov 3, 2017 at 9:37 AM, 'Dennis Sesar' dennis@
...
wrote:
>
> Any ETA on the Yahoo problem fix?
>
Fri Nov 3, 2017 10:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to update using the smfForceRecalculation macro.
You would also need to make sure your Internet Options are set up to always
get fresh copies of web pages.
On Fri, Nov 3, 2017 at 9:40 AM, bob_15861586@
...
wrote:
> I am using smfGetYahooPortfolioView and I am not getting updates. Should
> I post a sample spread sheet?
>
You would also need to make sure your Internet Options are set up to always
get fresh copies of web pages.
On Fri, Nov 3, 2017 at 9:40 AM, bob_15861586@
...
wrote:
> I am using smfGetYahooPortfoli
> I post a sample spread sheet?
>
Fri Nov 3, 2017 10:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I need more context...I'm not sure what you are asking.
On Fri, Nov 3, 2017 at 10:00 AM, drobertson123@
...
wrote:
>
> Is there any chance you can specify what yahoo pages or URL calls this is
> coming back from. I work with these a lot and can start checking them out.
>
>
On Fri, Nov 3, 2017 at 10:00 AM, drobertson123@
...
wrote:
>
> Is there any chance you can specify what yahoo pages or URL calls this is
> coming back from. I work with these a lot and can start checking them out.
>
>
Fri Nov 3, 2017 10:36 am (PDT) . Posted by:
"Michael Henry" midhenry1
OK, makes sense, but how do I get the smfForceRecalculation macro ? (BTW, that date conversion function worked just fine)
Thanks,
- Michael
On Friday, November 3, 2017 10:07 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
This, like most add-in functions, do not change when you do an F9 to recalculate, because the add-in saves the web page first, then extracts the data from that saved copy of the web page. So using F9 to recalculate would just re-extract the data from the same saved copy of the web page. You would need to use the smfForceRecalculation macro to do a proper recalculation. That purges the saved copy of the web page, forcing the add-in to get a fresh copy.
All of the dates in the JSON file are in UNIX format, not EXCEL serial date format. To convert:
=smfUNIX2Date(B3)
You should be able to apply normal EXCEL date/time formats to the result.
I had planned to do that conversion in the function itself. However, Yahoo dropping the current quotes CSV file forced me to release the smfGetYahooPortfolioView() function early. So some plans that were in the pipeline are still in the pipeline. At this point, the plan is to add additional data items, including some that would have the UNIX date/time values converted to EXCEL date/time values.
On Fri, Nov 3, 2017 at 8:58 AM, Michael Henry midhenry1@... wrote:
Thanks for the pointer to the latest version. I get:Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\SMF Add-in; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
The sample worksheet also works.
However, how do I refresh the data? I heard mention of a macro.......? Why not just the usual F9 refresh?
Also, the "Last Traded" data is a complete mystery to me. How is this translated into a time and date?
#yiv4258468549 #yiv4258468549 -- #yiv4258468549ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4258468549 #yiv4258468549ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4258468549 #yiv4258468549ygrp-mkp #yiv4258468549hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4258468549 #yiv4258468549ygrp-mkp #yiv4258468549ads {margin-bottom:10px;}#yiv4258468549 #yiv4258468549ygrp-mkp .yiv4258468549ad {padding:0 0;}#yiv4258468549 #yiv4258468549ygrp-mkp .yiv4258468549ad p {margin:0;}#yiv4258468549 #yiv4258468549ygrp-mkp .yiv4258468549ad a {color:#0000ff;text-decoration:none;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ygrp-lc {font-family:Arial;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ygrp-lc #yiv4258468549hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ygrp-lc .yiv4258468549ad {margin-bottom:10px;padding:0 0;}#yiv4258468549 #yiv4258468549actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4258468549 #yiv4258468549activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4258468549 #yiv4258468549activity span {font-weight:700;}#yiv4258468549 #yiv4258468549activity span:first-child {text-transform:uppercase;}#yiv4258468549 #yiv4258468549activity span a {color:#5085b6;text-decoration:none;}#yiv4258468549 #yiv4258468549activity span span {color:#ff7900;}#yiv4258468549 #yiv4258468549activity span .yiv4258468549underline {text-decoration:underline;}#yiv4258468549 .yiv4258468549attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4258468549 .yiv4258468549attach div a {text-decoration:none;}#yiv4258468549 .yiv4258468549attach img {border:none;padding-right:5px;}#yiv4258468549 .yiv4258468549attach label {display:block;margin-bottom:5px;}#yiv4258468549 .yiv4258468549attach label a {text-decoration:none;}#yiv4258468549 blockquote {margin:0 0 0 4px;}#yiv4258468549 .yiv4258468549bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4258468549 .yiv4258468549bold a {text-decoration:none;}#yiv4258468549 dd.yiv4258468549last p a {font-family:Verdana;font-weight:700;}#yiv4258468549 dd.yiv4258468549last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4258468549 dd.yiv4258468549last p span.yiv4258468549yshortcuts {margin-right:0;}#yiv4258468549 div.yiv4258468549attach-table div div a {text-decoration:none;}#yiv4258468549 div.yiv4258468549attach-table {width:400px;}#yiv4258468549 div.yiv4258468549file-title a, #yiv4258468549 div.yiv4258468549file-title a:active, #yiv4258468549 div.yiv4258468549file-title a:hover, #yiv4258468549 div.yiv4258468549file-title a:visited {text-decoration:none;}#yiv4258468549 div.yiv4258468549photo-title a, #yiv4258468549 div.yiv4258468549photo-title a:active, #yiv4258468549 div.yiv4258468549photo-title a:hover, #yiv4258468549 div.yiv4258468549photo-title a:visited {text-decoration:none;}#yiv4258468549 div#yiv4258468549ygrp-mlmsg #yiv4258468549ygrp-msg p a span.yiv4258468549yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4258468549 .yiv4258468549green {color:#628c2a;}#yiv4258468549 .yiv4258468549MsoNormal {margin:0 0 0 0;}#yiv4258468549 o {font-size:0;}#yiv4258468549 #yiv4258468549photos div {float:left;width:72px;}#yiv4258468549 #yiv4258468549photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4258468549 #yiv4258468549photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4258468549 #yiv4258468549reco-category {font-size:77%;}#yiv4258468549 #yiv4258468549reco-desc {font-size:77%;}#yiv4258468549 .yiv4258468549replbq {margin:4px;}#yiv4258468549 #yiv4258468549ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4258468549 #yiv4258468549ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4258468549 #yiv4258468549ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4258468549 #yiv4258468549ygrp-mlmsg select, #yiv4258468549 input, #yiv4258468549 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4258468549 #yiv4258468549ygrp-mlmsg pre, #yiv4258468549 code {font:115% monospace;}#yiv4258468549 #yiv4258468549ygrp-mlmsg * {line-height:1.22em;}#yiv4258468549 #yiv4258468549ygrp-mlmsg #yiv4258468549logo {padding-bottom:10px;}#yiv4258468549 #yiv4258468549ygrp-msg p a {font-family:Verdana;}#yiv4258468549 #yiv4258468549ygrp-msg p#yiv4258468549attach-count span {color:#1E66AE;font-weight:700;}#yiv4258468549 #yiv4258468549ygrp-reco #yiv4258468549reco-head {color:#ff7900;font-weight:700;}#yiv4258468549 #yiv4258468549ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ov li a {font-size:130%;text-decoration:none;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4258468549 #yiv4258468549ygrp-sponsor #yiv4258468549ov ul {margin:0;padding:0 0 0 8px;}#yiv4258468549 #yiv4258468549ygrp-text {font-family:Georgia;}#yiv4258468549 #yiv4258468549ygrp-text p {margin:0 0 1em 0;}#yiv4258468549 #yiv4258468549ygrp-text tt {font-size:120%;}#yiv4258468549 #yiv4258468549ygrp-vital ul li:last-child {border-right:none !important;}#yiv4258468549
Thanks,
- Michael
On Friday, November 3, 2017 10:07 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
This, like most add-in functions, do not change when you do an F9 to recalculate, because the add-in saves the web page first, then extracts the data from that saved copy of the web page. So using F9 to recalculate would just re-extract the data from the same saved copy of the web page. You would need to use the smfForceRecalculati
All of the dates in the JSON file are in UNIX format, not EXCEL serial date format. To convert:
=smfUNIX2Date(
You should be able to apply normal EXCEL date/time formats to the result.
I had planned to do that conversion in the function itself. However, Yahoo dropping the current quotes CSV file forced me to release the smfGetYahooPortfoli
On Fri, Nov 3, 2017 at 8:58 AM, Michael Henry midhenry1@... wrote:
Thanks for the pointer to the latest version. I get:Stock Market Functions add-in, Version 2.1.2017.11.
The sample worksheet also works.
However, how do I refresh the data? I heard mention of a macro.......
Also, the "Last Traded" data is a complete mystery to me. How is this translated into a time and date?
#yiv4258468549 #yiv4258468549 -- #yiv4258468549ygrp-
Fri Nov 3, 2017 10:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's in the add-in. I have it assigned to a button on my Quick Access
Toolbar.
See the write-up from the "FAQs and Tips" page on the web site.
On Fri, Nov 3, 2017 at 10:36 AM, Michael Henry midhenry1@
...
wrote:
>
> OK, makes sense, but how do I get the smfForceRecalculation macro ?
>
>
Toolbar.
See the write-up from the "FAQs and Tips" page on the web site.
On Fri, Nov 3, 2017 at 10:36 AM, Michael Henry midhenry1@
...
wrote:
>
> OK, makes sense, but how do I get the smfForceRecalculati
>
>
Fri Nov 3, 2017 10:46 am (PDT) . Posted by:
woodburydance
I see, this works perfectly - =smfGetYahooPortfolioView($B$4:$B$411, "01153034";,,0). I don't need the headers just the data.
Thank you for al of your hard work on this.
Sincerely,
Bruce
Thank you for al of your hard work on this.
Sincerely,
Bruce
Fri Nov 3, 2017 11:23 am (PDT) . Posted by:
eadamy
Writing content one item at a time takes a lot more resource than building the page in memory and writing it all at once. I would think that there would be no difference if requests were limited.
Earl
Earl
Fri Nov 3, 2017 11:36 am (PDT) . Posted by:
rcstrauss
Randy - Thanks for all you do to keep us in data. I am using your latest version of the smfGetPortfolioView()
function to get price and other data on about 40 securities. Everything works fine except for securities with on two letter symbols (GD, MO, PG, etc) that return --- for values. Are others having this problem and is there a fix?
Thnks
Rob
=smfGetYahooPortfolioView(S5:S8,T3:W3,,1) returns:
1 15 33 34 Ticker Symbol Symbol Last Price Dividends Per Share Dividend Yield MO O 55.25 2.51 4.74 GD -- -- -- -- PG -- -- -- -- O -- -- -- --
function to get price and other data on about 40 securities. Everything works fine except for securities with on two letter symbols (GD, MO, PG, etc) that return --- for values. Are others having this problem and is there a fix?
Thnks
Rob
=smfGetYahooPortfol
1 15 33 34 Ticker Symbol Symbol Last Price Dividends Per Share Dividend Yield MO O 55.25 2.51 4.74 GD -- -- -- -- PG -- -- -- -- O -- -- -- --
Fri Nov 3, 2017 12:09 pm (PDT) . Posted by:
rho49m
Sorry but where do I find the variables to choose which fields to download? Looked but didn't come up with anything. Maybe a little help and example file would help the less gifted?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar