15 Messages
Digest #4200
Messages
Fri Nov 3, 2017 9:26 am (PDT) . Posted by:
timbowers23
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?
Thanks
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?
Thanks
Fri Nov 3, 2017 9:27 am (PDT) . Posted by:
peculiar_investing
Adding my thanks to Randy for his efforts on this, very much appreciated.
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.
There are a couple of data fields that were available in RCHGetYahooQuote(
Thanks in advance for your consideration of these changes.
Fri Nov 3, 2017 9:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Should be there already...but Yahoo doesn't really update them very quickly.
On Fri, Nov 3, 2017 at 5:24 AM, msdalt@
...
wrote:
>
> x-dividend date would be valuable, at least to me.
>
>
>
On Fri, Nov 3, 2017 at 5:24 AM, msdalt@
...
wrote:
>
> x-dividend date would be valuable, at least to me.
>
>
>
Fri Nov 3, 2017 9:34 am (PDT) . Posted by:
rr76012
Friday 11/3.2017
re: request to add P/BV metric to the smfGetYahooPortfolio function.
Hello Randy,
Thank you for all your very hard work and happy holidays.
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".
Thanks,
rr76012
re: request to add P/BV metric to the smfGetYahooPortfoli
Hello Randy,
Thank you for all your very hard work and happy holidays.
If possible could/would you add to your " smfGetYahooPortfoli
I noticed you have the "Price/
I know you are extremely busy and presently working on the "smfGetYahooPo
Thanks,
rr76012
Fri Nov 3, 2017 9:37 am (PDT) . Posted by:
"Dennis Sesar" dennis@zis.com
Dennis Sesar
18757 Burbank Blvd., Ste 116
Tarzana, CA 91356
Tel: 310.826.8634/818.206.8634 Ext 114
dennis@zis.com <mailto:dennis@zis.com>
Fri Nov 3, 2017 9:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, the default suffix handling produce outputs in thousands
(because that's what I needed it to do on financial statements when I first
wrote the processing). However, you can do it yourself if you know the
suffixes. This was a convoluted one because of HTML code in the cell as
well.
Try something like:
=smfEval(SUBSTITUTE(SUBSTITUTE(smfStrExtr(smfGetTagContent("
https://finviz.com/quote.ashx?t=MMM","td",1,">Avg
Volume"),">","<"),"K","*1000"),"M","*1000000"))
On Fri, Nov 3, 2017 at 7:05 AM, friedman_steve@
...
wrote:
> I have the following formula that grabs avg volume:
>
> =RCHGetTableCell("http:// finviz.com/quote.ashx?t=
> <http://finviz.com/quote.ashx?t=>"&smfJoin("okta",","),1,"?t="&"okta";&"&",">"&"Avg
> Volume")
>
> sometimes the website posts number with K at end, and sometimes with M
> (for thousand or million).
> I can't figure out how to adjust code below so I grab in consistent manner
> (so the number is always in thousands or millions)?
>
>
>
(because that's what I needed it to do on financial statements when I first
wrote the processing). However, you can do it yourself if you know the
suffixes. This was a convoluted one because of HTML code in the cell as
well.
Try something like:
=smfEval(SUBSTITUTE(SUBSTITUTE(smfStrExtr(smfGetTagContent("
https://finviz.com/quote.ashx?t=MMM","td",1,">Avg
Volume"),">","<"),"K","*1000"),"M","*1000000"))
On Fri, Nov 3, 2017 at 7:05 AM, friedman_steve@
...
wrote:
> I have the following formula that grabs avg volume:
>
> =RCHGetTableCell("http:// finviz.com/quote.ashx?t=
> <http://finviz.com/quote.ashx?t=>"&smfJoin(
> Volume"
>
> sometimes the website posts number with K at end, and sometimes with M
> (for thousand or million).
> I can't figure out how to adjust code below so I grab in consistent manner
> (so the number is always in thousands or millions)?
>
>
>
Fri Nov 3, 2017 9:40 am (PDT) . Posted by:
bob_15861586
I am using smfGetYahooPortfolioView and I am not getting updates. Should I post a sample spread sheet?
Bob
Bob
Fri Nov 3, 2017 9:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but registering for a website just to look at that is a bit beyond
what I'm willing to do. Especially with everything that is going on right
now.
On Fri, Nov 3, 2017 at 7:56 AM, jxstein@
...
wrote:
>
> Hi Randy, I want to thank you for all the work you do sharing such a
> wonderful add-in.
> Since Yahoo.com has changed so much I was wondering if you could provide
> me with a simple page extract from:
> https://www.theglobeandmail.com/globe-investor/my-watchlist/?ord=1
> this page require free registration.
> Please have a look,it would permit to extract, latest price and volume if
> needed.
>
> I am a simple investor with limited knowledge of this subjects.
> I can install the add-in in Excel, but no much more.
> It is for stocks only but can include US and Canadian tickers, no options.
>
> Thank you once again for what you provide us.
> P.S. For US stocks I am using the Excel feature called RTD with a link to
> my Broker, but this doesn't work with Canadian tickers.
>
>
>
what I'm willing to do. Especially with everything that is going on right
now.
On Fri, Nov 3, 2017 at 7:56 AM, jxstein@
...
wrote:
>
> Hi Randy, I want to thank you for all the work you do sharing such a
> wonderful add-in.
> Since Yahoo.com has changed so much I was wondering if you could provide
> me with a simple page extract from:
> https://www.theglobeandmail.com/globe-investor/my-watchlist/?ord=1
> this page require free registration.
> Please have a look,it would permit to extract, latest price and volume if
> needed.
>
> I am a simple investor with limited knowledge of this subjects.
> I can install the add-in in Excel, but no much more.
> It is for stocks only but can include US and Canadian tickers, no options.
>
> Thank you once again for what you provide us.
> P.S. For US stocks I am using the Excel feature called RTD with a link to
> my Broker, but this doesn't work with Canadian tickers.
>
>
>
Fri Nov 3, 2017 9:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. I use Chrome and it comes up OK, but it may be because of some
extension I have. I see the gibberish first. It just flashes by, but then
goes to a more reasonable page showing me the blog entries and asks if I
want to subscribe.
On Fri, Nov 3, 2017 at 6:52 AM, earladamy@
...
wrote:
>
> Thanks. I had found the Subscribe to but it brought up gibberish (in
> Chrome). I just tried it in FireFox and it provides an active bookmark.
> Retried it in Chrome and same gibberish. If I'm not mistaken, Google owns
> Blogspot ... go figure.
>
>
extension I have. I see the gibberish first. It just flashes by, but then
goes to a more reasonable page showing me the blog entries and asks if I
want to subscribe.
On Fri, Nov 3, 2017 at 6:52 AM, earladamy@
...
wrote:
>
> Thanks. I had found the Subscribe to but it brought up gibberish (in
> Chrome). I just tried it in FireFox and it provides an active bookmark.
> Retried it in Chrome and same gibberish. If I'm not mistaken, Google owns
> Blogspot ... go figure.
>
>
Fri Nov 3, 2017 9:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
My first guess would be that the add-in isn't loaded. What do you get with:
=RCHGetElementNumber("Version")
On Fri, Nov 3, 2017 at 6:03 AM, weldencd@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Sorry I have to ask for help again. I had my spreadsheet working
> yesterday, but this morning all cells are returning #NAME?. Any ideas?
>
>
>
=RCHGetElementNumber("Version")
On Fri, Nov 3, 2017 at 6:03 AM, weldencd@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Sorry I have to ask for help again. I had my spreadsheet working
> yesterday, but this morning all cells are returning #NAME?. Any ideas?
>
>
>
Fri Nov 3, 2017 9:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your parameters aren't correct. You seem to be passing the desired data
items twice?
The first two parameters are the ticker list and the item list.
The third parameter isn't used any more, so is irrelevant.
The fourth parameter indicates whether you want headers on the returned
data (1=yes, 0=no).
But you are passing five parameters, and the 2nd and 3rd parameters both
look like data item specifications?
On Fri, Nov 3, 2017 at 6:36 AM, bameyer@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> As a test I added the following to your smfGetYahooPortfolioView-Example.xls
> example spreadsheet. I added
>
> =smfGetYahooPortfolioView($B$4:$B$411,$AK4:AN411, "01153034";,,1) to cell
> AK4 right next to the end of your data. I set it up as an array but all I
> get is "--" in all the cells in column AK through AN. I just don't see my
> mistake.
>
items twice?
The first two parameters are the ticker list and the item list.
The third parameter isn't used any more, so is irrelevant.
The fourth parameter indicates whether you want headers on the returned
data (1=yes, 0=no).
But you are passing five parameters, and the 2nd and 3rd parameters both
look like data item specifications?
On Fri, Nov 3, 2017 at 6:36 AM, bameyer@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> As a test I added the following to your smfGetYahooPortfoli
> example spreadsheet. I added
>
> =smfGetYahooPortfol
> AK4 right next to the end of your data. I set it up as an array but all I
> get is "--" in all the cells in column AK through AN. I just don't see my
> mistake.
>
Fri Nov 3, 2017 9:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I suspect it is based on how you mean "since trading began". 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.
Also, you need to make sure your Internet Options are set to always get a
fresh copy of a web page, otherwise the Microsoft Internet engine that
EXCEL and the add-in use to get the data may end up getting a cached copy
of the web page that IE has saved.
On Fri, Nov 3, 2017 at 8:32 AM, ori@ors.co.il [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I seem to get a not so updated price quote, it seems I am getting the
> opening price instead of the current or 20 minute delayed price.
> for example for the string:
> =smfGetYahooPortfolioView("CBL","15")
>
> I am getting the price of 6.10 since trading began.
> The same thing happens with all tickers.
>
>
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.
Also, you need to make sure your Internet Options are set to always get a
fresh copy of a web page, otherwise the Microsoft Internet engine that
EXCEL and the add-in use to get the data may end up getting a cached copy
of the web page that IE has saved.
On Fri, Nov 3, 2017 at 8:32 AM, ori@ors.co.il [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I seem to get a not so updated price quote, it seems I am getting the
> opening price instead of the current or 20 minute delayed price.
> for example for the string:
> =smfGetYahooPortfol
>
> I am getting the price of 6.10 since trading began.
> The same thing happens with all tickers.
>
>
Fri Nov 3, 2017 10:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
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?
>
>
>
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
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(
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
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.
> 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?
>
>
>
Fri Nov 3, 2017 10:01 am (PDT) . Posted by:
hedgefundit
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:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Which version of the add-in are you using?
=RCHGetElementNumber("Version")
What are your first half-dozen tickers? Does it work OK just with them?
On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> The same spreadsheet with smfGetYahooPortfolioView function was working
> fine earlier in the day...now only for the first 2 rows, it returned all
> values...I have around 135 US stock symbols in this spreadsheet. anything
> I am missing?
>
>
=RCHGetElementNumber("Version")
What are your first half-dozen tickers? Does it work OK just with them?
On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> The same spreadsheet with smfGetYahooPortfoli
> fine earlier in the day...now only for the first 2 rows, it returned all
> values...I have around 135 US stock symbols in this spreadsheet. anything
> I am missing?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar