3 Messages
Digest #4041
Messages
Mon May 29, 2017 1:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Do you need to do the workaround for the Microsoft security update?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Mon, May 29, 2017 at 11:34 AM, Leo Bueno Leo@
...wrote:
>
> I am seeing an odd behavior in the add-in.
>
>
>
> When I open an Excel 2010 spreadsheet which uses the add-in, for example,
> to get current prices of a list of stocks from Yahoo, the numbers do not
> update automatically.
>
>
>
> I have to toggle the add-in in order for it to work. That is, I have to
> follow this sequence of steps:
>
>
>
> File/Options/Add-Ins/Go then either check or uncheck the SMF-Add-In box.
>
>
>
> What am I doing wrong?
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Mon, May 29, 2017 at 11:34 AM, Leo Bueno Leo@
...wrote:
>
> I am seeing an odd behavior in the add-in.
>
>
>
> When I open an Excel 2010 spreadsheet which uses the add-in, for example,
> to get current prices of a list of stocks from Yahoo, the numbers do not
> update automatically.
>
>
>
> I have to toggle the add-in in order for it to work. That is, I have to
> follow this sequence of steps:
>
>
>
> File/Options/
>
>
>
> What am I doing wrong?
>
Mon May 29, 2017 2:12 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Randy - I downloaded the latest Beta version of the SMF. The following functions are not working:
=RCHGetYahooHistory(A1,,,,,,,"v",,,,1)To have the dividend history en reverse order. It gives me latest dividend first, it should give me latest dividend last.
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,1,2),1,2)To get the latest dividend, it gives me #ref
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,2,2),2,2)To get the second latest dividend, it gives me #ref
Regards, Jose L. Jacob
On Thursday, May 25, 2017 5:07 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
But you used May 14 as your ending date?
In any case, I'm not trusting monthly data that Yahoo is returning at this point.
I would suggest using smfPricesBetween(). For example:
| Ticker | Start Date | End Date | Close Date | Close Price | Open Price | High Price | Low Price | Volume |
| SPY | 2017-05-01 | 2017-05-24 | 2017-05-24 | $240.61 | $238.68 | $240.73 | $235.43 | 1254847500 |
The first three columns are the input. The last six are (headers and data):
=smfPricesBetween("Header",,,"070802040609")=smfPricesBetween(C11,D11,E11,"070802040609")
And the transpose work fine:
=TRANSPOSE(smfPricesBetween(C11,D11,E11,"070802040609"))
...returning:
| 2017-05-24 |
| $240.61 |
| $238.68 |
| $240.73 |
| $235.43 |
| 1254847500 |
On Thu, May 25, 2017 at 1:00 PM, lexstar@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Basically, I'm just trying to get the Date, OHLCV for the Month of May 1st to May 24th for SPY
#yiv8652079342 #yiv8652079342 -- #yiv8652079342ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8652079342 #yiv8652079342ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8652079342 #yiv8652079342ygrp-mkp #yiv8652079342hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8652079342 #yiv8652079342ygrp-mkp #yiv8652079342ads {margin-bottom:10px;}#yiv8652079342 #yiv8652079342ygrp-mkp .yiv8652079342ad {padding:0 0;}#yiv8652079342 #yiv8652079342ygrp-mkp .yiv8652079342ad p {margin:0;}#yiv8652079342 #yiv8652079342ygrp-mkp .yiv8652079342ad a {color:#0000ff;text-decoration:none;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ygrp-lc {font-family:Arial;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ygrp-lc #yiv8652079342hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ygrp-lc .yiv8652079342ad {margin-bottom:10px;padding:0 0;}#yiv8652079342 #yiv8652079342actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8652079342 #yiv8652079342activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8652079342 #yiv8652079342activity span {font-weight:700;}#yiv8652079342 #yiv8652079342activity span:first-child {text-transform:uppercase;}#yiv8652079342 #yiv8652079342activity span a {color:#5085b6;text-decoration:none;}#yiv8652079342 #yiv8652079342activity span span {color:#ff7900;}#yiv8652079342 #yiv8652079342activity span .yiv8652079342underline {text-decoration:underline;}#yiv8652079342 .yiv8652079342attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8652079342 .yiv8652079342attach div a {text-decoration:none;}#yiv8652079342 .yiv8652079342attach img {border:none;padding-right:5px;}#yiv8652079342 .yiv8652079342attach label {display:block;margin-bottom:5px;}#yiv8652079342 .yiv8652079342attach label a {text-decoration:none;}#yiv8652079342 blockquote {margin:0 0 0 4px;}#yiv8652079342 .yiv8652079342bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8652079342 .yiv8652079342bold a {text-decoration:none;}#yiv8652079342 dd.yiv8652079342last p a {font-family:Verdana;font-weight:700;}#yiv8652079342 dd.yiv8652079342last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8652079342 dd.yiv8652079342last p span.yiv8652079342yshortcuts {margin-right:0;}#yiv8652079342 div.yiv8652079342attach-table div div a {text-decoration:none;}#yiv8652079342 div.yiv8652079342attach-table {width:400px;}#yiv8652079342 div.yiv8652079342file-title a, #yiv8652079342 div.yiv8652079342file-title a:active, #yiv8652079342 div.yiv8652079342file-title a:hover, #yiv8652079342 div.yiv8652079342file-title a:visited {text-decoration:none;}#yiv8652079342 div.yiv8652079342photo-title a, #yiv8652079342 div.yiv8652079342photo-title a:active, #yiv8652079342 div.yiv8652079342photo-title a:hover, #yiv8652079342 div.yiv8652079342photo-title a:visited {text-decoration:none;}#yiv8652079342 div#yiv8652079342ygrp-mlmsg #yiv8652079342ygrp-msg p a span.yiv8652079342yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8652079342 .yiv8652079342green {color:#628c2a;}#yiv8652079342 .yiv8652079342MsoNormal {margin:0 0 0 0;}#yiv8652079342 o {font-size:0;}#yiv8652079342 #yiv8652079342photos div {float:left;width:72px;}#yiv8652079342 #yiv8652079342photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8652079342 #yiv8652079342photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8652079342 #yiv8652079342reco-category {font-size:77%;}#yiv8652079342 #yiv8652079342reco-desc {font-size:77%;}#yiv8652079342 .yiv8652079342replbq {margin:4px;}#yiv8652079342 #yiv8652079342ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8652079342 #yiv8652079342ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8652079342 #yiv8652079342ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8652079342 #yiv8652079342ygrp-mlmsg select, #yiv8652079342 input, #yiv8652079342 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8652079342 #yiv8652079342ygrp-mlmsg pre, #yiv8652079342 code {font:115% monospace;}#yiv8652079342 #yiv8652079342ygrp-mlmsg * {line-height:1.22em;}#yiv8652079342 #yiv8652079342ygrp-mlmsg #yiv8652079342logo {padding-bottom:10px;}#yiv8652079342 #yiv8652079342ygrp-msg p a {font-family:Verdana;}#yiv8652079342 #yiv8652079342ygrp-msg p#yiv8652079342attach-count span {color:#1E66AE;font-weight:700;}#yiv8652079342 #yiv8652079342ygrp-reco #yiv8652079342reco-head {color:#ff7900;font-weight:700;}#yiv8652079342 #yiv8652079342ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ov li a {font-size:130%;text-decoration:none;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8652079342 #yiv8652079342ygrp-sponsor #yiv8652079342ov ul {margin:0;padding:0 0 0 8px;}#yiv8652079342 #yiv8652079342ygrp-text {font-family:Georgia;}#yiv8652079342 #yiv8652079342ygrp-text p {margin:0 0 1em 0;}#yiv8652079342 #yiv8652079342ygrp-text tt {font-size:120%;}#yiv8652079342 #yiv8652079342ygrp-vital ul li:last-child {border-right:none !important;}#yiv8652079342
=RCHGetYahooHistory(A1,,,,,,,"v",,,,1)To have the dividend history en reverse order. It gives me latest dividend first, it should give me latest dividend last.
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,1,2),1,2)To get the latest dividend, it gives me #ref
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,2,2),2,2)To get the second latest dividend, it gives me #ref
Regards, Jose L. Jacob
On Thursday, May 25, 2017 5:07 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
But you used May 14 as your ending date?
In any case, I'm not trusting monthly data that Yahoo is returning at this point.
I would suggest using smfPricesBetween(). For example:
| Ticker | Start Date | End Date | Close Date | Close Price | Open Price | High Price | Low Price | Volume |
| SPY | 2017-05-01 | 2017-05-24 | 2017-05-24 | $240.61 | $238.68 | $240.73 | $235.43 | 1254847500 |
The first three columns are the input. The last six are (headers and data):
=smfPricesBetween("Header",,,"070802040609")=smfPricesBetween(C11,D11,E11,"070802040609")
And the transpose work fine:
=TRANSPOSE(smfPricesBetween(C11,D11,E11,"070802040609"))
...returning:
| 2017-05-24 |
| $240.61 |
| $238.68 |
| $240.73 |
| $235.43 |
| 1254847500 |
On Thu, May 25, 2017 at 1:00 PM, lexstar@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Basically, I'm just trying to get the Date, OHLCV for the Month of May 1st to May 24th for SPY
#yiv8652079342 #yiv8652079342 -- #yiv8652079342ygrp-
Mon May 29, 2017 2:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Mon, May 29, 2017 at 1:58 PM, Jose Jacob pepecan47@
...wrote:
>
> Hi Randy - I downloaded the latest Beta version of the SMF. The following
> functions are not working:
>
> =RCHGetYahooHistory(A1,,,,,,,"v",,,,1)
> To have the dividend history en reverse order. It gives me latest dividend
> first, it should give me latest dividend last.
>
Required a program fix, as the function was hitting an error before the
sorting routine was done.
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,1,2),1,2)
> To get the latest dividend, it gives me #ref
>
This works for me?
> =
>
> INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,2,2),2,2)
> To get the second latest dividend, it gives me #ref
>
This also works for me?
What ticker did you use for them?
...wrote:
>
> Hi Randy - I downloaded the latest Beta version of the SMF. The following
> functions are not working:
>
> =RCHGetYahooHistory
> To have the dividend history en reverse order. It gives me latest dividend
> first, it should give me latest dividend last.
>
Required a program fix, as the function was hitting an error before the
sorting routine was done.
=INDEX(RCHGetYahooH
> To get the latest dividend, it gives me #ref
>
This works for me?
> =
>
> INDEX(RCHGetYahooHi
> To get the second latest dividend, it gives me #ref
>
This also works for me?
What ticker did you use for them?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar