[smf_addin] Digest Number 3909

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #3909

1a

Re: XD for ETFs? by

2a

Request Help on smfForceRecalculation coding for Excel Sheet by frk1rxh

2b

Re: Request Help on smfForceRecalculation coding for Excel Sheet by "Randy Harmelink" rharmelink

3a

Possible to pull value from this webpage? by jpsartrean

3b

Re: Possible to pull value from this webpage? by "Randy Harmelink" rharmelink

4

Possible to pull rank/data from this webpage? by jpsartrean

5a

Re: rchcreatecomment and custom stockchart member chart by jhfrazer@ymail.com

Messages

1a

Re: XD for ETFs?

Fri Feb 3, 2017 10:10 pm (PST) . Posted by:

--------------------------------------------
On Sat, 2/4/17, tonyestep@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Re: XD for ETFs?
To: smf_addin@yahoogroups.com
Date: Saturday, February 4, 2017, 2:03 AM


 









Holy cow, you're right!! I copied and pasted --
who knows what happened?! Anyway, it works. Thank you so
much, Randy, you're the best!









#yiv9858107381 #yiv9858107381 --
#yiv9858107381ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv9858107381 #yiv9858107381ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9858107381 #yiv9858107381ygrp-mkp #yiv9858107381hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9858107381 #yiv9858107381ygrp-mkp #yiv9858107381ads {
margin-bottom:10px;}

#yiv9858107381 #yiv9858107381ygrp-mkp .yiv9858107381ad {
padding:0 0;}

#yiv9858107381 #yiv9858107381ygrp-mkp .yiv9858107381ad p {
margin:0;}

#yiv9858107381 #yiv9858107381ygrp-mkp .yiv9858107381ad a {
color:#0000ff;text-decoration:none;}
#yiv9858107381 #yiv9858107381ygrp-sponsor
#yiv9858107381ygrp-lc {
font-family:Arial;}

#yiv9858107381 #yiv9858107381ygrp-sponsor
#yiv9858107381ygrp-lc #yiv9858107381hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9858107381 #yiv9858107381ygrp-sponsor
#yiv9858107381ygrp-lc .yiv9858107381ad {
margin-bottom:10px;padding:0 0;}

#yiv9858107381 #yiv9858107381actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv9858107381 #yiv9858107381activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv9858107381 #yiv9858107381activity span {
font-weight:700;}

#yiv9858107381 #yiv9858107381activity span:first-child {
text-transform:uppercase;}

#yiv9858107381 #yiv9858107381activity span a {
color:#5085b6;text-decoration:none;}

#yiv9858107381 #yiv9858107381activity span span {
color:#ff7900;}

#yiv9858107381 #yiv9858107381activity span
.yiv9858107381underline {
text-decoration:underline;}

#yiv9858107381 .yiv9858107381attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv9858107381 .yiv9858107381attach div a {
text-decoration:none;}

#yiv9858107381 .yiv9858107381attach img {
border:none;padding-right:5px;}

#yiv9858107381 .yiv9858107381attach label {
display:block;margin-bottom:5px;}

#yiv9858107381 .yiv9858107381attach label a {
text-decoration:none;}

#yiv9858107381 blockquote {
margin:0 0 0 4px;}

#yiv9858107381 .yiv9858107381bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9858107381 .yiv9858107381bold a {
text-decoration:none;}

#yiv9858107381 dd.yiv9858107381last p a {
font-family:Verdana;font-weight:700;}

#yiv9858107381 dd.yiv9858107381last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv9858107381 dd.yiv9858107381last p
span.yiv9858107381yshortcuts {
margin-right:0;}

#yiv9858107381 div.yiv9858107381attach-table div div a {
text-decoration:none;}

#yiv9858107381 div.yiv9858107381attach-table {
width:400px;}

#yiv9858107381 div.yiv9858107381file-title a, #yiv9858107381
div.yiv9858107381file-title a:active, #yiv9858107381
div.yiv9858107381file-title a:hover, #yiv9858107381
div.yiv9858107381file-title a:visited {
text-decoration:none;}

#yiv9858107381 div.yiv9858107381photo-title a,
#yiv9858107381 div.yiv9858107381photo-title a:active,
#yiv9858107381 div.yiv9858107381photo-title a:hover,
#yiv9858107381 div.yiv9858107381photo-title a:visited {
text-decoration:none;}

#yiv9858107381 div#yiv9858107381ygrp-mlmsg
#yiv9858107381ygrp-msg p a span.yiv9858107381yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9858107381 .yiv9858107381green {
color:#628c2a;}

#yiv9858107381 .yiv9858107381MsoNormal {
margin:0 0 0 0;}

#yiv9858107381 o {
font-size:0;}

#yiv9858107381 #yiv9858107381photos div {
float:left;width:72px;}

#yiv9858107381 #yiv9858107381photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv9858107381 #yiv9858107381photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv9858107381 #yiv9858107381reco-category {
font-size:77%;}

#yiv9858107381 #yiv9858107381reco-desc {
font-size:77%;}

#yiv9858107381 .yiv9858107381replbq {
margin:4px;}

#yiv9858107381 #yiv9858107381ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg select,
#yiv9858107381 input, #yiv9858107381 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg pre, #yiv9858107381
code {
font:115% monospace;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg * {
line-height:1.22em;}

#yiv9858107381 #yiv9858107381ygrp-mlmsg #yiv9858107381logo {
padding-bottom:10px;}


#yiv9858107381 #yiv9858107381ygrp-msg p a {
font-family:Verdana;}

#yiv9858107381 #yiv9858107381ygrp-msg
p#yiv9858107381attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9858107381 #yiv9858107381ygrp-reco
#yiv9858107381reco-head {
color:#ff7900;font-weight:700;}

#yiv9858107381 #yiv9858107381ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9858107381 #yiv9858107381ygrp-sponsor #yiv9858107381ov
li a {
font-size:130%;text-decoration:none;}

#yiv9858107381 #yiv9858107381ygrp-sponsor #yiv9858107381ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9858107381 #yiv9858107381ygrp-sponsor #yiv9858107381ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9858107381 #yiv9858107381ygrp-text {
font-family:Georgia;}

#yiv9858107381 #yiv9858107381ygrp-text p {
margin:0 0 1em 0;}

#yiv9858107381 #yiv9858107381ygrp-text tt {
font-size:120%;}

#yiv9858107381 #yiv9858107381ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv9858107381
ona Petroliera a Vaii Prahova bombardata de aviatia anglo-americana

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

2a

Request Help on smfForceRecalculation coding for Excel Sheet

Sat Feb 4, 2017 8:34 am (PST) . Posted by:

frk1rxh

Hello, using Excel 2007 I built a sheet to simply pull stock quotes from yahoo and populate the sheet. When I click on the refresh button at the top of the Excel sheet toolbar the quotes do not update. I read elsewhere that
using the macro command smfForceRecalculation will do it right within the spreadsheet.



Can someone please guide or direct me to where I can find out the proper coding/syntax of the command so I would easily be able to refresh on-demand within the opened spreadsheet without having to close the sheet and reopen to refresh?


I am not familiar with macro writing so I would need more detailed instructions.


any assistance is greatly appreciated.



Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Request Help on smfForceRecalculation coding for Excel Sheet

Sat Feb 4, 2017 11:02 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the write-up on the macro on the "Tips and FAQs" web page.

I just assigned the macro to a button on my toolbar, so I can just click on
it any time I want a full update of SMF formulas.

On Sat, Feb 4, 2017 at 8:07 AM, frk1rxh@
​...wrote:

>
> Hello, using Excel 2007 I built a sheet to simply pull stock quotes from
> yahoo and populate the sheet. When I click on the refresh button at the top
> of the Excel sheet toolbar the quotes do not update. I read elsewhere that using
> the macro command smfForceRecalculation will do it right within the
> spreadsheet.
>
> Can someone please guide or direct me to where I can find out the proper
> coding/syntax of the command so I would easily be able to refresh on-demand
> within the opened spreadsheet without having to close the sheet and reopen
> to refresh?
>
> I am not familiar with macro writing so I would need more detailed
> instructions.
>
> any assistance is greatly appreciated.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

Possible to pull value from this webpage?

Sat Feb 4, 2017 10:41 am (PST) . Posted by:

jpsartrean

Is it possible to pull the 'NBA Rank' value (here 54,902) with the add in from the following webpage:


http://www.dfsgold.com/player-search?s=bhodgman http://www.dfsgold.com/player-search?s=bhodgman



?


I've looked thru the source code for the page, but can't seem to figure it a method/formula...


Would GREATLY appreciate any thoughts/suggestions.




(and sorry if this is a repost, didn't seem to go through earlier).

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: Possible to pull value from this webpage?

Sat Feb 4, 2017 10:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't see a way. It's dynamically doing the search and
returning the results, so the content isn't within the source code of the
web page.

On Sat, Feb 4, 2017 at 11:41 AM, jpsartrean@
​...wrote:

> Is it possible to pull the 'NBA Rank' value (here 54,902) with the add in
> from the following webpage:
>
> http://www.dfsgold.com/player-search?s=bhodgman
>
> ?
>
> I've looked thru the source code for the page, but can't seem to figure it
> a method/formula...
>
> Would GREATLY appreciate any thoughts/suggestions.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4

Possible to pull rank/data from this webpage?

Sat Feb 4, 2017 11:18 am (PST) . Posted by:

jpsartrean

http://www.dfsgold.com/player-search?s=bhodgman http://www.dfsgold.com/player-search?s=bhodgman





Is there any way to use the add in to pull data from this page -- in particular the 'NBA rank' here - 54,902?


I've been looking thru the source code for the page, and just can't seem to figure it out...


Any thoughts/suggestions would be GREATLY appreciated. :-)

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

5a

Re: rchcreatecomment and custom stockchart member chart

Sat Feb 4, 2017 3:03 pm (PST) . Posted by:

jhfrazer@ymail.com

Understood. Thank you.

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

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

Visit Your Group

• New Members 17

• Privacy • Unsubscribe • Terms of Use