15 Messages
Digest #4044
Messages
Tue May 30, 2017 7:09 pm (PDT) . Posted by:
msimmsx
Randy - can you create an XLAM file ?
I am unable to open the XLA file in Excel 2016 - 64 bit.
It just refuses to open and thus will not expose the VBA source.
Tue May 30, 2017 7:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure it does you any good, since the add-in uses Windows' 32-bit
XLL libraries.
https://stackoverflow.com/questions/12810555/can-32-bit-excel-add-ins-work-in-64-bit-excel-at-all
In any case, I'm not sure I want to maintain two copies of the add-in...?
On Tue, May 30, 2017 at 7:09 PM, marksimms@
...wrote:
> Randy - can you create an XLAM file ?
>
> I am unable to open the XLA file in Excel 2016 - 64 bit.
>
> It just refuses to open and thus will not expose the VBA source.
>
>
XLL libraries.
https://stackoverflow.com/questions/12810555/can-32-bit-excel-add-ins-work-in-64-bit-excel-at-all
In any case, I'm not sure I want to maintain two copies of the add-in...?
On Tue, May 30, 2017 at 7:09 PM, marksimms@
...wrote:
> Randy - can you create an XLAM file ?
>
> I am unable to open the XLA file in Excel 2016 - 64 bit.
>
> It just refuses to open and thus will not expose the VBA source.
>
>
Tue May 30, 2017 7:39 pm (PDT) . Posted by:
msimmsx
I hear you....but exactly what XLL's does the add-in rely upon now ?
Where do these get installed and reside ?
Where do these get installed and reside ?
Tue May 30, 2017 7:40 pm (PDT) . Posted by:
msimmsx
Will the add-in work with 32 bit Office under 64 bit windows ?
Tue May 30, 2017 8:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are currently eight Microsoft reference libraries in use. In addition
to those mentioned here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20312
...I just added the "Script Control" reference library for JSON parsing.
On Tue, May 30, 2017 at 7:39 PM, marksimms@
...wrote:
> I hear you....but exactly what XLL's does the add-in rely upon now ?
>
> Where do these get installed and reside ?
>
>
to those mentioned here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20312
...I just added the "Script Control" reference library for JSON parsing.
On Tue, May 30, 2017 at 7:39 PM, marksimms@
...wrote:
> I hear you....but exactly what XLL's does the add-in rely upon now ?
>
> Where do these get installed and reside ?
>
>
Tue May 30, 2017 8:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a clue. I only have the two configurations I use now, and I think they
are the same. It's not a commercial product where I have a staff that can
test over all different permutations of software combinations. I'm just
sharing something I'm using.
On Tue, May 30, 2017 at 7:40 PM, marksimms@
...wrote:
> Will the add-in work with 32 bit Office under 64 bit windows ?
>
>
are the same. It's not a commercial product where I have a staff that can
test over all different permutations of software combinations. I'm just
sharing something I'm using.
On Tue, May 30, 2017 at 7:40 PM, marksimms@
...wrote:
> Will the add-in work with 32 bit Office under 64 bit windows ?
>
>
Wed May 31, 2017 3:42 am (PDT) . Posted by:
msimmsx
Would it be possible for you to provide the BAS files for each of the Modules and just zip them up ? I pretty sure I can get this to work if I at least had the source code.
Also, where are those XLL's you were referring to ? Are they one of the references ?
Also, where are those XLL's you were referring to ? Are they one of the references ?
Wed May 31, 2017 8:45 am (PDT) . Posted by:
tonyestep
The XLA library opens okay in the 32-bit Excel 2016. However, all versions of Excel 2016 are subject to fatal bugs. I'm guessing that the new subscription versions of the Office programs are .net translations of C++ code from Office 2010. Excel 2016 runs much slower than 2010 in certain situations, and I have encountered numerous memory leak disasters that cause Excel to crash. These come and go as Microsoft pushes updates to Office. The other Office applications have caused me no trouble, but I have gone to Excel 2010 for my spreadsheet use. Microsoft recommends the 32-bit version of 2016. I tried the 64-bit version a year ago but it crashed repeatedly on plain vanilla spreadsheets. Try 32-bit, or if possible revert to 2010.
Tue May 30, 2017 7:48 pm (PDT) . Posted by:
mokwit
apparently a solution to cookie and crumb here (?)
http://www.xlautomation.com.au/free-spreadsheets/yahoo-historical-price-extract http://www.xlautomation.com.au/free-spreadsheets/yahoo-historical-price-extract
code + spreadsheet downloadable
http://www.xlautomation.com.au/free-spreadsheets/yahoo-historical-price-extract http://www.xlautomation.com.au/free-spreadsheets/yahoo-historical-price-extract
code + spreadsheet downloadable
Tue May 30, 2017 8:05 pm (PDT) . Posted by:
mokwit
http://www.xlautomation.com.au/free-downloads/Historical_Price_Extract_XLAutomation.xlsm http://www.xlautomation.com.au/free-downloads/Historical_Price_Extract_XLAutomation.xlsm
Tue May 30, 2017 8:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks. I was able to winnow it down to a short routine. But I'm not fond
of the number of web page retrievals his routine makes. The Yahoo calls are
apparently error-prone if he's willing to retry it up to 5 times to get the
data.
On Tue, May 30, 2017 at 8:05 PM, pmanz@
...wrote:
>
> http://www.xlautomation.com.au/free-downloads/Historical_
> Price_Extract_XLAutomation.xlsm
>
>
of the number of web page retrievals his routine makes. The Yahoo calls are
apparently error-prone if he's willing to retry it up to 5 times to get the
data.
On Tue, May 30, 2017 at 8:05 PM, pmanz@
...wrote:
>
> http://www.xlautomation.com.au/free-downloads/Historical_
> Price_Extract_
>
>
Wed May 31, 2017 7:02 am (PDT) . Posted by:
"Madhu Khemani" madhu_98
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } I also found this site:
|
| |
| |
|
for historical prices.
Sent from Yahoo Mail for iPhone
On Tuesday, May 30, 2017, 11:05 PM, pmanz@usa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
http://www.xlautomation.com.au/free-downloads/Historical_Price_Extract_XLAutomation.xlsm
#yiv2728222642 #yiv2728222642 -- #yiv2728222642ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2728222642 #yiv2728222642ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2728222642 #yiv2728222642ygrp-mkp #yiv2728222642hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2728222642 #yiv2728222642ygrp-mkp #yiv2728222642ads {margin-bottom:10px;}#yiv2728222642 #yiv2728222642ygrp-mkp .yiv2728222642ad {padding:0 0;}#yiv2728222642 #yiv2728222642ygrp-mkp .yiv2728222642ad p {margin:0;}#yiv2728222642 #yiv2728222642ygrp-mkp .yiv2728222642ad a {color:#0000ff;text-decoration:none;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ygrp-lc {font-family:Arial;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ygrp-lc #yiv2728222642hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ygrp-lc .yiv2728222642ad {margin-bottom:10px;padding:0 0;}#yiv2728222642 #yiv2728222642actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2728222642 #yiv2728222642activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2728222642 #yiv2728222642activity span {font-weight:700;}#yiv2728222642 #yiv2728222642activity span:first-child {text-transform:uppercase;}#yiv2728222642 #yiv2728222642activity span a {color:#5085b6;text-decoration:none;}#yiv2728222642 #yiv2728222642activity span span {color:#ff7900;}#yiv2728222642 #yiv2728222642activity span .yiv2728222642underline {text-decoration:underline;}#yiv2728222642 .yiv2728222642attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2728222642 .yiv2728222642attach div a {text-decoration:none;}#yiv2728222642 .yiv2728222642attach img {border:none;padding-right:5px;}#yiv2728222642 .yiv2728222642attach label {display:block;margin-bottom:5px;}#yiv2728222642 .yiv2728222642attach label a {text-decoration:none;}#yiv2728222642 blockquote {margin:0 0 0 4px;}#yiv2728222642 .yiv2728222642bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2728222642 .yiv2728222642bold a {text-decoration:none;}#yiv2728222642 dd.yiv2728222642last p a {font-family:Verdana;font-weight:700;}#yiv2728222642 dd.yiv2728222642last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2728222642 dd.yiv2728222642last p span.yiv2728222642yshortcuts {margin-right:0;}#yiv2728222642 div.yiv2728222642attach-table div div a {text-decoration:none;}#yiv2728222642 div.yiv2728222642attach-table {width:400px;}#yiv2728222642 div.yiv2728222642file-title a, #yiv2728222642 div.yiv2728222642file-title a:active, #yiv2728222642 div.yiv2728222642file-title a:hover, #yiv2728222642 div.yiv2728222642file-title a:visited {text-decoration:none;}#yiv2728222642 div.yiv2728222642photo-title a, #yiv2728222642 div.yiv2728222642photo-title a:active, #yiv2728222642 div.yiv2728222642photo-title a:hover, #yiv2728222642 div.yiv2728222642photo-title a:visited {text-decoration:none;}#yiv2728222642 div#yiv2728222642ygrp-mlmsg #yiv2728222642ygrp-msg p a span.yiv2728222642yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2728222642 .yiv2728222642green {color:#628c2a;}#yiv2728222642 .yiv2728222642MsoNormal {margin:0 0 0 0;}#yiv2728222642 o {font-size:0;}#yiv2728222642 #yiv2728222642photos div {float:left;width:72px;}#yiv2728222642 #yiv2728222642photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2728222642 #yiv2728222642photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2728222642 #yiv2728222642reco-category {font-size:77%;}#yiv2728222642 #yiv2728222642reco-desc {font-size:77%;}#yiv2728222642 .yiv2728222642replbq {margin:4px;}#yiv2728222642 #yiv2728222642ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2728222642 #yiv2728222642ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2728222642 #yiv2728222642ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2728222642 #yiv2728222642ygrp-mlmsg select, #yiv2728222642 input, #yiv2728222642 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2728222642 #yiv2728222642ygrp-mlmsg pre, #yiv2728222642 code {font:115% monospace;}#yiv2728222642 #yiv2728222642ygrp-mlmsg * {line-height:1.22em;}#yiv2728222642 #yiv2728222642ygrp-mlmsg #yiv2728222642logo {padding-bottom:10px;}#yiv2728222642 #yiv2728222642ygrp-msg p a {font-family:Verdana;}#yiv2728222642 #yiv2728222642ygrp-msg p#yiv2728222642attach-count span {color:#1E66AE;font-weight:700;}#yiv2728222642 #yiv2728222642ygrp-reco #yiv2728222642reco-head {color:#ff7900;font-weight:700;}#yiv2728222642 #yiv2728222642ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ov li a {font-size:130%;text-decoration:none;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2728222642 #yiv2728222642ygrp-sponsor #yiv2728222642ov ul {margin:0;padding:0 0 0 8px;}#yiv2728222642 #yiv2728222642ygrp-text {font-family:Georgia;}#yiv2728222642 #yiv2728222642ygrp-text p {margin:0 0 1em 0;}#yiv2728222642 #yiv2728222642ygrp-text tt {font-size:120%;}#yiv2728222642 #yiv2728222642ygrp-vital ul li:last-child {border-right:none !important;}#yiv2728222642
|
| |
| |
|
for historical prices.
Sent from Yahoo Mail for iPhone
On Tuesday, May 30, 2017, 11:05 PM, pmanz@usa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
http://www.xlautomation.com.au/free-downloads/Historical_Price_Extract_XLAutomation.xlsm
#yiv2728222642 #yiv2728222642 -- #yiv2728222642ygrp-
Wed May 31, 2017 2:59 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
Does anyone know how to scrape the Morningstar Star Rating (i.e., number of
stars)?
--
Robbie Geary
stars)?
--
Robbie Geary
Wed May 31, 2017 5:44 am (PDT) . Posted by:
"Ron Spruell" hashky
=smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&B37,"r_star"),"r_star","'"))
Cell B37 contains the ticker symbolCompliments of Randy.
Ron Spruell
From: "Robbie Geary rgearyiii@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 31, 2017 5:00 AM
Subject: [smf_addin] Morningstar Star Rating
Does anyone know how to scrape the Morningstar Star Rating (i.e., number of stars)?
--
Robbie Geary #yiv7496315625 #yiv7496315625 -- #yiv7496315625ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7496315625 #yiv7496315625ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7496315625 #yiv7496315625ygrp-mkp #yiv7496315625hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7496315625 #yiv7496315625ygrp-mkp #yiv7496315625ads {margin-bottom:10px;}#yiv7496315625 #yiv7496315625ygrp-mkp .yiv7496315625ad {padding:0 0;}#yiv7496315625 #yiv7496315625ygrp-mkp .yiv7496315625ad p {margin:0;}#yiv7496315625 #yiv7496315625ygrp-mkp .yiv7496315625ad a {color:#0000ff;text-decoration:none;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ygrp-lc {font-family:Arial;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ygrp-lc #yiv7496315625hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ygrp-lc .yiv7496315625ad {margin-bottom:10px;padding:0 0;}#yiv7496315625 #yiv7496315625actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7496315625 #yiv7496315625activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7496315625 #yiv7496315625activity span {font-weight:700;}#yiv7496315625 #yiv7496315625activity span:first-child {text-transform:uppercase;}#yiv7496315625 #yiv7496315625activity span a {color:#5085b6;text-decoration:none;}#yiv7496315625 #yiv7496315625activity span span {color:#ff7900;}#yiv7496315625 #yiv7496315625activity span .yiv7496315625underline {text-decoration:underline;}#yiv7496315625 .yiv7496315625attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7496315625 .yiv7496315625attach div a {text-decoration:none;}#yiv7496315625 .yiv7496315625attach img {border:none;padding-right:5px;}#yiv7496315625 .yiv7496315625attach label {display:block;margin-bottom:5px;}#yiv7496315625 .yiv7496315625attach label a {text-decoration:none;}#yiv7496315625 blockquote {margin:0 0 0 4px;}#yiv7496315625 .yiv7496315625bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7496315625 .yiv7496315625bold a {text-decoration:none;}#yiv7496315625 dd.yiv7496315625last p a {font-family:Verdana;font-weight:700;}#yiv7496315625 dd.yiv7496315625last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7496315625 dd.yiv7496315625last p span.yiv7496315625yshortcuts {margin-right:0;}#yiv7496315625 div.yiv7496315625attach-table div div a {text-decoration:none;}#yiv7496315625 div.yiv7496315625attach-table {width:400px;}#yiv7496315625 div.yiv7496315625file-title a, #yiv7496315625 div.yiv7496315625file-title a:active, #yiv7496315625 div.yiv7496315625file-title a:hover, #yiv7496315625 div.yiv7496315625file-title a:visited {text-decoration:none;}#yiv7496315625 div.yiv7496315625photo-title a, #yiv7496315625 div.yiv7496315625photo-title a:active, #yiv7496315625 div.yiv7496315625photo-title a:hover, #yiv7496315625 div.yiv7496315625photo-title a:visited {text-decoration:none;}#yiv7496315625 div#yiv7496315625ygrp-mlmsg #yiv7496315625ygrp-msg p a span.yiv7496315625yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7496315625 .yiv7496315625green {color:#628c2a;}#yiv7496315625 .yiv7496315625MsoNormal {margin:0 0 0 0;}#yiv7496315625 o {font-size:0;}#yiv7496315625 #yiv7496315625photos div {float:left;width:72px;}#yiv7496315625 #yiv7496315625photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7496315625 #yiv7496315625photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7496315625 #yiv7496315625reco-category {font-size:77%;}#yiv7496315625 #yiv7496315625reco-desc {font-size:77%;}#yiv7496315625 .yiv7496315625replbq {margin:4px;}#yiv7496315625 #yiv7496315625ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7496315625 #yiv7496315625ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7496315625 #yiv7496315625ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7496315625 #yiv7496315625ygrp-mlmsg select, #yiv7496315625 input, #yiv7496315625 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7496315625 #yiv7496315625ygrp-mlmsg pre, #yiv7496315625 code {font:115% monospace;}#yiv7496315625 #yiv7496315625ygrp-mlmsg * {line-height:1.22em;}#yiv7496315625 #yiv7496315625ygrp-mlmsg #yiv7496315625logo {padding-bottom:10px;}#yiv7496315625 #yiv7496315625ygrp-msg p a {font-family:Verdana;}#yiv7496315625 #yiv7496315625ygrp-msg p#yiv7496315625attach-count span {color:#1E66AE;font-weight:700;}#yiv7496315625 #yiv7496315625ygrp-reco #yiv7496315625reco-head {color:#ff7900;font-weight:700;}#yiv7496315625 #yiv7496315625ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ov li a {font-size:130%;text-decoration:none;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7496315625 #yiv7496315625ygrp-sponsor #yiv7496315625ov ul {margin:0;padding:0 0 0 8px;}#yiv7496315625 #yiv7496315625ygrp-text {font-family:Georgia;}#yiv7496315625 #yiv7496315625ygrp-text p {margin:0 0 1em 0;}#yiv7496315625 #yiv7496315625ygrp-text tt {font-size:120%;}#yiv7496315625 #yiv7496315625ygrp-vital ul li:last-child {border-right:none !important;}#yiv7496315625
Cell B37 contains the ticker symbolCompliments of Randy.
Ron Spruell
From: "Robbie Geary rgearyiii@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 31, 2017 5:00 AM
Subject: [smf_addin] Morningstar Star Rating
Does anyone know how to scrape the Morningstar Star Rating (i.e., number of stars)?
--
Robbie Geary #yiv7496315625 #yiv7496315625 -- #yiv7496315625ygrp-
Wed May 31, 2017 8:17 am (PDT) . Posted by:
tonyestep
Is there some source for historical spot oil prices accessible through SMF or any other way? Thanks to anyone who can answer this.
Tony
Tony
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar