3 Messages
Digest #4262
Messages
Sun Dec 10, 2017 6:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
All of the logging options are on the SMF context menu (right mouse click
within the workbook). You'd first do:
> SMF > Logging > Enable
...to enable logging. What this does is tell the add-in to append a line to
a file (smf-log.csv) in your add-in folder each time the add-in has to go
to the Internet to grab a web page or a file. Later on, you can view the
log using the context menu:
> SMF > Logging > Open Log File
...which will open the CSV file and put headers on the columns. The
resulting worksheet will look something like:
Time Stamp Duration Called URL
2017-10-18 17:20:23 0.2383
https://download.finance.yahoo.com/d/quotes.csv?s=SPY&f=sd1&e=.ignore
2017-10-18 17:20:23 0.0820
https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore
2017-10-18 17:22:13 0.1563
https://query1.finance.yahoo.com/v7/finance/options/CVX?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/KO?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/MCD?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/MRK?date=1508457600
My logging is always enabled. What I'll sometimes do is close all all
workbooks except the one I want to test. Then run the smfForceRecalculation
macro and open the log file. Then I can see all of the web pages that
workbook had to retrieve when I did the smfForceRecalculation. In the above
lines, I got current quotes on SPY and MMM and did something
options-related for CVX, KO, MCD, and MRK. The average duration is very
small, so not much to be concerned with (unless I were doing hundreds of
them).
For some of my quotes retrieval workbooks, I've been able to get them down
to a single Internet request by reviewing the logs.
If you do get a duration of near 60 seconds (or more), it usually means the
web site is down and the request timed out. I was getting a lot of timeouts
from OptionsXpress earlier in the year, which is why I had stopped using
them for options data.
On Sun, Dec 10, 2017 at 6:44 PM, eabartsch@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Interesting.
>
> How do you access the add-in log? I'll start there.
>
> I might bifurcate the workbook. Just run the watch list. The, after I
> have my shortlist, close that sheet and open up the more specific sheets.
> That should cut down on the access time, too.
>
>
within the workbook). You'd first do:
> SMF > Logging > Enable
...to enable logging. What this does is tell the add-in to append a line to
a file (smf-log.csv) in your add-in folder each time the add-in has to go
to the Internet to grab a web page or a file. Later on, you can view the
log using the context menu:
> SMF > Logging > Open Log File
...which will open the CSV file and put headers on the columns. The
resulting worksheet will look something like:
Time Stamp Duration Called URL
2017-10-18 17:20:23 0.2383
https://download.finance.yahoo.com/d/quotes.csv?s=SPY&f=sd1&e=.ignore
2017-10-18 17:20:23 0.0820
https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore
2017-10-18 17:22:13 0.1563
https://query1.finance.yahoo.com/v7/finance/options/CVX?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/KO?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/MCD?date=1508457600
2017-10-18 17:22:14 0.0938
https://query1.finance.yahoo.com/v7/finance/options/MRK?date=1508457600
My logging is always enabled. What I'll sometimes do is close all all
workbooks except the one I want to test. Then run the smfForceRecalculation
macro and open the log file. Then I can see all of the web pages that
workbook had to retrieve when I did the smfForceRecalculation. In the above
lines, I got current quotes on SPY and MMM and did something
options-related for CVX, KO, MCD, and MRK. The average duration is very
small, so not much to be concerned with (unless I were doing hundreds of
them).
For some of my quotes retrieval workbooks, I've been able to get them down
to a single Internet request by reviewing the logs.
If you do get a duration of near 60 seconds (or more), it usually means the
web site is down and the request timed out. I was getting a lot of timeouts
from OptionsXpress earlier in the year, which is why I had stopped using
them for options data.
On Sun, Dec 10, 2017 at 6:44 PM, eabartsch@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Interesting.
>
> How do you access the add-in log? I'll start there.
>
> I might bifurcate the workbook. Just run the watch list. The, after I
> have my shortlist, close that sheet and open up the more specific sheets.
> That should cut down on the access time, too.
>
>
Mon Dec 11, 2017 5:24 am (PST) . Posted by:
"Ron Spruell" hashky
I have found that Barcharts does a good job of getting expirations.
Ron
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, December 10, 2017 10:33 AM
Subject: Re: [smf_addin] Problem with smfGetOptionExpirations()
Yahoo is the only realistic source right now for smfGetOptionExpirations().
OptionsXPress has been gone for a few months now. See: https://smf-add-in.blogspot.com/2017/10/optionsxpress-no-longer-usable-data.html
Google has been unusable for years, because of so many missing contracts, and now the new Google Finance doesn't even have option quotes.
On Sun, Dec 10, 2017 at 6:31 AM, jbr863@... wrote:
Some weeks ago, smfGetOptionExpirations() sourcing "OX" started erroring out in my spreadsheet. I figured I'd look into it later. Just yesterday though, I downloaded smfGetOptionQuotes-Example- ITM-OTM-Multiple-Expirations. xls for a control point and I'm getting the same "Invalid Data Source" error message for "MMM" on "OX"and "OX2". Sourcing "G" returns a valid source but says "Bad Expiration Date:" for "MMM". Yahoo works for for expiration dates.
Are you seeing the same issue? Any idea what may be going on with the non-Yahoo sources?
#yiv1569321090 #yiv1569321090 -- #yiv1569321090ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1569321090 #yiv1569321090ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1569321090 #yiv1569321090ygrp-mkp #yiv1569321090hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1569321090 #yiv1569321090ygrp-mkp #yiv1569321090ads {margin-bottom:10px;}#yiv1569321090 #yiv1569321090ygrp-mkp .yiv1569321090ad {padding:0 0;}#yiv1569321090 #yiv1569321090ygrp-mkp .yiv1569321090ad p {margin:0;}#yiv1569321090 #yiv1569321090ygrp-mkp .yiv1569321090ad a {color:#0000ff;text-decoration:none;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ygrp-lc {font-family:Arial;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ygrp-lc #yiv1569321090hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ygrp-lc .yiv1569321090ad {margin-bottom:10px;padding:0 0;}#yiv1569321090 #yiv1569321090actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1569321090 #yiv1569321090activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1569321090 #yiv1569321090activity span {font-weight:700;}#yiv1569321090 #yiv1569321090activity span:first-child {text-transform:uppercase;}#yiv1569321090 #yiv1569321090activity span a {color:#5085b6;text-decoration:none;}#yiv1569321090 #yiv1569321090activity span span {color:#ff7900;}#yiv1569321090 #yiv1569321090activity span .yiv1569321090underline {text-decoration:underline;}#yiv1569321090 .yiv1569321090attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1569321090 .yiv1569321090attach div a {text-decoration:none;}#yiv1569321090 .yiv1569321090attach img {border:none;padding-right:5px;}#yiv1569321090 .yiv1569321090attach label {display:block;margin-bottom:5px;}#yiv1569321090 .yiv1569321090attach label a {text-decoration:none;}#yiv1569321090 blockquote {margin:0 0 0 4px;}#yiv1569321090 .yiv1569321090bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1569321090 .yiv1569321090bold a {text-decoration:none;}#yiv1569321090 dd.yiv1569321090last p a {font-family:Verdana;font-weight:700;}#yiv1569321090 dd.yiv1569321090last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1569321090 dd.yiv1569321090last p span.yiv1569321090yshortcuts {margin-right:0;}#yiv1569321090 div.yiv1569321090attach-table div div a {text-decoration:none;}#yiv1569321090 div.yiv1569321090attach-table {width:400px;}#yiv1569321090 div.yiv1569321090file-title a, #yiv1569321090 div.yiv1569321090file-title a:active, #yiv1569321090 div.yiv1569321090file-title a:hover, #yiv1569321090 div.yiv1569321090file-title a:visited {text-decoration:none;}#yiv1569321090 div.yiv1569321090photo-title a, #yiv1569321090 div.yiv1569321090photo-title a:active, #yiv1569321090 div.yiv1569321090photo-title a:hover, #yiv1569321090 div.yiv1569321090photo-title a:visited {text-decoration:none;}#yiv1569321090 div#yiv1569321090ygrp-mlmsg #yiv1569321090ygrp-msg p a span.yiv1569321090yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1569321090 .yiv1569321090green {color:#628c2a;}#yiv1569321090 .yiv1569321090MsoNormal {margin:0 0 0 0;}#yiv1569321090 o {font-size:0;}#yiv1569321090 #yiv1569321090photos div {float:left;width:72px;}#yiv1569321090 #yiv1569321090photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1569321090 #yiv1569321090photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1569321090 #yiv1569321090reco-category {font-size:77%;}#yiv1569321090 #yiv1569321090reco-desc {font-size:77%;}#yiv1569321090 .yiv1569321090replbq {margin:4px;}#yiv1569321090 #yiv1569321090ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1569321090 #yiv1569321090ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1569321090 #yiv1569321090ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1569321090 #yiv1569321090ygrp-mlmsg select, #yiv1569321090 input, #yiv1569321090 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1569321090 #yiv1569321090ygrp-mlmsg pre, #yiv1569321090 code {font:115% monospace;}#yiv1569321090 #yiv1569321090ygrp-mlmsg * {line-height:1.22em;}#yiv1569321090 #yiv1569321090ygrp-mlmsg #yiv1569321090logo {padding-bottom:10px;}#yiv1569321090 #yiv1569321090ygrp-msg p a {font-family:Verdana;}#yiv1569321090 #yiv1569321090ygrp-msg p#yiv1569321090attach-count span {color:#1E66AE;font-weight:700;}#yiv1569321090 #yiv1569321090ygrp-reco #yiv1569321090reco-head {color:#ff7900;font-weight:700;}#yiv1569321090 #yiv1569321090ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ov li a {font-size:130%;text-decoration:none;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1569321090 #yiv1569321090ygrp-sponsor #yiv1569321090ov ul {margin:0;padding:0 0 0 8px;}#yiv1569321090 #yiv1569321090ygrp-text {font-family:Georgia;}#yiv1569321090 #yiv1569321090ygrp-text p {margin:0 0 1em 0;}#yiv1569321090 #yiv1569321090ygrp-text tt {font-size:120%;}#yiv1569321090 #yiv1569321090ygrp-vital ul li:last-child {border-right:none !important;}#yiv1569321090
Ron
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, December 10, 2017 10:33 AM
Subject: Re: [smf_addin] Problem with smfGetOptionExpirations()
Yahoo is the only realistic source right now for smfGetOptionExpirations().
OptionsXPress has been gone for a few months now. See: https://smf-add-in.blogspot.com/2017/10/optionsxpress-no-longer-usable-data.html
Google has been unusable for years, because of so many missing contracts, and now the new Google Finance doesn't even have option quotes.
On Sun, Dec 10, 2017 at 6:31 AM, jbr863@... wrote:
Some weeks ago, smfGetOptionExpirat
Are you seeing the same issue? Any idea what may be going on with the non-Yahoo sources?
#yiv1569321090 #yiv1569321090 -- #yiv1569321090ygrp-
Mon Dec 11, 2017 9:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Except that smfGetOptionExpirations() doesn't get expirations from
Barchart. It actually gets them from Yahoo. I didn't want to require
someone to have to use separate "Source" codes for the different option
functions, so instead of not allowing "B" for smfGetOptionExpirations(), I
just had it go to Yahoo as a substitute.
On Mon, Dec 11, 2017 at 6:24 AM, Ron Spruell hashky@
...
wrote:
>
> I have found that Barcharts does a good job of getting expirations.
>
>
>
Barchart. It actually gets them from Yahoo. I didn't want to require
someone to have to use separate "Source" codes for the different option
functions, so instead of not allowing "B" for smfGetOptionExpirat
just had it go to Yahoo as a substitute.
On Mon, Dec 11, 2017 at 6:24 AM, Ron Spruell hashky@
...
wrote:
>
> I have found that Barcharts does a good job of getting expirations.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar