7 Messages
Digest #3282
Messages
Wed Dec 31, 2014 4:38 am (PST) . Posted by:
"Axel Ronnisch" aronnisch
Hi Randy,thank you for your answer. I give it a trys. Hopefully everything will work soon with Yahoo again.
Happy new year.
best wishesAxel
On Sunday, December 28, 2014 3:44 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I think most went back to the beta version before the Yahoo changes were made:
http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2014.05.25.zip
...or are using OptionsXPress as the data source instead of Yahoo.
On Sun, Dec 28, 2014 at 2:45 AM, Axel Ronnisch aronnisch@... wrote:
are there any news to the problem with the smfGetOptionQuotes and the changes Yahoo did?I am lost in Space without.
#yiv9353704860 #yiv9353704860 -- #yiv9353704860ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9353704860 #yiv9353704860ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9353704860 #yiv9353704860ygrp-mkp #yiv9353704860hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9353704860 #yiv9353704860ygrp-mkp #yiv9353704860ads {margin-bottom:10px;}#yiv9353704860 #yiv9353704860ygrp-mkp .yiv9353704860ad {padding:0 0;}#yiv9353704860 #yiv9353704860ygrp-mkp .yiv9353704860ad p {margin:0;}#yiv9353704860 #yiv9353704860ygrp-mkp .yiv9353704860ad a {color:#0000ff;text-decoration:none;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ygrp-lc {font-family:Arial;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ygrp-lc #yiv9353704860hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ygrp-lc .yiv9353704860ad {margin-bottom:10px;padding:0 0;}#yiv9353704860 #yiv9353704860actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9353704860 #yiv9353704860activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9353704860 #yiv9353704860activity span {font-weight:700;}#yiv9353704860 #yiv9353704860activity span:first-child {text-transform:uppercase;}#yiv9353704860 #yiv9353704860activity span a {color:#5085b6;text-decoration:none;}#yiv9353704860 #yiv9353704860activity span span {color:#ff7900;}#yiv9353704860 #yiv9353704860activity span .yiv9353704860underline {text-decoration:underline;}#yiv9353704860 .yiv9353704860attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9353704860 .yiv9353704860attach div a {text-decoration:none;}#yiv9353704860 .yiv9353704860attach img {border:none;padding-right:5px;}#yiv9353704860 .yiv9353704860attach label {display:block;margin-bottom:5px;}#yiv9353704860 .yiv9353704860attach label a {text-decoration:none;}#yiv9353704860 blockquote {margin:0 0 0 4px;}#yiv9353704860 .yiv9353704860bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9353704860 .yiv9353704860bold a {text-decoration:none;}#yiv9353704860 dd.yiv9353704860last p a {font-family:Verdana;font-weight:700;}#yiv9353704860 dd.yiv9353704860last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9353704860 dd.yiv9353704860last p span.yiv9353704860yshortcuts {margin-right:0;}#yiv9353704860 div.yiv9353704860attach-table div div a {text-decoration:none;}#yiv9353704860 div.yiv9353704860attach-table {width:400px;}#yiv9353704860 div.yiv9353704860file-title a, #yiv9353704860 div.yiv9353704860file-title a:active, #yiv9353704860 div.yiv9353704860file-title a:hover, #yiv9353704860 div.yiv9353704860file-title a:visited {text-decoration:none;}#yiv9353704860 div.yiv9353704860photo-title a, #yiv9353704860 div.yiv9353704860photo-title a:active, #yiv9353704860 div.yiv9353704860photo-title a:hover, #yiv9353704860 div.yiv9353704860photo-title a:visited {text-decoration:none;}#yiv9353704860 div#yiv9353704860ygrp-mlmsg #yiv9353704860ygrp-msg p a span.yiv9353704860yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9353704860 .yiv9353704860green {color:#628c2a;}#yiv9353704860 .yiv9353704860MsoNormal {margin:0 0 0 0;}#yiv9353704860 o {font-size:0;}#yiv9353704860 #yiv9353704860photos div {float:left;width:72px;}#yiv9353704860 #yiv9353704860photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9353704860 #yiv9353704860photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9353704860 #yiv9353704860reco-category {font-size:77%;}#yiv9353704860 #yiv9353704860reco-desc {font-size:77%;}#yiv9353704860 .yiv9353704860replbq {margin:4px;}#yiv9353704860 #yiv9353704860ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9353704860 #yiv9353704860ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9353704860 #yiv9353704860ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9353704860 #yiv9353704860ygrp-mlmsg select, #yiv9353704860 input, #yiv9353704860 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9353704860 #yiv9353704860ygrp-mlmsg pre, #yiv9353704860 code {font:115% monospace;}#yiv9353704860 #yiv9353704860ygrp-mlmsg * {line-height:1.22em;}#yiv9353704860 #yiv9353704860ygrp-mlmsg #yiv9353704860logo {padding-bottom:10px;}#yiv9353704860 #yiv9353704860ygrp-msg p a {font-family:Verdana;}#yiv9353704860 #yiv9353704860ygrp-msg p#yiv9353704860attach-count span {color:#1E66AE;font-weight:700;}#yiv9353704860 #yiv9353704860ygrp-reco #yiv9353704860reco-head {color:#ff7900;font-weight:700;}#yiv9353704860 #yiv9353704860ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ov li a {font-size:130%;text-decoration:none;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9353704860 #yiv9353704860ygrp-sponsor #yiv9353704860ov ul {margin:0;padding:0 0 0 8px;}#yiv9353704860 #yiv9353704860ygrp-text {font-family:Georgia;}#yiv9353704860 #yiv9353704860ygrp-text p {margin:0 0 1em 0;}#yiv9353704860 #yiv9353704860ygrp-text tt {font-size:120%;}#yiv9353704860 #yiv9353704860ygrp-vital ul li:last-child {border-right:none !important;}#yiv9353704860
Happy new year.
best wishesAxel
On Sunday, December 28, 2014 3:44 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I think most went back to the beta version before the Yahoo changes were made:
http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2014.05.25.zip
...or are using OptionsXPress as the data source instead of Yahoo.
On Sun, Dec 28, 2014 at 2:45 AM, Axel Ronnisch aronnisch@..
are there any news to the problem with the smfGetOptionQuotes and the changes Yahoo did?I am lost in Space without.
#yiv9353704860 #yiv9353704860 -- #yiv9353704860ygrp-
Wed Dec 31, 2014 4:55 am (PST) . Posted by:
rlfaulk
Sorry about that. It is the file "FWallStreet_GF_Mod.xlsm";.
Rod
Rod
Wed Dec 31, 2014 5:18 am (PST) . Posted by:
rlfaulk
I may have solved part of the problem.
1. Auto-calculation has to be set to "Automatic". If calculation is set to Manual, where you have to tell Excel to calculate by pressing F9, the "Run List" button in the file does not work. It will set the values in the "List" worksheet to be all the same because it runs the script but does not calculate between each loop.
2. To fix this in code, I added this line to the VBA:
Application.Calculation = xlCalculationAutomatic
right before the line:
For lRow = 1 To nTickers
3. I still get #NAME? on the "List" worksheet for the Company (name) (column B) and the price (column C).
Can you help with #3?
Rod
1. Auto-calculation has to be set to "Automatic&quo
2. To fix this in code, I added this line to the VBA:
Application.
right before the line:
For lRow = 1 To nTickers
3. I still get #NAME? on the "List" worksheet for the Company (name) (column B) and the price (column C).
Can you help with #3?
Rod
Wed Dec 31, 2014 6:54 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry. I don't decode files uploaded by other people...
But, typically the #NAME? is a result of a location error. See the "Tips
and FAQs" page for info on that.
On Wed, Dec 31, 2014 at 6:18 AM, rlfaulk@.... wrote:
> I may have solved part of the problem.
>
> 1. Auto-calculation has to be set to "Automatic". If calculation is set
> to Manual, where you have to tell Excel to calculate by pressing F9, the
> "Run List" button in the file does not work. It will set the values in the
> "List" worksheet to be all the same because it runs the script but does not
> calculate between each loop.
>
> 2. To fix this in code, I added this line to the VBA:
>
> Application.Calculation = xlCalculationAutomatic
>
> right before the line:
>
> For lRow = 1 To nTickers
>
> 3. I still get #NAME? on the "List" worksheet for the Company (name)
> (column B) and the price (column C).
>
> Can you help with #3?
>
>
But, typically the #NAME? is a result of a location error. See the "Tips
and FAQs" page for info on that.
On Wed, Dec 31, 2014 at 6:18 AM, rlfaulk@.... wrote:
> I may have solved part of the problem.
>
> 1. Auto-calculation has to be set to "Automatic&quo
> to Manual, where you have to tell Excel to calculate by pressing F9, the
> "Run List" button in the file does not work. It will set the values in the
> "List" worksheet to be all the same because it runs the script but does not
> calculate between each loop.
>
> 2. To fix this in code, I added this line to the VBA:
>
> Application.
>
> right before the line:
>
> For lRow = 1 To nTickers
>
> 3. I still get #NAME? on the "List" worksheet for the Company (name)
> (column B) and the price (column C).
>
> Can you help with #3?
>
>
Wed Dec 31, 2014 6:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
No need for the add-in to do it -- that's a normal EXCEL function. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/22983
The key thing is whether the XLS file is *created* by the URL, or whether
the XLS file is simply sitting on the server ready to be accessed. If it
needs to be created on the fly, the above reference technique won't work.
You'd need to write your own VBA routine to get the file downloaded.
On Wed, Dec 31, 2014 at 3:50 AM, wongkayau@...wrote:
> Some website allows excel file download for data. Can we capture those
> data in excel, without downloading the excel file, and then manually copy
> and paste data? The function "smfGetCSVFile" does similar job. Another one
> for .xls file?
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/22983
The key thing is whether the XLS file is *created* by the URL, or whether
the XLS file is simply sitting on the server ready to be accessed. If it
needs to be created on the fly, the above reference technique won't work.
You'd need to write your own VBA routine to get the file downloaded.
On Wed, Dec 31, 2014 at 3:50 AM, wongkayau@..
> Some website allows excel file download for data. Can we capture those
> data in excel, without downloading the excel file, and then manually copy
> and paste data? The function "smfGetCSVFile
> for .xls file?
>
Wed Dec 31, 2014 7:47 am (PST) . Posted by:
jasonwalker765
As the year ends please join me in giving a big THANKS to Randy, for his genius and effort in developing this amazing software, that finds new uses everyday, and for his patience in keeping it up and addressing all the questions that come up.
Thanks again Randy, and Happy New Year 2015 everybody!
Thanks again Randy, and Happy New Year 2015 everybody!
Wed Dec 31, 2014 9:59 am (PST) . Posted by:
wongkayau
Hi Randy,
It works! So amazing! Thank you so much for teaching me.
I have asked you many questions in last two years, and the smf addin has really helped me a lot. Much appreciated. Wish you a great, happy, healthy and prosperous new year!
Cheers,
L
It works! So amazing! Thank you so much for teaching me.
I have asked you many questions in last two years, and the smf addin has really helped me a lot. Much appreciated. Wish you a great, happy, healthy and prosperous new year!
Cheers,
L
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar