Kamis, 02 November 2017

[smf_addin] Digest Number 4193

15 Messages

Digest #4193
1b
Re: SMFgetyahooportfolioview usage? by "Randy Harmelink" rharmelink
2a
Re: smfGetYahooPortfolioView stopped working by "Randy Harmelink" rharmelink
3a
Re: smfPricesByDates by "Randy Harmelink" rharmelink
3b
Re: smfPricesByDates by "Michael Henry" midhenry1
3c
Re: smfPricesByDates by "Randy Harmelink" rharmelink
3d
4b
Re: Using smfGetYahooPortfolioView by "Randy Harmelink" rharmelink
5a
Re: Function Help by "Randy Harmelink" rharmelink
6a
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
6b
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink
6c
Re: RCHGetYahooQuotes(B6:B50,C4:V4) by "Randy Harmelink" rharmelink

Messages

Thu Nov 2, 2017 9:42 am (PDT) . Posted by:

john_hoel

I tried array entry and it was not reliable. Can you think of a workaround with array entry that is reliable?

Thu Nov 2, 2017 10:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hopefully fixed now:
https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171102.html

Sorry.

On Thu, Nov 2, 2017 at 9:42 AM, johnhoel1248@
​...
wrote:

>
> I tried array entry and it was not reliable. Can you think of a workaround
> with array entry that is reliable?
>
>
>

Thu Nov 2, 2017 9:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That was related to them changing the historical quotes process last May.

On Thu, Nov 2, 2017 at 9:39 AM, jaroldm70@
​...
wrote:

>
> Check this out........https://stackoverflow.com/questions/
> 44057580/yahoo-finance-api-changes-2017
>
> May have to use Google as data source?
>

Thu Nov 2, 2017 9:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't visualize what you're trying to do from what you posted.

Specific formula please, and over what range you are entering it.

To go vertical, you would need to transpose() the returned data. One of the
templates on the website has such an example.

On Thu, Nov 2, 2017 at 9:27 AM, royy22@
​...
wrote:

>
> smfPricesByDates works fine for me with the dates across columns left to
> right and the results left to right across columns (eg, horizontal),
> however, when I run it Vertical (col of date, col of results) I get the
> first price propagated across all dates. Am I misreading the
> documentation, cause it sounds like that should work?
> Thanks for any tips on the solving this.
>
>
> PricebyDates NOT WORKING Vertical!
>
> Date
>
>
> PriceByDates 9/30/17 AAPL 154.12 8/31/17
>
>
> 154.12 7/31/17
>
>
> 154.12 6/30/17
>
>
> 154.12 5/31/17 154.12
>
>
>
>

Thu Nov 2, 2017 10:23 am (PDT) . Posted by:

"Michael Henry" midhenry1

Randy,
Is there a workaround beyond:Stock Market Functions add-in, Version 2.1.2017.10.24 (C:\SMF Add-in; Windows (32-bit) NT 10.00; 16.0; ; ; 1) ?

If so, I can't locate it.  If it exists, would you please provide directions for finding it?
Thanks,
 - Michael

On Thursday, November 2, 2017, 9:44:33 AM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

I can't visualize what you're trying to do from what you posted.
Specific formula please, and over what range you are entering it.
To go vertical, you would need to transpose() the returned data. One of the templates on the website has such an example.
On Thu, Nov 2, 2017 at 9:27 AM, royy22@​... wrote:

smfPricesByDates works fine for me with the dates across columns left to right and the results left to right across columns (eg, horizontal), however, when I run it Vertical (col of date, col of results) I get the first price propagated across all dates.  Am I misreading the documentation, cause it sounds like that should work?
Thanks for any tips on the solving this.

| PricebyDates NOT WORKING Vertical!

Date


PriceByDates 9/30/17 AAPL     154.12 8/31/17


154.12 7/31/17


154.12 6/30/17


154.12 5/31/17       154.12 |

#yiv8649900376 #yiv8649900376 -- #yiv8649900376ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8649900376 #yiv8649900376ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8649900376 #yiv8649900376ygrp-mkp #yiv8649900376hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8649900376 #yiv8649900376ygrp-mkp #yiv8649900376ads {margin-bottom:10px;}#yiv8649900376 #yiv8649900376ygrp-mkp .yiv8649900376ad {padding:0 0;}#yiv8649900376 #yiv8649900376ygrp-mkp .yiv8649900376ad p {margin:0;}#yiv8649900376 #yiv8649900376ygrp-mkp .yiv8649900376ad a {color:#0000ff;text-decoration:none;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ygrp-lc {font-family:Arial;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ygrp-lc #yiv8649900376hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ygrp-lc .yiv8649900376ad {margin-bottom:10px;padding:0 0;}#yiv8649900376 #yiv8649900376actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8649900376 #yiv8649900376activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8649900376 #yiv8649900376activity span {font-weight:700;}#yiv8649900376 #yiv8649900376activity span:first-child {text-transform:uppercase;}#yiv8649900376 #yiv8649900376activity span a {color:#5085b6;text-decoration:none;}#yiv8649900376 #yiv8649900376activity span span {color:#ff7900;}#yiv8649900376 #yiv8649900376activity span .yiv8649900376underline {text-decoration:underline;}#yiv8649900376 .yiv8649900376attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8649900376 .yiv8649900376attach div a {text-decoration:none;}#yiv8649900376 .yiv8649900376attach img {border:none;padding-right:5px;}#yiv8649900376 .yiv8649900376attach label {display:block;margin-bottom:5px;}#yiv8649900376 .yiv8649900376attach label a {text-decoration:none;}#yiv8649900376 blockquote {margin:0 0 0 4px;}#yiv8649900376 .yiv8649900376bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8649900376 .yiv8649900376bold a {text-decoration:none;}#yiv8649900376 dd.yiv8649900376last p a {font-family:Verdana;font-weight:700;}#yiv8649900376 dd.yiv8649900376last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8649900376 dd.yiv8649900376last p span.yiv8649900376yshortcuts {margin-right:0;}#yiv8649900376 div.yiv8649900376attach-table div div a {text-decoration:none;}#yiv8649900376 div.yiv8649900376attach-table {width:400px;}#yiv8649900376 div.yiv8649900376file-title a, #yiv8649900376 div.yiv8649900376file-title a:active, #yiv8649900376 div.yiv8649900376file-title a:hover, #yiv8649900376 div.yiv8649900376file-title a:visited {text-decoration:none;}#yiv8649900376 div.yiv8649900376photo-title a, #yiv8649900376 div.yiv8649900376photo-title a:active, #yiv8649900376 div.yiv8649900376photo-title a:hover, #yiv8649900376 div.yiv8649900376photo-title a:visited {text-decoration:none;}#yiv8649900376 div#yiv8649900376ygrp-mlmsg #yiv8649900376ygrp-msg p a span.yiv8649900376yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8649900376 .yiv8649900376green {color:#628c2a;}#yiv8649900376 .yiv8649900376MsoNormal {margin:0 0 0 0;}#yiv8649900376 o {font-size:0;}#yiv8649900376 #yiv8649900376photos div {float:left;width:72px;}#yiv8649900376 #yiv8649900376photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8649900376 #yiv8649900376photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8649900376 #yiv8649900376reco-category {font-size:77%;}#yiv8649900376 #yiv8649900376reco-desc {font-size:77%;}#yiv8649900376 .yiv8649900376replbq {margin:4px;}#yiv8649900376 #yiv8649900376ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8649900376 #yiv8649900376ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8649900376 #yiv8649900376ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8649900376 #yiv8649900376ygrp-mlmsg select, #yiv8649900376 input, #yiv8649900376 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8649900376 #yiv8649900376ygrp-mlmsg pre, #yiv8649900376 code {font:115% monospace;}#yiv8649900376 #yiv8649900376ygrp-mlmsg * {line-height:1.22em;}#yiv8649900376 #yiv8649900376ygrp-mlmsg #yiv8649900376logo {padding-bottom:10px;}#yiv8649900376 #yiv8649900376ygrp-msg p a {font-family:Verdana;}#yiv8649900376 #yiv8649900376ygrp-msg p#yiv8649900376attach-count span {color:#1E66AE;font-weight:700;}#yiv8649900376 #yiv8649900376ygrp-reco #yiv8649900376reco-head {color:#ff7900;font-weight:700;}#yiv8649900376 #yiv8649900376ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ov li a {font-size:130%;text-decoration:none;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8649900376 #yiv8649900376ygrp-sponsor #yiv8649900376ov ul {margin:0;padding:0 0 0 8px;}#yiv8649900376 #yiv8649900376ygrp-text {font-family:Georgia;}#yiv8649900376 #yiv8649900376ygrp-text p {margin:0 0 1em 0;}#yiv8649900376 #yiv8649900376ygrp-text tt {font-size:120%;}#yiv8649900376 #yiv8649900376ygrp-vital ul li:last-child {border-right:none !important;}#yiv8649900376

Thu Nov 2, 2017 10:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

A workaround for what? smfPricesByDates()? I'm confused.

I have no idea what you're asking now...

On Thu, Nov 2, 2017 at 10:18 AM, Michael Henry midhenry1@
​...
wrote:

>
> Is there a workaround beyond:
> Stock Market Functions add-in, Version 2.1.2017.10.24 (C:\SMF Add-in;
> Windows (32-bit) NT 10.00; 16.0; ; ; 1) ?
>
> If so, I can't locate it. If it exists, would you please provide
> directions for finding it?
>
>
>

Thu Nov 2, 2017 11:13 am (PDT) . Posted by:

midhenry1

Is there a version of Stock Market Functions add-in, beyond Version 2.1.2017.10.24?

If so, how can I find it?


Thanks,


- Michael

Thu Nov 2, 2017 10:15 am (PDT) . Posted by:

bob_15861586

Randy,

Thanks for the response. Can you tell me how to get 10 stock quotes at the same time or even better point me to some documentation on the function smfGetYahooPortfolioView?


Thank you very much.


Bob Sherry

Thu Nov 2, 2017 10:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The example in the blog entry is almost what you need:

=smfGetYahooPortfolioView("MMM,IBM","010215&quot;,,1)

Just do the 10 ticker symbols there. You could also refer to a range of
ticker symbols. I would suggest always having the function return the
ticker symbol, because Yahoo returns nothing for ticker symbols it doesn't
have data for. So it won't be "one in, one out".

On Thu, Nov 2, 2017 at 10:15 AM, bob_15861586@
​...
wrote:

>
> Thanks for the response. Can you tell me how to get 10 stock quotes at the
> same time or even better point me to some documentation on the function
> smfGetYahooPortfolioView?
>
> Thank you very much.
>
>

Thu Nov 2, 2017 10:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should be able to use the smfGetYahooPortfolioView() for the first two.
Use the "Last Traded" time. Use the smfUNIX2Date() on the number returned
and it should have both the date and time in it. You can format that result
as you want it. If you need it as text, use the TEXT() function. Note that
you may need to adjust the time based on your time zone.

For EBITDA, you'd probably need to use the RCHGetElementNumber() function.
That could be slow for a lot of tickers.

On Thu, Nov 2, 2017 at 7:45 AM, codyklein@
​...
wrote:

> Anyone have a formula to get the following:
>
> 1-Time of last trade as a text value format 9:30 AM
>
> 2-Date of last trade as text
>
> 3- EBITDA
>

Thu Nov 2, 2017 10:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to fix the unresolved link, because your add-in is in a different
location than mine. Use the smfFixLinks macro.

On Thu, Nov 2, 2017 at 7:57 AM, weldencd@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm trying to figure out how to use this function. I previously used
> RCHGetYahooQuotes. It's worked for many years and is a godsend.
>
> I've downloaded the new ZIP file, V 2017.10.31 and installed it and
> downloaded the example spreadsheet, smfGetYahooPortfolioView-Example.xls.
> <http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls>
>
> I can't seem to figure out how to add additional stock symbols to the
> list. When the example spreadsheet first loads, all the fields are
> populated. If I add a stock symbol in B7, I immediately get #NAME? in all
> cells. The contents of all cells are
>
> ='D:\SMF Add-in\RCH_Stock_Market_Functions.xla'!
> smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
> Can someone give me a few clues about where to go from here? TIA
>

Thu Nov 2, 2017 10:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

New release should fix that:
https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171102.html

That ticker symbol showed that two of my assumptions about the data were
incorrect:

1. That any given ticker symbol's data would only be 1200 bytes in length.
I've upped that to 2000 now.
2. That the data would be comma-delimited. MPC has a comma within the name,
so it burped.

Sorry about the problem. I was wondering why I was getting issue on and
off. Those two assumptions were the problem. Thanks.

On Thu, Nov 2, 2017 at 8:06 AM, msdalt@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, Randy. I have updated two workbooks with new arrays & references
> and they seem to be working quite well. I did find one anomaly, however.
> It does not require immediate attention but I thought you might find it
> interesting.
>
> When I put in the symbol for Marathon Petroleum, "MPC", I get its
> information but all securities below it in the list are unable to access
> their data. I have tried this on several worksheets and consistently
> encounter the malfunction. I have relocated MPC's symbol to the end of the
> list as a workaround but thought you might want to know about this.
>
>

Thu Nov 2, 2017 10:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry about the problem. I can't blame Yahoo for this one. I had a few
assumptions about the data that were incorrect.

https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171102.html

On Thu, Nov 2, 2017 at 8:47 AM, johnhoel1248@
​...
wrote:

>
> My problem sounds like this except that I can sometimes get more data
> back. I suspect the specific symbol is not the real issue. I think Yahoo is
> dynamically throttling.
>

Thu Nov 2, 2017 10:54 am (PDT) . Posted by:

rr76012

Thu 11/2/2017
re; rchgetyahooquotes




Howdy Randy,


Today this: =RCHGetYahooQuotes("MMM","l1") stopped working?


rchgetyahooquotges does not show up in the drop down list once I start typing: = rchgetyahooquotes.


It does not show up in the drop down list list?


Also "Happy Holidays".


rene


Thu Nov 2, 2017 10:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure why the function isn't showing up in the drop-down list. It is
here.

As for the problems with function itself, see the recent announcements on
the blog:

https://smf-add-in.blogspot.com/

Happy holidays to you too. :)

On Thu, Nov 2, 2017 at 10:54 AM, rr76012@
​...
wrote:

>
> Thu 11/2/2017
> re; rchgetyahooquotes
>
>
> Howdy Randy,
>
> Today this: =RCHGetYahooQuotes("MMM","l1") stopped working?
>
> rchgetyahooquotges does not show up in the drop down list once I start
> typing: = rchgetyahooquotes.
>
> It does not show up in the drop down list list?
>
> Also "Happy Holidays".
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar