13 Messages
Digest #3884
Messages
--------------------------------------------
On Sat, 1/7/17, Henry Bee henry.bee@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] I'm back!
To: smf_addin@yahoogroups.com
Cc: "Nigel Nguyen" <nigel@cassia-research.com>
Date: Saturday, January 7, 2017, 9:37 PM
Hi Randy,
I'm saddened by the news
and pray that you will return to full health
soon.
You and the group created one of the
first tools I used to perform analysis on the stock market.
I managed to automate much of DCF analysis on hundreds of
companies thanks to your tools. I was in college at the
time.
Fast forward to
today, I am now running a fast growing company with the
mission to create web-based tools to help investors. If it
wasn't for passionate and generous people like yourself,
the seed of entrepreneurship would have never been lit.
Thank you for inspiring me and so many others.
Timing wise, we are about to embark
on major efforts to add to our software the ability to
analyze and create reports on individual stocks - then use
that as a basis to form portfolios. So if you or anyone here
would like our team to help in any capacity (I.e.
ideas/visions you've always wanted to work on but never
had time for), we have our ears open.
Best wishes,
Henry
Bee / CEO, Co-founder
c. 778.389.4545
t. 347.486.6330
Book
a meeting with me:
calendly.com/cassia-bee
On Jan 6, 2017 7:45 PM,
"rharmelink@gmail.com
[smf_addin]" <smf_addin@yahoogroups.com>
wrote:
Sorry folks.
Went into the hospital on
12/14,
Transferred to rehab on
12/21.
Told them I was ready to go
home on 12/28, but it took until today to get everything all
situated for me to go home. I've been told I was going
home each day since 1/1. Just came in the front door about 2
hours ago.
Came home with equipment,
which was part of the problem.
Just a warning -- not sure
how much longer I'll be able to keep things going.
#yiv4136375200 #yiv4136375200 --
#yiv4136375200ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv4136375200 #yiv4136375200ygrp-
border:1px solid #d8d8d8;}
#yiv4136375200 #yiv4136375200ygrp-
color:#628c2a;
0;}
#yiv4136375200 #yiv4136375200ygrp-
margin-bottom:
#yiv4136375200 #yiv4136375200ygrp-
padding:0 0;}
#yiv4136375200 #yiv4136375200ygrp-
margin:0;}
#yiv4136375200 #yiv4136375200ygrp-
color:#0000ff;
#yiv4136375200 #yiv4136375200ygrp-
#yiv4136375200ygrp-
font-family:
#yiv4136375200 #yiv4136375200ygrp-
#yiv4136375200ygrp-
margin:10px
0px;font-weight:
#yiv4136375200 #yiv4136375200ygrp-
#yiv4136375200ygrp-
margin-bottom:
#yiv4136375200 #yiv4136375200actio
font-family:
#yiv4136375200 #yiv4136375200activ
background-color:
#yiv4136375200 #yiv4136375200activ
font-weight:
#yiv4136375200 #yiv4136375200activ
text-transform:
#yiv4136375200 #yiv4136375200activ
color:#5085b6;
#yiv4136375200 #yiv4136375200activ
color:#ff7900;
#yiv4136375200 #yiv4136375200activ
.yiv4136375200under
text-decoration:
#yiv4136375200 .yiv4136375200attac
clear:both;display:
0;width:400px;
#yiv4136375200 .yiv4136375200attac
text-decoration:
#yiv4136375200 .yiv4136375200attac
border:none;
#yiv4136375200 .yiv4136375200attac
display:block;
#yiv4136375200 .yiv4136375200attac
text-decoration:
#yiv4136375200 blockquote {
margin:0 0 0 4px;}
#yiv4136375200 .yiv4136375200bold {
font-family:
#yiv4136375200 .yiv4136375200bold a {
text-decoration:
#yiv4136375200 dd.yiv4136375200las
font-family:
#yiv4136375200 dd.yiv4136375200las
margin-right:
#yiv4136375200 dd.yiv4136375200las
span.yiv4136375200y
margin-right:
#yiv4136375200 div.yiv4136375200at
text-decoration:
#yiv4136375200 div.yiv4136375200at
width:400px;
#yiv4136375200 div.yiv4136375200fi
div.yiv4136375200fi
div.yiv4136375200fi
div.yiv4136375200fi
text-decoration:
#yiv4136375200 div.yiv4136375200ph
#yiv4136375200 div.yiv4136375200ph
#yiv4136375200 div.yiv4136375200ph
#yiv4136375200 div.yiv4136375200ph
text-decoration:
#yiv4136375200 div#yiv4136375200yg
#yiv4136375200ygrp-
font-family:
#yiv4136375200 .yiv4136375200green {
color:#628c2a;
#yiv4136375200 .yiv4136375200MsoNo
margin:0 0 0 0;}
#yiv4136375200 o {
font-size:0;
#yiv4136375200 #yiv4136375200photo
float:left;width:
#yiv4136375200 #yiv4136375200photo
border:1px solid
#666666;height:
#yiv4136375200 #yiv4136375200photo
color:#666666;
#yiv4136375200 #yiv4136375200reco-
font-size:77%
#yiv4136375200 #yiv4136375200reco-
font-size:77%
#yiv4136375200 .yiv4136375200replb
margin:4px;}
#yiv4136375200 #yiv4136375200ygrp-
margin-right:
#yiv4136375200 #yiv4136375200ygrp-
font-size:13px;
sans-serif;}
#yiv4136375200 #yiv4136375200ygrp-
font-size:inherit;
#yiv4136375200 #yiv4136375200ygrp-
#yiv4136375200 input, #yiv4136375200 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv4136375200 #yiv4136375200ygrp-
code {
font:115% monospace;}
#yiv4136375200 #yiv4136375200ygrp-
line-height:
#yiv4136375200 #yiv4136375200ygrp-
padding-bottom:
#yiv4136375200 #yiv4136375200ygrp-
font-family:
#yiv4136375200 #yiv4136375200ygrp-
p#yiv4136375200atta
color:#1E66AE;
#yiv4136375200 #yiv4136375200ygrp-
#yiv4136375200reco-
color:#ff7900;
#yiv4136375200 #yiv4136375200ygrp-
margin-bottom:
#yiv4136375200 #yiv4136375200ygrp-
li a {
font-size:130%
#yiv4136375200 #yiv4136375200ygrp-
li {
font-size:77%
#yiv4136375200 #yiv4136375200ygrp-
ul {
margin:0;padding:
#yiv4136375200 #yiv4136375200ygrp-
font-family:
#yiv4136375200 #yiv4136375200ygrp-
margin:0 0 1em 0;}
#yiv4136375200 #yiv4136375200ygrp-
font-size:120%
#yiv4136375200 #yiv4136375200ygrp-
border-right:
}
#yiv4136375200
Care au fost efectele crizei economice din anii 1929-1933 pentru Romania >
--------------------------------------------
On Sat, 1/7/17, Henry Bee henry.bee@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] I'm back!
To: smf_addin@yahoogroups.com
Cc: "Nigel Nguyen" <nigel@cassia-research.com>
Date: Saturday, January 7, 2017, 9:37 PM
Hi Randy,
I'm saddened by the news
and pray that you will return to full health
soon.
You and the group created one of the
first tools I used to perform analysis on the stock market.
I managed to automate much of DCF analysis on hundreds of
companies thanks to your tools. I was in college at the
time.
Fast forward to
today, I am now running a fast growing company with the
mission to create web-based tools to help investors. If it
wasn't for passionate and generous people like yourself,
the seed of entrepreneurship would have never been lit.
Thank you for inspiring me and so many others.
Timing wise, we are about to embark
on major efforts to add to our software the ability to
analyze and create reports on individual stocks - then use
that as a basis to form portfolios. So if you or anyone here
would like our team to help in any capacity (I.e.
ideas/visions you've always wanted to work on but never
had time for), we have our ears open.
Best wishes,
Henry
Bee / CEO, Co-founder
c. 778.389.4545
t. 347.486.6330
Book
a meeting with me:
calendly.com/cassia-bee
On Jan 6, 2017 7:45 PM,
"rharmelink@gmail.com
[smf_addin]" <smf_addin@yahoogroups.com>
wrote:
Sorry folks.
Went into the hospital on
12/14,
Transferred to rehab on
12/21.
Told them I was ready to go
home on 12/28, but it took until today to get everything all
situated for me to go home. I've been told I was going
home each day since 1/1. Just came in the front door about 2
hours ago.
Came home with equipment,
which was part of the problem.
Just a warning -- not sure
how much longer I'll be able to keep things going.
#yiv8296969400 #yiv8296969400 --
#yiv8296969400ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv8296969400 #yiv8296969400ygrp-
border:1px solid #d8d8d8;}
#yiv8296969400 #yiv8296969400ygrp-
color:#628c2a;
0;}
#yiv8296969400 #yiv8296969400ygrp-
margin-bottom:
#yiv8296969400 #yiv8296969400ygrp-
padding:0 0;}
#yiv8296969400 #yiv8296969400ygrp-
margin:0;}
#yiv8296969400 #yiv8296969400ygrp-
color:#0000ff;
#yiv8296969400 #yiv8296969400ygrp-
#yiv8296969400ygrp-
font-family:
#yiv8296969400 #yiv8296969400ygrp-
#yiv8296969400ygrp-
margin:10px
0px;font-weight:
#yiv8296969400 #yiv8296969400ygrp-
#yiv8296969400ygrp-
margin-bottom:
#yiv8296969400 #yiv8296969400actio
font-family:
#yiv8296969400 #yiv8296969400activ
background-color:
#yiv8296969400 #yiv8296969400activ
font-weight:
#yiv8296969400 #yiv8296969400activ
text-transform:
#yiv8296969400 #yiv8296969400activ
color:#5085b6;
#yiv8296969400 #yiv8296969400activ
color:#ff7900;
#yiv8296969400 #yiv8296969400activ
.yiv8296969400under
text-decoration:
#yiv8296969400 .yiv8296969400attac
clear:both;display:
0;width:400px;
#yiv8296969400 .yiv8296969400attac
text-decoration:
#yiv8296969400 .yiv8296969400attac
border:none;
#yiv8296969400 .yiv8296969400attac
display:block;
#yiv8296969400 .yiv8296969400attac
text-decoration:
#yiv8296969400 blockquote {
margin:0 0 0 4px;}
#yiv8296969400 .yiv8296969400bold {
font-family:
#yiv8296969400 .yiv8296969400bold a {
text-decoration:
#yiv8296969400 dd.yiv8296969400las
font-family:
#yiv8296969400 dd.yiv8296969400las
margin-right:
#yiv8296969400 dd.yiv8296969400las
span.yiv8296969400y
margin-right:
#yiv8296969400 div.yiv8296969400at
text-decoration:
#yiv8296969400 div.yiv8296969400at
width:400px;
#yiv8296969400 div.yiv8296969400fi
div.yiv8296969400fi
div.yiv8296969400fi
div.yiv8296969400fi
text-decoration:
#yiv8296969400 div.yiv8296969400ph
#yiv8296969400 div.yiv8296969400ph
#yiv8296969400 div.yiv8296969400ph
#yiv8296969400 div.yiv8296969400ph
text-decoration:
#yiv8296969400 div#yiv8296969400yg
#yiv8296969400ygrp-
font-family:
#yiv8296969400 .yiv8296969400green {
color:#628c2a;
#yiv8296969400 .yiv8296969400MsoNo
margin:0 0 0 0;}
#yiv8296969400 o {
font-size:0;
#yiv8296969400 #yiv8296969400photo
float:left;width:
#yiv8296969400 #yiv8296969400photo
border:1px solid
#666666;height:
#yiv8296969400 #yiv8296969400photo
color:#666666;
#yiv8296969400 #yiv8296969400reco-
font-size:77%
#yiv8296969400 #yiv8296969400reco-
font-size:77%
#yiv8296969400 .yiv8296969400replb
margin:4px;}
#yiv8296969400 #yiv8296969400ygrp-
margin-right:
#yiv8296969400 #yiv8296969400ygrp-
font-size:13px;
sans-serif;}
#yiv8296969400 #yiv8296969400ygrp-
font-size:inherit;
#yiv8296969400 #yiv8296969400ygrp-
#yiv8296969400 input, #yiv8296969400 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv8296969400 #yiv8296969400ygrp-
code {
font:115% monospace;}
#yiv8296969400 #yiv8296969400ygrp-
line-height:
#yiv8296969400 #yiv8296969400ygrp-
padding-bottom:
#yiv8296969400 #yiv8296969400ygrp-
font-family:
#yiv8296969400 #yiv8296969400ygrp-
p#yiv8296969400atta
color:#1E66AE;
#yiv8296969400 #yiv8296969400ygrp-
#yiv8296969400reco-
color:#ff7900;
#yiv8296969400 #yiv8296969400ygrp-
margin-bottom:
#yiv8296969400 #yiv8296969400ygrp-
li a {
font-size:130%
#yiv8296969400 #yiv8296969400ygrp-
li {
font-size:77%
#yiv8296969400 #yiv8296969400ygrp-
ul {
margin:0;padding:
#yiv8296969400 #yiv8296969400ygrp-
font-family:
#yiv8296969400 #yiv8296969400ygrp-
margin:0 0 1em 0;}
#yiv8296969400 #yiv8296969400ygrp-
font-size:120%
#yiv8296969400 #yiv8296969400ygrp-
border-right:
}
#yiv8296969400
asa tacerii de Constantin Brancusi297toate cinstirii eroilor razboiului de reintregire. Prin activitatea sa desfasurata in Occident el aduce o recunoastere larga a valorilor culturii romane din traditiile careia artistul isi ia adesea motivele pe care le prelucreaza dandu-le sensuri simbolice. O alta personalitate a artei moderne din Romania este Hans Mattis-Teutsch pictor pe care stilizarea formelor il impinge adesea dincolo de limita figurativului in domeniul artei abstracte.
Sun Jan 8, 2017 3:13 pm (PST) . Posted by:
"Paul Schultz" paulschultz54
Randy,
Best wishes and hope you get well really soon...thanks so much for all you have done for us.
Thanks,
Paul
________________________________
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com> on behalf of jpsartrean@yahoo.com [smf_addin] <smf_addin@yahoogroups.com>
Sent: Saturday, January 7, 2017 2:50 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: I'm back!
SO glad you're back home, and pray that your health continues to improve. Only the best wishes, and enormous thanks for your years of help with this profoundly ingenious program you created.
Best wishes and hope you get well really soon...thanks so much for all you have done for us.
Thanks,
Paul
________________________________
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com> on behalf of jpsartrean@yahoo.com [smf_addin] <smf_addin@yahoogroups.com>
Sent: Saturday, January 7, 2017 2:50 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: I'm back!
SO glad you're back home, and pray that your health continues to improve. Only the best wishes, and enormous thanks for your years of help with this profoundly ingenious program you created.
Sun Jan 8, 2017 3:15 pm (PST) . Posted by:
"Stevenorris" stevenorris_mss
Be well Randy, wishing you the best
Sent from my iPhone, please pardon any typos
> On Jan 8, 2017, at 5:14 PM, rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Had to go to the ER yesterday. I'll be back online when I am able to.
>
>
>
>
Sent from my iPhone, please pardon any typos
> On Jan 8, 2017, at 5:14 PM, rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Had to go to the ER yesterday. I'll be back online when I am able to.
>
>
>
>
Sun Jan 8, 2017 3:15 pm (PST) . Posted by:
"Sundeep Chadha" sundeep_chadha
Hope things are fine now. We all wish for your full recovery. Please give health your first priority. Thanks and regards, Sundeep Chadha
On Sunday, January 8, 2017 4:58 PM, "dharless@hotmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I hope you get back home soon. Thanks for all that you do for this group. Best wishes for a speedy recovery. #yiv8870522987 #yiv8870522987 -- #yiv8870522987ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8870522987 #yiv8870522987ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8870522987 #yiv8870522987ygrp-mkp #yiv8870522987hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8870522987 #yiv8870522987ygrp-mkp #yiv8870522987ads {margin-bottom:10px;}#yiv8870522987 #yiv8870522987ygrp-mkp .yiv8870522987ad {padding:0 0;}#yiv8870522987 #yiv8870522987ygrp-mkp .yiv8870522987ad p {margin:0;}#yiv8870522987 #yiv8870522987ygrp-mkp .yiv8870522987ad a {color:#0000ff;text-decoration:none;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ygrp-lc {font-family:Arial;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ygrp-lc #yiv8870522987hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ygrp-lc .yiv8870522987ad {margin-bottom:10px;padding:0 0;}#yiv8870522987 #yiv8870522987actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8870522987 #yiv8870522987activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8870522987 #yiv8870522987activity span {font-weight:700;}#yiv8870522987 #yiv8870522987activity span:first-child {text-transform:uppercase;}#yiv8870522987 #yiv8870522987activity span a {color:#5085b6;text-decoration:none;}#yiv8870522987 #yiv8870522987activity span span {color:#ff7900;}#yiv8870522987 #yiv8870522987activity span .yiv8870522987underline {text-decoration:underline;}#yiv8870522987 .yiv8870522987attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8870522987 .yiv8870522987attach div a {text-decoration:none;}#yiv8870522987 .yiv8870522987attach img {border:none;padding-right:5px;}#yiv8870522987 .yiv8870522987attach label {display:block;margin-bottom:5px;}#yiv8870522987 .yiv8870522987attach label a {text-decoration:none;}#yiv8870522987 blockquote {margin:0 0 0 4px;}#yiv8870522987 .yiv8870522987bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8870522987 .yiv8870522987bold a {text-decoration:none;}#yiv8870522987 dd.yiv8870522987last p a {font-family:Verdana;font-weight:700;}#yiv8870522987 dd.yiv8870522987last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8870522987 dd.yiv8870522987last p span.yiv8870522987yshortcuts {margin-right:0;}#yiv8870522987 div.yiv8870522987attach-table div div a {text-decoration:none;}#yiv8870522987 div.yiv8870522987attach-table {width:400px;}#yiv8870522987 div.yiv8870522987file-title a, #yiv8870522987 div.yiv8870522987file-title a:active, #yiv8870522987 div.yiv8870522987file-title a:hover, #yiv8870522987 div.yiv8870522987file-title a:visited {text-decoration:none;}#yiv8870522987 div.yiv8870522987photo-title a, #yiv8870522987 div.yiv8870522987photo-title a:active, #yiv8870522987 div.yiv8870522987photo-title a:hover, #yiv8870522987 div.yiv8870522987photo-title a:visited {text-decoration:none;}#yiv8870522987 div#yiv8870522987ygrp-mlmsg #yiv8870522987ygrp-msg p a span.yiv8870522987yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8870522987 .yiv8870522987green {color:#628c2a;}#yiv8870522987 .yiv8870522987MsoNormal {margin:0 0 0 0;}#yiv8870522987 o {font-size:0;}#yiv8870522987 #yiv8870522987photos div {float:left;width:72px;}#yiv8870522987 #yiv8870522987photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8870522987 #yiv8870522987photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8870522987 #yiv8870522987reco-category {font-size:77%;}#yiv8870522987 #yiv8870522987reco-desc {font-size:77%;}#yiv8870522987 .yiv8870522987replbq {margin:4px;}#yiv8870522987 #yiv8870522987ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8870522987 #yiv8870522987ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8870522987 #yiv8870522987ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8870522987 #yiv8870522987ygrp-mlmsg select, #yiv8870522987 input, #yiv8870522987 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8870522987 #yiv8870522987ygrp-mlmsg pre, #yiv8870522987 code {font:115% monospace;}#yiv8870522987 #yiv8870522987ygrp-mlmsg * {line-height:1.22em;}#yiv8870522987 #yiv8870522987ygrp-mlmsg #yiv8870522987logo {padding-bottom:10px;}#yiv8870522987 #yiv8870522987ygrp-msg p a {font-family:Verdana;}#yiv8870522987 #yiv8870522987ygrp-msg p#yiv8870522987attach-count span {color:#1E66AE;font-weight:700;}#yiv8870522987 #yiv8870522987ygrp-reco #yiv8870522987reco-head {color:#ff7900;font-weight:700;}#yiv8870522987 #yiv8870522987ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ov li a {font-size:130%;text-decoration:none;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8870522987 #yiv8870522987ygrp-sponsor #yiv8870522987ov ul {margin:0;padding:0 0 0 8px;}#yiv8870522987 #yiv8870522987ygrp-text {font-family:Georgia;}#yiv8870522987 #yiv8870522987ygrp-text p {margin:0 0 1em 0;}#yiv8870522987 #yiv8870522987ygrp-text tt {font-size:120%;}#yiv8870522987 #yiv8870522987ygrp-vital ul li:last-child {border-right:none !important;}#yiv8870522987
On Sunday, January 8, 2017 4:58 PM, "dharless@hotmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
I hope you get back home soon. Thanks for all that you do for this group. Best wishes for a speedy recovery. #yiv8870522987 #yiv8870522987 -- #yiv8870522987ygrp-
Sun Jan 8, 2017 4:04 pm (PST) . Posted by:
"dcauble1@gmail.com" caublda
Best wishes for better days ahead!
David
> On Jan 8, 2017, at 5:14 PM, rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Had to go to the ER yesterday. I'll be back online when I am able to.
>
>
>
>
David
> On Jan 8, 2017, at 5:14 PM, rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Had to go to the ER yesterday. I'll be back online when I am able to.
>
>
>
>
Sun Jan 8, 2017 6:44 pm (PST) . Posted by:
"Sreeram Kumar" sreraku
FolksI am trying to write a complex formula as below
=if(search("STOP",E4),(if(O4<N4)),(I4-(O4-N4))/o4),I4/o4),0). This is throwing an error saying excel cant understand the formula and puts the market at the first N4 (ie in o4 < n4).
Now, N4 here is =RCHGetYahooQuotes(A4,"l1") which works absolutely fine and gives me the quote for the ticker.
I thought of asking in excel forums but it may not be the right forum since they may not know the plugin. Hence throwing this here to see whats wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes directly and it still throws error.
Appreciate if you can shed some light.
Thankssreraku
=if(search("
Now, N4 here is =RCHGetYahooQuote
I thought of asking in excel forums but it may not be the right forum since they may not know the plugin. Hence throwing this here to see whats wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes directly and it still throws error.
Appreciate if you can shed some light.
Thankssreraku
Sun Jan 8, 2017 8:07 pm (PST) . Posted by:
gbullr
If you specify some other cells it may be useful. Right now too far up in the excel.
Search for STOP within cell e4
That will give you the position at which the word stop is found in e4 there is no value if true or false.
It just tells you at which part of e4 the word stop is you are not comparing anything therefore If is misused or uneccessary
So if you wanted to use ti it would go something like
if (Search ("Stop",E4) < 12, VALUE if TRUE, VALUE if FALSE) etc
Search for STOP within cell e4
That will give you the position at which the word stop is found in e4 there is no value if true or false.
It just tells you at which part of e4 the word stop is you are not comparing anything therefore If is misused or uneccessary
So if you wanted to use ti it would go something like
if (Search ("Stop"
Sun Jan 8, 2017 8:26 pm (PST) . Posted by:
"Joe Mo" joe_mo37
Without knowing the logic you want to employ, this is a guess:
=IF(ISERROR(SEARCH("STOP",E4)),I4/O4,IF(O4<N4,(I4-(O4-N4))/O4,0))
Joe
On Sunday, January 8, 2017 8:44 PM, "Sreeram Kumar sreeramkumar@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
FolksI am trying to write a complex formula as below
=if(search("STOP",E4),(if(O4<N4)),(I4-(O4-N4))/o4),I4/o4),0). This is throwing an error saying excel cant understand the formula and puts the market at the first N4 (ie in o4 < n4).
Now, N4 here is =RCHGetYahooQuotes(A4,"l1") which works absolutely fine and gives me the quote for the ticker.
I thought of asking in excel forums but it may not be the right forum since they may not know the plugin. Hence throwing this here to see whats wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes directly and it still throws error.
Appreciate if you can shed some light.
Thankssreraku #yiv3841138502 #yiv3841138502 -- #yiv3841138502ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3841138502 #yiv3841138502ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3841138502 #yiv3841138502ygrp-mkp #yiv3841138502hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3841138502 #yiv3841138502ygrp-mkp #yiv3841138502ads {margin-bottom:10px;}#yiv3841138502 #yiv3841138502ygrp-mkp .yiv3841138502ad {padding:0 0;}#yiv3841138502 #yiv3841138502ygrp-mkp .yiv3841138502ad p {margin:0;}#yiv3841138502 #yiv3841138502ygrp-mkp .yiv3841138502ad a {color:#0000ff;text-decoration:none;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ygrp-lc {font-family:Arial;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ygrp-lc #yiv3841138502hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ygrp-lc .yiv3841138502ad {margin-bottom:10px;padding:0 0;}#yiv3841138502 #yiv3841138502actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3841138502 #yiv3841138502activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3841138502 #yiv3841138502activity span {font-weight:700;}#yiv3841138502 #yiv3841138502activity span:first-child {text-transform:uppercase;}#yiv3841138502 #yiv3841138502activity span a {color:#5085b6;text-decoration:none;}#yiv3841138502 #yiv3841138502activity span span {color:#ff7900;}#yiv3841138502 #yiv3841138502activity span .yiv3841138502underline {text-decoration:underline;}#yiv3841138502 .yiv3841138502attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3841138502 .yiv3841138502attach div a {text-decoration:none;}#yiv3841138502 .yiv3841138502attach img {border:none;padding-right:5px;}#yiv3841138502 .yiv3841138502attach label {display:block;margin-bottom:5px;}#yiv3841138502 .yiv3841138502attach label a {text-decoration:none;}#yiv3841138502 blockquote {margin:0 0 0 4px;}#yiv3841138502 .yiv3841138502bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3841138502 .yiv3841138502bold a {text-decoration:none;}#yiv3841138502 dd.yiv3841138502last p a {font-family:Verdana;font-weight:700;}#yiv3841138502 dd.yiv3841138502last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3841138502 dd.yiv3841138502last p span.yiv3841138502yshortcuts {margin-right:0;}#yiv3841138502 div.yiv3841138502attach-table div div a {text-decoration:none;}#yiv3841138502 div.yiv3841138502attach-table {width:400px;}#yiv3841138502 div.yiv3841138502file-title a, #yiv3841138502 div.yiv3841138502file-title a:active, #yiv3841138502 div.yiv3841138502file-title a:hover, #yiv3841138502 div.yiv3841138502file-title a:visited {text-decoration:none;}#yiv3841138502 div.yiv3841138502photo-title a, #yiv3841138502 div.yiv3841138502photo-title a:active, #yiv3841138502 div.yiv3841138502photo-title a:hover, #yiv3841138502 div.yiv3841138502photo-title a:visited {text-decoration:none;}#yiv3841138502 div#yiv3841138502ygrp-mlmsg #yiv3841138502ygrp-msg p a span.yiv3841138502yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3841138502 .yiv3841138502green {color:#628c2a;}#yiv3841138502 .yiv3841138502MsoNormal {margin:0 0 0 0;}#yiv3841138502 o {font-size:0;}#yiv3841138502 #yiv3841138502photos div {float:left;width:72px;}#yiv3841138502 #yiv3841138502photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3841138502 #yiv3841138502photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3841138502 #yiv3841138502reco-category {font-size:77%;}#yiv3841138502 #yiv3841138502reco-desc {font-size:77%;}#yiv3841138502 .yiv3841138502replbq {margin:4px;}#yiv3841138502 #yiv3841138502ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3841138502 #yiv3841138502ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3841138502 #yiv3841138502ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3841138502 #yiv3841138502ygrp-mlmsg select, #yiv3841138502 input, #yiv3841138502 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3841138502 #yiv3841138502ygrp-mlmsg pre, #yiv3841138502 code {font:115% monospace;}#yiv3841138502 #yiv3841138502ygrp-mlmsg * {line-height:1.22em;}#yiv3841138502 #yiv3841138502ygrp-mlmsg #yiv3841138502logo {padding-bottom:10px;}#yiv3841138502 #yiv3841138502ygrp-msg p a {font-family:Verdana;}#yiv3841138502 #yiv3841138502ygrp-msg p#yiv3841138502attach-count span {color:#1E66AE;font-weight:700;}#yiv3841138502 #yiv3841138502ygrp-reco #yiv3841138502reco-head {color:#ff7900;font-weight:700;}#yiv3841138502 #yiv3841138502ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ov li a {font-size:130%;text-decoration:none;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3841138502 #yiv3841138502ygrp-sponsor #yiv3841138502ov ul {margin:0;padding:0 0 0 8px;}#yiv3841138502 #yiv3841138502ygrp-text {font-family:Georgia;}#yiv3841138502 #yiv3841138502ygrp-text p {margin:0 0 1em 0;}#yiv3841138502 #yiv3841138502ygrp-text tt {font-size:120%;}#yiv3841138502 #yiv3841138502ygrp-vital ul li:last-child {border-right:none !important;}#yiv3841138502
=IF(ISERROR(SEARCH("STOP",E4)),I4/O4,IF(O4<N4,(I4-(O4-N4))/O4,0))
Joe
On Sunday, January 8, 2017 8:44 PM, "Sreeram Kumar sreeramkumar@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
FolksI am trying to write a complex formula as below
=if(search("
Now, N4 here is =RCHGetYahooQuote
I thought of asking in excel forums but it may not be the right forum since they may not know the plugin. Hence throwing this here to see whats wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes directly and it still throws error.
Appreciate if you can shed some light.
Thankssreraku #yiv3841138502 #yiv3841138502 -- #yiv3841138502ygrp-
Sun Jan 8, 2017 8:35 pm (PST) . Posted by:
"Gaston Bullrich" gbullr
That might work if "STOP" is not included in the search.
I don't know the ISERROR treatment for #VALUE return which is what happens
when "STOP" is not in the search.
On Sun, Jan 8, 2017 at 11:26 PM, Joe Mo joe_mo37@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Without knowing the logic you want to employ, this is a guess:
>
> =IF(ISERROR(SEARCH("STOP",E4)),I4/O4,IF(O4<N4,(I4-(O4-N4))/O4,0))
>
> Joe
>
>
> On Sunday, January 8, 2017 8:44 PM, "Sreeram Kumar sreeramkumar@yahoo.com
> [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
>
> Folks
> I am trying to write a complex formula as below
>
> =if(search("STOP",E4),(if(O4<N4)),(I4-(O4-N4))/o4),I4/o4),0). This is
> throwing an error saying excel cant understand the formula and puts the
> market at the first N4 (ie in o4 < n4).
>
> Now, N4 here is =RCHGetYahooQuotes(A4,"l1") which works absolutely fine
> and gives me the quote for the ticker.
>
> I thought of asking in excel forums but it may not be the right forum
> since they may not know the plugin. Hence throwing this here to see whats
> wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes
> directly and it still throws error.
>
> Appreciate if you can shed some light.
>
> Thanks
> sreraku
>
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
I don't know the ISERROR treatment for #VALUE return which is what happens
when "STOP" is not in the search.
On Sun, Jan 8, 2017 at 11:26 PM, Joe Mo joe_mo37@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Without knowing the logic you want to employ, this is a guess:
>
> =IF(ISERROR(SEARCH("STOP",E4)),I4/O4,IF(O4<N4,(I4-(O4-N4))/O4,0))
>
> Joe
>
>
> On Sunday, January 8, 2017 8:44 PM, "Sreeram Kumar sreeramkumar@yahoo.com
> [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
>
> Folks
> I am trying to write a complex formula as below
>
> =if(search("
> throwing an error saying excel cant understand the formula and puts the
> market at the first N4 (ie in o4 < n4).
>
> Now, N4 here is =RCHGetYahooQuotes(
> and gives me the quote for the ticker.
>
> I thought of asking in excel forums but it may not be the right forum
> since they may not know the plugin. Hence throwing this here to see whats
> wrong with my formula. BTW, I replaced n4 with the RCHGetYahooQuotes
> directly and it still throws error.
>
> Appreciate if you can shed some light.
>
> Thanks
> sreraku
>
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
--------------------------------------------
On Mon, 1/9/17, Gaston Bullrich gaston.bullrich@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] RCHGetYahooQuotes issue
To: smf_addin@yahoogroups.com
Date: Monday, January 9, 2017, 6:34 AM
That might work if
"STOP" is not included in the search.
I don't know
the ISERROR treatment for #VALUE return which is what
happens when "STOP" is not in the
search.
On Sun, Jan 8, 2017 at
11:26 PM, Joe Mo joe_mo37@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:
Without
knowing the logic you want to employ, this is a
guess:
=IF(ISERROR(SEARCH("STOP",E4))
,I4/O4,IF(O4<N4,(I4-(O4-N4))/ O4,0))
Joe
On Sunday, January 8,
2017 8:44 PM, "Sreeram Kumar sreeramkumar@yahoo.com
[smf_addin]" <smf_addin@yahoogroups.com>
wrote:
FolksI
am trying to write a complex formula as below
=if(search("
N4)),(I4-(O4-
error saying excel cant understand the formula and puts the
market at the first N4 (ie in o4 < n4).
Now,
N4 here is =RCHGetYahooQuote
works absolutely fine and gives me the quote for the
ticker.
I
thought of asking in excel forums but it may not be the
right forum since they may not know the plugin. Hence
throwing this here to see whats wrong with my formula. BTW,
I replaced n4 with the RCHGetYahooQuotes directly and it
still throws error.
Appreciate
if you can shed some light.
Thankssreraku
--
Gaston Bullrich
9 Island
Avenue Apt 1406 Miami Beach, Florida 33139
Cel. 917 517 9907
#yiv9506629500 #yiv9506629500 --
#yiv9506629500ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv9506629500 #yiv9506629500ygrp-
border:1px solid #d8d8d8;}
#yiv9506629500 #yiv9506629500ygrp-
color:#628c2a;
0;}
#yiv9506629500 #yiv9506629500ygrp-
margin-bottom:
#yiv9506629500 #yiv9506629500ygrp-
padding:0 0;}
#yiv9506629500 #yiv9506629500ygrp-
margin:0;}
#yiv9506629500 #yiv9506629500ygrp-
color:#0000ff;
#yiv9506629500 #yiv9506629500ygrp-
#yiv9506629500ygrp-
font-family:
#yiv9506629500 #yiv9506629500ygrp-
#yiv9506629500ygrp-
margin:10px
0px;font-weight:
#yiv9506629500 #yiv9506629500ygrp-
#yiv9506629500ygrp-
margin-bottom:
#yiv9506629500 #yiv9506629500actio
font-family:
#yiv9506629500 #yiv9506629500activ
background-color:
#yiv9506629500 #yiv9506629500activ
font-weight:
#yiv9506629500 #yiv9506629500activ
text-transform:
#yiv9506629500 #yiv9506629500activ
color:#5085b6;
#yiv9506629500 #yiv9506629500activ
color:#ff7900;
#yiv9506629500 #yiv9506629500activ
.yiv9506629500under
text-decoration:
#yiv9506629500 .yiv9506629500attac
clear:both;display:
0;width:400px;
#yiv9506629500 .yiv9506629500attac
text-decoration:
#yiv9506629500 .yiv9506629500attac
border:none;
#yiv9506629500 .yiv9506629500attac
display:block;
#yiv9506629500 .yiv9506629500attac
text-decoration:
#yiv9506629500 blockquote {
margin:0 0 0 4px;}
#yiv9506629500 .yiv9506629500bold {
font-family:
#yiv9506629500 .yiv9506629500bold a {
text-decoration:
#yiv9506629500 dd.yiv9506629500las
font-family:
#yiv9506629500 dd.yiv9506629500las
margin-right:
#yiv9506629500 dd.yiv9506629500las
span.yiv9506629500y
margin-right:
#yiv9506629500 div.yiv9506629500at
text-decoration:
#yiv9506629500 div.yiv9506629500at
width:400px;
#yiv9506629500 div.yiv9506629500fi
div.yiv9506629500fi
div.yiv9506629500fi
div.yiv9506629500fi
text-decoration:
#yiv9506629500 div.yiv9506629500ph
#yiv9506629500 div.yiv9506629500ph
#yiv9506629500 div.yiv9506629500ph
#yiv9506629500 div.yiv9506629500ph
text-decoration:
#yiv9506629500 div#yiv9506629500yg
#yiv9506629500ygrp-
font-family:
#yiv9506629500 .yiv9506629500green {
color:#628c2a;
#yiv9506629500 .yiv9506629500MsoNo
margin:0 0 0 0;}
#yiv9506629500 o {
font-size:0;
#yiv9506629500 #yiv9506629500photo
float:left;width:
#yiv9506629500 #yiv9506629500photo
border:1px solid
#666666;height:
#yiv9506629500 #yiv9506629500photo
color:#666666;
#yiv9506629500 #yiv9506629500reco-
font-size:77%
#yiv9506629500 #yiv9506629500reco-
font-size:77%
#yiv9506629500 .yiv9506629500replb
margin:4px;}
#yiv9506629500 #yiv9506629500ygrp-
margin-right:
#yiv9506629500 #yiv9506629500ygrp-
font-size:13px;
sans-serif;}
#yiv9506629500 #yiv9506629500ygrp-
font-size:inherit;
#yiv9506629500 #yiv9506629500ygrp-
#yiv9506629500 input, #yiv9506629500 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv9506629500 #yiv9506629500ygrp-
code {
font:115% monospace;}
#yiv9506629500 #yiv9506629500ygrp-
line-height:
#yiv9506629500 #yiv9506629500ygrp-
padding-bottom:
#yiv9506629500 #yiv9506629500ygrp-
font-family:
#yiv9506629500 #yiv9506629500ygrp-
p#yiv9506629500atta
color:#1E66AE;
#yiv9506629500 #yiv9506629500ygrp-
#yiv9506629500reco-
color:#ff7900;
#yiv9506629500 #yiv9506629500ygrp-
margin-bottom:
#yiv9506629500 #yiv9506629500ygrp-
li a {
font-size:130%
#yiv9506629500 #yiv9506629500ygrp-
li {
font-size:77%
#yiv9506629500 #yiv9506629500ygrp-
ul {
margin:0;padding:
#yiv9506629500 #yiv9506629500ygrp-
font-family:
#yiv9506629500 #yiv9506629500ygrp-
margin:0 0 1em 0;}
#yiv9506629500 #yiv9506629500ygrp-
font-size:120%
#yiv9506629500 #yiv9506629500ygrp-
border-right:
}
#yiv9506629500
2Aceste cereri nu ies pentru ca nu depasesc din domeniul dreptului si al echitatii Congresul satisfacandu-
Sun Jan 8, 2017 11:37 pm (PST) . Posted by:
"steve thompson" stevet99uk
A I understand (unfortunately not enough!) the oHTTP.ReadyState is returned
from the DoEvents, and reflects the result of reading/downloading data from
the web.
I find that on some accasions, the oHTTP.ReadyState never gets to 4,
probably due to a call to the web that is invalid or a web page not
returning it.
What I need is a timing loop on this and if the doevents does not respond
correctly, then print out a message as to the failed call.
My main type of call is
smfGetTagContent("http://webfund6.financialexpress.net/clients/dailymail/Fun
dFactsheet.aspx?CitiCode="&$B315,"h",4), downloading data from a daily mail
financial page, the $B315 is the CitiCode of the fund and the number 4
changes to reflect the data on the page I want to read.
steve
from the DoEvents, and reflects the result of reading/downloading data from
the web.
I find that on some accasions, the oHTTP.ReadyState never gets to 4,
probably due to a call to the web that is invalid or a web page not
returning it.
What I need is a timing loop on this and if the doevents does not respond
correctly, then print out a message as to the failed call.
My main type of call is
smfGetTagContent("http://webfund6.financialexpress.net/clients/dailymail/Fun
dFactsheet.aspx?
financial page, the $B315 is the CitiCode of the fund and the number 4
changes to reflect the data on the page I want to read.
steve
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar