Kamis, 01 Januari 2015

[smf_addin] Digest Number 3282

7 Messages

Digest #3282
1a
Re: Any news to the Options Problem? by "Axel Ronnisch" aronnisch
2.3
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
3a
Re: excel file by "Randy Harmelink" rharmelink
4a
Thank you Randy by jasonwalker765

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

Wed Dec 31, 2014 4:55 am (PST) . Posted by:

rlfaulk

Sorry about that. It is the file "FWallStreet_GF_Mod.xlsm";.

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&quot;. 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

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&quot;. 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?
>
>

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?
>

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!



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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar