Selasa, 04 Oktober 2016

[smf_addin] Digest Number 3810

6 Messages

Digest #3810

Messages

Mon Oct 3, 2016 10:19 am (PDT) . Posted by:

eclipsme

I am using RCHGetYahooQuotes with the NOW() parameter to receive an array of current stock prices. I then have separate workbooks for each account I am monitoring. This works so much faster than using Excel's web connect feature!

However, I cannot figure how to make RCHGetYahooQuotes automatically update. Certainly, if I change a cell in this sheet, it will update, but I need it to update, say every 5 minutes, even if it isn't the current sheet (though it is open, just not the current one).

How can I get RCHGetYahooQuotes to update every 5 minutes?

Thanks,
Harvey

Mon Oct 3, 2016 10:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's a template that shows an example of a timed update -- Copy of
RCHGetYahooQuotes-Example-Timed-Update.xls:

http://ogres-crypt.com/SMF/Templates/#RCHGetYahooQuotes()

...and it doesn't need the NOW() coding because it uses the
smfForceRecalculation macro to update everything.

I've switched my main quotes workbooks over to the
smfGetYahooPortfolioView() function, because it gives real time stock
quotes, and also has delayed options quotes (which were dropped from
Yahoo's CSV interface years ago, which meant RCHGetYahooQuotes() could no
longer get them). The only real drawback to smfGetYahooPortfolioView() is
that it requires a Yahoo security cookie to be in place if you want to use
fields that aren't available on the default Yahoo views. Unfortunately,
none of the default views have bid or ask prices.

Quick question -- why the need to update automatically? Doesn't it update
quickly enough when you NEED to look at the data? I designed my main
portfolio workbook so I only use one smfGetYahooPortfolioView() function.
That single function is the only Internet access the workbook has. So it
updates very quickly when I run the smfForceRecalculation macro via a
button on my quick access toolbar. Any other worksheets refer to that
worksheet for their data.

If you have a number of data items accessed with something like
RCHGetElementNumber() or smfGetTagContent(), you could put those in a
worksheet updated via the smfUpdateDownloadTable macro, so that it only
refreshes the data when you specifically update it -- and you can request
updates for a specific range of data as well, even by columns or rows.

On Mon, Oct 3, 2016 at 10:10 AM, harvey@
​... wrote:

>
> I am using RCHGetYahooQuotes with the NOW() parameter to receive an array
> of current stock prices. I then have separate workbooks for each account I
> am monitoring. This works so much faster than using Excel's web connect
> feature!
>
> However, I cannot figure how to make RCHGetYahooQuotes automatically
> update. Certainly, if I change a cell in this sheet, it will update, but I
> need it to update, say every 5 minutes, even if it isn't the current sheet
> (though it is open, just not the current one).
>
> How can I get RCHGetYahooQuotes to update every 5 minutes?
>

Mon Oct 3, 2016 12:30 pm (PDT) . Posted by:

eclipsme

"Quick question -- why the need to update automatically? Doesn't it update quickly enough when you NEED to look at the data? I designed my main portfolio workbook so I only use one smfGetYahooPortfolioView() function. That single function is the only Internet access the workbook has. So it updates very quickly when I run the smfForceRecalculation macro via a button on my quick access toolbar. Any other worksheets refer to that worksheet for their data. :

Yes, this is more like what I am doing. The problem is right now I have to switch to the worksheet that has the quotes before I can update - with the f9 key. I just wanted the auto update function so I didn't have to keep switching.

Where can I get this macro?

Mon Oct 3, 2016 1:34 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The smfForceRecalculation macro is contained with the add-in. When you run
it, it updates all add-in formulas in all open workbooks, so there would be
no reason to move to the worksheet before triggering an update. But you'd
want to be careful what workbooks you have open...

This link for that macro is from the "FAQs and Tips" page on the website:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625

On Mon, Oct 3, 2016 at 12:30 PM, harvey@
​...wrote:

>
> "Quick question -- why the need to update automatically? Doesn't it update
> quickly enough when you NEED to look at the data? I designed my main
> portfolio workbook so I only use one smfGetYahooPortfolioView() function.
> That single function is the only Internet access the workbook has. So it
> updates very quickly when I run the smfForceRecalculation macro via a
> button on my quick access toolbar. Any other worksheets refer to that
> worksheet for their data. :
>
> Yes, this is more like what I am doing. The problem is right now I have to
> switch to the worksheet that has the quotes before I can update - with the
> f9 key. I just wanted the auto update function so I didn't have to keep
> switching.
>
> Where can I get this macro?
>

Mon Oct 3, 2016 6:50 pm (PDT) . Posted by:

"Jonathan" jbr863

Apologies if this is a dumb question but how do I "Make sure your Internet Options are set to always get a fresh web page when one is requested"?  I have noted that sWebCache = "Y" in smfGetWebPage, if that's what you mean.

On Saturday, October 1, 2016 2:18 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  I get results similar to the previous for UVE on 2017-05-19:

| UVE | UVE | UVE |
| 2017-05-19 | 2017-05-19 | 2017-05-19 |
| C | C | C |
| Y | G | OX |
|   |   |   |
|   |   |   |
|   |   | $12.50 |
|   |   | $15.00 |
|   |   | $17.50 |
|   |   | $20.00 |
| $22.50 |   | $22.50 |
| $25.00 |   | $25.00 |
| $30.00 |   | $30.00 |
|   |   | $35.00 |
|   |   |   |
|   |   |   |
|   |   |   |
|   |   |   |
|   |   |   |
|   |   |   |

Number of puts and strikes shouldn't matter, since the function returns one or the other. Although OptionsXPress returns the same strike prices for both puts and calls. Yahoo only returns one strike price. But that's all they have on their web page right now, so that's to be expected.

I doubt it will have more when the market is open.

I've had a limit price on an option at my broker for a call that doesn't exist on Yahoo. I placed that limit order several weeks ago. I doubt it will ever show up on Yahoo. :(

Make sure your Internet Options are set to always get a fresh web page when one is requested, then try again by running the smfForceRecalculation macro.

On Sat, Oct 1, 2016 at 1:45 AM, Jonathan jbr863@​...wrote:

Odd.  The specific stock I was testing is "UVE" @ "5/19/2017&quot;.  I still get nothing for any of the sources.  Is the problem related to the uneven number of put and call strikes available? 

#yiv0756848694 #yiv0756848694 -- #yiv0756848694ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0756848694 #yiv0756848694ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0756848694 #yiv0756848694ygrp-mkp #yiv0756848694hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0756848694 #yiv0756848694ygrp-mkp #yiv0756848694ads {margin-bottom:10px;}#yiv0756848694 #yiv0756848694ygrp-mkp .yiv0756848694ad {padding:0 0;}#yiv0756848694 #yiv0756848694ygrp-mkp .yiv0756848694ad p {margin:0;}#yiv0756848694 #yiv0756848694ygrp-mkp .yiv0756848694ad a {color:#0000ff;text-decoration:none;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ygrp-lc {font-family:Arial;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ygrp-lc #yiv0756848694hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ygrp-lc .yiv0756848694ad {margin-bottom:10px;padding:0 0;}#yiv0756848694 #yiv0756848694actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0756848694 #yiv0756848694activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0756848694 #yiv0756848694activity span {font-weight:700;}#yiv0756848694 #yiv0756848694activity span:first-child {text-transform:uppercase;}#yiv0756848694 #yiv0756848694activity span a {color:#5085b6;text-decoration:none;}#yiv0756848694 #yiv0756848694activity span span {color:#ff7900;}#yiv0756848694 #yiv0756848694activity span .yiv0756848694underline {text-decoration:underline;}#yiv0756848694 .yiv0756848694attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0756848694 .yiv0756848694attach div a {text-decoration:none;}#yiv0756848694 .yiv0756848694attach img {border:none;padding-right:5px;}#yiv0756848694 .yiv0756848694attach label {display:block;margin-bottom:5px;}#yiv0756848694 .yiv0756848694attach label a {text-decoration:none;}#yiv0756848694 blockquote {margin:0 0 0 4px;}#yiv0756848694 .yiv0756848694bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0756848694 .yiv0756848694bold a {text-decoration:none;}#yiv0756848694 dd.yiv0756848694last p a {font-family:Verdana;font-weight:700;}#yiv0756848694 dd.yiv0756848694last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0756848694 dd.yiv0756848694last p span.yiv0756848694yshortcuts {margin-right:0;}#yiv0756848694 div.yiv0756848694attach-table div div a {text-decoration:none;}#yiv0756848694 div.yiv0756848694attach-table {width:400px;}#yiv0756848694 div.yiv0756848694file-title a, #yiv0756848694 div.yiv0756848694file-title a:active, #yiv0756848694 div.yiv0756848694file-title a:hover, #yiv0756848694 div.yiv0756848694file-title a:visited {text-decoration:none;}#yiv0756848694 div.yiv0756848694photo-title a, #yiv0756848694 div.yiv0756848694photo-title a:active, #yiv0756848694 div.yiv0756848694photo-title a:hover, #yiv0756848694 div.yiv0756848694photo-title a:visited {text-decoration:none;}#yiv0756848694 div#yiv0756848694ygrp-mlmsg #yiv0756848694ygrp-msg p a span.yiv0756848694yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0756848694 .yiv0756848694green {color:#628c2a;}#yiv0756848694 .yiv0756848694MsoNormal {margin:0 0 0 0;}#yiv0756848694 o {font-size:0;}#yiv0756848694 #yiv0756848694photos div {float:left;width:72px;}#yiv0756848694 #yiv0756848694photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0756848694 #yiv0756848694photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0756848694 #yiv0756848694reco-category {font-size:77%;}#yiv0756848694 #yiv0756848694reco-desc {font-size:77%;}#yiv0756848694 .yiv0756848694replbq {margin:4px;}#yiv0756848694 #yiv0756848694ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0756848694 #yiv0756848694ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0756848694 #yiv0756848694ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0756848694 #yiv0756848694ygrp-mlmsg select, #yiv0756848694 input, #yiv0756848694 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0756848694 #yiv0756848694ygrp-mlmsg pre, #yiv0756848694 code {font:115% monospace;}#yiv0756848694 #yiv0756848694ygrp-mlmsg * {line-height:1.22em;}#yiv0756848694 #yiv0756848694ygrp-mlmsg #yiv0756848694logo {padding-bottom:10px;}#yiv0756848694 #yiv0756848694ygrp-msg p a {font-family:Verdana;}#yiv0756848694 #yiv0756848694ygrp-msg p#yiv0756848694attach-count span {color:#1E66AE;font-weight:700;}#yiv0756848694 #yiv0756848694ygrp-reco #yiv0756848694reco-head {color:#ff7900;font-weight:700;}#yiv0756848694 #yiv0756848694ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ov li a {font-size:130%;text-decoration:none;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0756848694 #yiv0756848694ygrp-sponsor #yiv0756848694ov ul {margin:0;padding:0 0 0 8px;}#yiv0756848694 #yiv0756848694ygrp-text {font-family:Georgia;}#yiv0756848694 #yiv0756848694ygrp-text p {margin:0 0 1em 0;}#yiv0756848694 #yiv0756848694ygrp-text tt {font-size:120%;}#yiv0756848694 #yiv0756848694ygrp-vital ul li:last-child {border-right:none !important;}#yiv0756848694

Mon Oct 3, 2016 11:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This is the link from the "Tips and FAQs" page on the add-in website:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523

On Mon, Oct 3, 2016 at 6:50 PM, Jonathan jbr863@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Apologies if this is a dumb question but how do I "Make sure your
> Internet Options are set to always get a fresh web page when one is
> requested"? I have noted that sWebCache = "Y" in smfGetWebPage, if that's
> what you mean.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar