Sabtu, 07 Mei 2016

[smf_addin] Digest Number 3692

8 Messages

Digest #3692

Messages

Fri May 6, 2016 3:47 am (PDT) . Posted by:

ethanbond911

I didn't join this forum to debate I asked a simple question and if none of you are capable then please don't respond. but if you do respond at least know what you are writing.
Ethan

Fri May 6, 2016 3:49 am (PDT) . Posted by:

ethanbond911

I didn't join this forum to debate. I don't know what smf is. if its an EXCEL add in then its excel. anyways there is always one in every group. So before responding if this Tos question doesn't apply to you, keep your smart mouth to urself.
Ethan

Fri May 6, 2016 6:07 am (PDT) . Posted by:

"J Teske" jeteske@sbcglobal.net

Ethan,
There are many helpful people on this group.  They just need to know what you need.  There are several things named "TOS" so many are probably wondering which TOS you are talking about.  Also, if you look at the bottom of the emails from the group go to the links that are listed there and that may help you figure out if this group that can help you.  Also, see a list of TOS links that may help you also:
1.  The SMF group links:   For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
2.  If the TOS you are referring to is Think or Swim there is this site which shows how to link TOS to Excel spreadsheets and trouble with that: 
https://readtheprospectus.wordpress.com/2009/09/06/linking-excel-and-think-or-swim-for-streaming-real-time-calculations/

3.  If you are talking about the Trakscape Order System, here is a You Tube video to help you out:
Export from TOS to Excel
4.  If you are talking about the The Only Sheet software program for game creation then you might try: 
https://en.wikipedia.org/wiki/The_Only_Sheet
Truly, Ethan, please clarify what you are looking for and someone might be able to help you out, but rest assured Randy does an immense amount of work for all of us using the SMF Add-In, and your approach has been more in the vein of taking and demanding rather than a reasoned discussion or give and take on what you need.  Chill out and start talking like someone who respects and is thankful for all of the incredibly FREE and incredibly GOOD that the SMF Add-In provides.
Thanks for your interest in the group... hopefully we can help after we know just exactly you are looking for - I suggest reading ALL of the documentation and FAQ's at the very least before you come back to the group with what you are looking for.
To Randy, again like all the others on this group... I am so very THANKFUL for what you do and the time you spend with each member, both new and old!!
J.E. Teske

From: "ethanbond911@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 6, 2016 6:35 AM
Subject: Re: [smf_addin] Excel and Tos

  I didn't join this forum to debate. I don't know what smf is. if its an EXCEL add in then its excel. anyways there is always one in every group. So before responding if this Tos question doesn't apply to you, keep your smart mouth to urself.Ethan
#yiv0371374657 #yiv0371374657 -- #yiv0371374657ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0371374657 #yiv0371374657ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0371374657 #yiv0371374657ygrp-mkp #yiv0371374657hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0371374657 #yiv0371374657ygrp-mkp #yiv0371374657ads {margin-bottom:10px;}#yiv0371374657 #yiv0371374657ygrp-mkp .yiv0371374657ad {padding:0 0;}#yiv0371374657 #yiv0371374657ygrp-mkp .yiv0371374657ad p {margin:0;}#yiv0371374657 #yiv0371374657ygrp-mkp .yiv0371374657ad a {color:#0000ff;text-decoration:none;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ygrp-lc {font-family:Arial;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ygrp-lc #yiv0371374657hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ygrp-lc .yiv0371374657ad {margin-bottom:10px;padding:0 0;}#yiv0371374657 #yiv0371374657actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0371374657 #yiv0371374657activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0371374657 #yiv0371374657activity span {font-weight:700;}#yiv0371374657 #yiv0371374657activity span:first-child {text-transform:uppercase;}#yiv0371374657 #yiv0371374657activity span a {color:#5085b6;text-decoration:none;}#yiv0371374657 #yiv0371374657activity span span {color:#ff7900;}#yiv0371374657 #yiv0371374657activity span .yiv0371374657underline {text-decoration:underline;}#yiv0371374657 .yiv0371374657attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0371374657 .yiv0371374657attach div a {text-decoration:none;}#yiv0371374657 .yiv0371374657attach img {border:none;padding-right:5px;}#yiv0371374657 .yiv0371374657attach label {display:block;margin-bottom:5px;}#yiv0371374657 .yiv0371374657attach label a {text-decoration:none;}#yiv0371374657 blockquote {margin:0 0 0 4px;}#yiv0371374657 .yiv0371374657bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0371374657 .yiv0371374657bold a {text-decoration:none;}#yiv0371374657 dd.yiv0371374657last p a {font-family:Verdana;font-weight:700;}#yiv0371374657 dd.yiv0371374657last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0371374657 dd.yiv0371374657last p span.yiv0371374657yshortcuts {margin-right:0;}#yiv0371374657 div.yiv0371374657attach-table div div a {text-decoration:none;}#yiv0371374657 div.yiv0371374657attach-table {width:400px;}#yiv0371374657 div.yiv0371374657file-title a, #yiv0371374657 div.yiv0371374657file-title a:active, #yiv0371374657 div.yiv0371374657file-title a:hover, #yiv0371374657 div.yiv0371374657file-title a:visited {text-decoration:none;}#yiv0371374657 div.yiv0371374657photo-title a, #yiv0371374657 div.yiv0371374657photo-title a:active, #yiv0371374657 div.yiv0371374657photo-title a:hover, #yiv0371374657 div.yiv0371374657photo-title a:visited {text-decoration:none;}#yiv0371374657 div#yiv0371374657ygrp-mlmsg #yiv0371374657ygrp-msg p a span.yiv0371374657yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0371374657 .yiv0371374657green {color:#628c2a;}#yiv0371374657 .yiv0371374657MsoNormal {margin:0 0 0 0;}#yiv0371374657 o {font-size:0;}#yiv0371374657 #yiv0371374657photos div {float:left;width:72px;}#yiv0371374657 #yiv0371374657photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0371374657 #yiv0371374657photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0371374657 #yiv0371374657reco-category {font-size:77%;}#yiv0371374657 #yiv0371374657reco-desc {font-size:77%;}#yiv0371374657 .yiv0371374657replbq {margin:4px;}#yiv0371374657 #yiv0371374657ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0371374657 #yiv0371374657ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0371374657 #yiv0371374657ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0371374657 #yiv0371374657ygrp-mlmsg select, #yiv0371374657 input, #yiv0371374657 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0371374657 #yiv0371374657ygrp-mlmsg pre, #yiv0371374657 code {font:115% monospace;}#yiv0371374657 #yiv0371374657ygrp-mlmsg * {line-height:1.22em;}#yiv0371374657 #yiv0371374657ygrp-mlmsg #yiv0371374657logo {padding-bottom:10px;}#yiv0371374657 #yiv0371374657ygrp-msg p a {font-family:Verdana;}#yiv0371374657 #yiv0371374657ygrp-msg p#yiv0371374657attach-count span {color:#1E66AE;font-weight:700;}#yiv0371374657 #yiv0371374657ygrp-reco #yiv0371374657reco-head {color:#ff7900;font-weight:700;}#yiv0371374657 #yiv0371374657ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ov li a {font-size:130%;text-decoration:none;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0371374657 #yiv0371374657ygrp-sponsor #yiv0371374657ov ul {margin:0;padding:0 0 0 8px;}#yiv0371374657 #yiv0371374657ygrp-text {font-family:Georgia;}#yiv0371374657 #yiv0371374657ygrp-text p {margin:0 0 1em 0;}#yiv0371374657 #yiv0371374657ygrp-text tt {font-size:120%;}#yiv0371374657 #yiv0371374657ygrp-vital ul li:last-child {border-right:none !important;}#yiv0371374657

Fri May 6, 2016 6:54 am (PDT) . Posted by:

mattdowney99

Wow, duh! Thanks, really appreciate the help.

Matt

Fri May 6, 2016 7:05 am (PDT) . Posted by:

ghart21

Thanks Randy
Greatly appreciated
+++++++++++

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: May 5, 2016 5:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] "Agreement - Estimate Revisions"
information from Zacks



Just do something like:

=smfGetTagContent("http://www.zacks.com/stock/quote/AAPL/detailed\
-estimates
<http://www.zacks.com/stock/quote/AAPL/detailed-estimates>
","td",1,"Down Last 30 Days",,,,1)

On Tue, May 3, 2016 at 3:05 PM, ghart23@earthlink.net
<mailto:ghart23@earthlink.net> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:

Is there a way to obtain the "Agreement - Estimate Revisions"
information from Zacks. this appears on the free "Detailed
Estimates" page in what would be the fourth section as you scroll
down. Thank you.




AAPL: APPLE INC - Detailed Estimates - Zacks.com
<http://www.zacks.com/stock/quote/AAPL/detailed-estimates>
[image]
<http://www.zacks.com/stock/quote/AAPL/detailed-estimates>
AAPL: APPLE INC - Detailed Estimates - Zacks.com
<http://www.zacks.com/stock/quote/AAPL/detailed-estimates>
AAPL: APPLE INC Detailed Estimate. Get the latest Detailed
Estimate from Zacks Investment Research. View on
www.zacks.com
<http://www.zacks.com/stock/quote/AAPL/detailed-estimates>
Preview by Yahoo



These would be the results from AAPL I am interested in:
Current Qtr
(6/2016)Next Qtr
(9/2016)Current Year
(9/2016)Next Year
(9/2017)Up Last 7 Days0000Up Last 30 Days0000Up Last 60
Days0000Down Last 7 Days12121514Down Last 30 Days12121614Down
Last 60 Days12121614



Fri May 6, 2016 8:50 am (PDT) . Posted by:

bungyman2000

In file RCHGetYahooHistory Example By Prarmeters.xls how can I extend the table so that more rows can be added to agree with the date range selected?
ty
z

Fri May 6, 2016 9:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

To extend an array-entered formula, just highlight the new range you want,
making sure it completely contains the original array range, edit and
array-enter the formula.

To change the size of an array-entered formula, copy the formula, delete
the entire array range, select the new array range, and paste and
array-enter the formula you copied.

Note that in either case, you may need to edit range references in the
formula, if they refer to a range that needs to apply to the full width or
length of the array area.

On Fri, May 6, 2016 at 8:50 AM, bungyman2000@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> In file *RCHGetYahooHistory Example By Prarmeters.xls *how can I extend
> the table so that more rows can be added to agree with the date range
> selected?
>
>

Fri May 6, 2016 10:37 am (PDT) . Posted by:

bungyman2000

Thanks Randy! It worked great. Thanks so much for the quick response.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar