13 Messages
Digest #3986
Messages
Wed Apr 26, 2017 7:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Strange. Now I do see dianejase -- joined Sep 18, 2006...
So 3 months after the start of the group.
On Wed, Apr 26, 2017 at 5:57 AM, jason@
...wrote:
> I imagine you have grown tired of this type of message. I use your
> add-in to track and make decisions on my retirement folio since near the
> beginning of your board. I fear the day you decide it is time to quit and
> the function will slowly deteriorate as source data changes. *Nonetheless,
> if you ever take donations I am ready to show my appreciation*. Out of
> curiosity, can you see how long bamzoomalice or dianejase has been a
> member? I imagine it could go back to your first 500 members?
>
>
So 3 months after the start of the group.
On Wed, Apr 26, 2017 at 5:57 AM, jason@
...wrote:
> I imagine you have grown tired of this type of message. I use your
> add-in to track and make decisions on my retirement folio since near the
> beginning of your board. I fear the day you decide it is time to quit and
> the function will slowly deteriorate as source data changes. *Nonetheless,
> if you ever take donations I am ready to show my appreciation*
> curiosity, can you see how long bamzoomalice or dianejase has been a
> member? I imagine it could go back to your first 500 members?
>
>
Wed Apr 26, 2017 8:01 pm (PDT) . Posted by:
lapub1
HI Randy,
I've been using RCHgetwebdata to parse a .txt document I save to my PC from a website. However after installing the recently updated SMF_add in the RCHgetwebdata formula I use returns error.
I tried an older copy of the .txt to make sure the provider hasn't changed their formatting and I still get an error.
The formula is =RCHGetwebdata("C:\Users\Elliot\my documents\acquireEvents[31].txt",A5,25)
Thoughts?
Elliot.
I've been using RCHgetwebdata to parse a .txt document I save to my PC from a website. However after installing the recently updated SMF_add in the RCHgetwebdata formula I use returns error.
I tried an older copy of the .txt to make sure the provider hasn't changed their formatting and I still get an error.
The formula is =RCHGetwebdata(
Thoughts?
Elliot.
Wed Apr 26, 2017 8:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetWebData() shouldn't have changed. But you need to use the "file://"
protocol to read a local file. For example, this works for me:
=RCHGetWebData("file://C:\Users\Randy\Documents\#Work\Test.txt";)
...but not this:
=RCHGetWebData("C:\Users\Randy\Documents\#Work\Test.txt";)
On Wed, Apr 26, 2017 at 8:01 PM, lapub1@
...wrote:
> I've been using RCHgetwebdata to parse a .txt document I save to my PC
> from a website. However after installing the recently updated SMF_add in
> the RCHgetwebdata formula I use returns error.
>
> I tried an older copy of the .txt to make sure the provider hasn't changed
> their formatting and I still get an error.
>
> The formula is =RCHGetwebdata("C:\Users\Elliot\my
> documents\acquireEvents[31].txt",A5,25)
>
>
protocol to read a local file. For example, this works for me:
=RCHGetWebData("file://C:\Users&#
...but not this:
=RCHGetWebData(
On Wed, Apr 26, 2017 at 8:01 PM, lapub1@
...wrote:
> I've been using RCHgetwebdata to parse a .txt document I save to my PC
> from a website. However after installing the recently updated SMF_add in
> the RCHgetwebdata formula I use returns error.
>
> I tried an older copy of the .txt to make sure the provider hasn't changed
> their formatting and I still get an error.
>
> The formula is =RCHGetwebdata(
> documents\
>
>
Wed Apr 26, 2017 8:59 pm (PDT) . Posted by:
lapub1
Great that works thanks Randy!
Curious why it changed to having to use the file directory?
Elliot.
Curious why it changed to having to use the file directory?
Elliot.
Thu Apr 27, 2017 4:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
In the past, I've always had to use the "file://" protocol to get a local
file. I have no idea why you didn't need to...
On Wed, Apr 26, 2017 at 8:59 PM, lapub1@
...wrote:
>
> Great that works thanks Randy!
>
> Curious why it changed to having to use the file directory?
>
>
>
file. I have no idea why you didn't need to...
On Wed, Apr 26, 2017 at 8:59 PM, lapub1@
...wrote:
>
> Great that works thanks Randy!
>
> Curious why it changed to having to use the file directory?
>
>
>
Wed Apr 26, 2017 9:22 pm (PDT) . Posted by:
cyy001
Thanks Randy, The latest update fixed this issue. smfGetOptionQuotes() is working again.
Thu Apr 27, 2017 7:49 am (PDT) . Posted by:
"randy tofsrud" rst66
Randy,Yes the new update seems to have mostly fixed my problem. I still have 2 tickers out of approx 30 that are showing ERROR. They are (embarrassingly) AFSI June 16 $25 Put and LULU June 16 $70 Call. I have tried both of the possible SMF formats (see below).
Interestingly enough (I think) the old =smfGetYahooOptionQuote is also returning quotes. Was that expected?
Thanks for your excellent help.Randy
On Wednesday, April 26, 2017 10:22 PM, "cyy001@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Thanks Randy, The latest update fixed this issue. smfGetOptionQuotes() is working again. #yiv7875836358 #yiv7875836358 -- #yiv7875836358ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7875836358 #yiv7875836358ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7875836358 #yiv7875836358ygrp-mkp #yiv7875836358hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7875836358 #yiv7875836358ygrp-mkp #yiv7875836358ads {margin-bottom:10px;}#yiv7875836358 #yiv7875836358ygrp-mkp .yiv7875836358ad {padding:0 0;}#yiv7875836358 #yiv7875836358ygrp-mkp .yiv7875836358ad p {margin:0;}#yiv7875836358 #yiv7875836358ygrp-mkp .yiv7875836358ad a {color:#0000ff;text-decoration:none;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ygrp-lc {font-family:Arial;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ygrp-lc #yiv7875836358hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ygrp-lc .yiv7875836358ad {margin-bottom:10px;padding:0 0;}#yiv7875836358 #yiv7875836358actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7875836358 #yiv7875836358activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7875836358 #yiv7875836358activity span {font-weight:700;}#yiv7875836358 #yiv7875836358activity span:first-child {text-transform:uppercase;}#yiv7875836358 #yiv7875836358activity span a {color:#5085b6;text-decoration:none;}#yiv7875836358 #yiv7875836358activity span span {color:#ff7900;}#yiv7875836358 #yiv7875836358activity span .yiv7875836358underline {text-decoration:underline;}#yiv7875836358 .yiv7875836358attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7875836358 .yiv7875836358attach div a {text-decoration:none;}#yiv7875836358 .yiv7875836358attach img {border:none;padding-right:5px;}#yiv7875836358 .yiv7875836358attach label {display:block;margin-bottom:5px;}#yiv7875836358 .yiv7875836358attach label a {text-decoration:none;}#yiv7875836358 blockquote {margin:0 0 0 4px;}#yiv7875836358 .yiv7875836358bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7875836358 .yiv7875836358bold a {text-decoration:none;}#yiv7875836358 dd.yiv7875836358last p a {font-family:Verdana;font-weight:700;}#yiv7875836358 dd.yiv7875836358last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7875836358 dd.yiv7875836358last p span.yiv7875836358yshortcuts {margin-right:0;}#yiv7875836358 div.yiv7875836358attach-table div div a {text-decoration:none;}#yiv7875836358 div.yiv7875836358attach-table {width:400px;}#yiv7875836358 div.yiv7875836358file-title a, #yiv7875836358 div.yiv7875836358file-title a:active, #yiv7875836358 div.yiv7875836358file-title a:hover, #yiv7875836358 div.yiv7875836358file-title a:visited {text-decoration:none;}#yiv7875836358 div.yiv7875836358photo-title a, #yiv7875836358 div.yiv7875836358photo-title a:active, #yiv7875836358 div.yiv7875836358photo-title a:hover, #yiv7875836358 div.yiv7875836358photo-title a:visited {text-decoration:none;}#yiv7875836358 div#yiv7875836358ygrp-mlmsg #yiv7875836358ygrp-msg p a span.yiv7875836358yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7875836358 .yiv7875836358green {color:#628c2a;}#yiv7875836358 .yiv7875836358MsoNormal {margin:0 0 0 0;}#yiv7875836358 o {font-size:0;}#yiv7875836358 #yiv7875836358photos div {float:left;width:72px;}#yiv7875836358 #yiv7875836358photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7875836358 #yiv7875836358photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7875836358 #yiv7875836358reco-category {font-size:77%;}#yiv7875836358 #yiv7875836358reco-desc {font-size:77%;}#yiv7875836358 .yiv7875836358replbq {margin:4px;}#yiv7875836358 #yiv7875836358ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7875836358 #yiv7875836358ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7875836358 #yiv7875836358ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7875836358 #yiv7875836358ygrp-mlmsg select, #yiv7875836358 input, #yiv7875836358 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7875836358 #yiv7875836358ygrp-mlmsg pre, #yiv7875836358 code {font:115% monospace;}#yiv7875836358 #yiv7875836358ygrp-mlmsg * {line-height:1.22em;}#yiv7875836358 #yiv7875836358ygrp-mlmsg #yiv7875836358logo {padding-bottom:10px;}#yiv7875836358 #yiv7875836358ygrp-msg p a {font-family:Verdana;}#yiv7875836358 #yiv7875836358ygrp-msg p#yiv7875836358attach-count span {color:#1E66AE;font-weight:700;}#yiv7875836358 #yiv7875836358ygrp-reco #yiv7875836358reco-head {color:#ff7900;font-weight:700;}#yiv7875836358 #yiv7875836358ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ov li a {font-size:130%;text-decoration:none;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7875836358 #yiv7875836358ygrp-sponsor #yiv7875836358ov ul {margin:0;padding:0 0 0 8px;}#yiv7875836358 #yiv7875836358ygrp-text {font-family:Georgia;}#yiv7875836358 #yiv7875836358ygrp-text p {margin:0 0 1em 0;}#yiv7875836358 #yiv7875836358ygrp-text tt {font-size:120%;}#yiv7875836358 #yiv7875836358ygrp-vital ul li:last-child {border-right:none !important;}#yiv7875836358
Interestingly enough (I think) the old =smfGetYahooOptionQuote is also returning quotes. Was that expected?
Thanks for your excellent help.Randy
On Wednesday, April 26, 2017 10:22 PM, "cyy001@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Thanks Randy, The latest update fixed this issue. smfGetOptionQ
Thu Apr 27, 2017 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's not surprising those two fail. Yahoo doesn't have data on them...
smfGetYahooOptionQuote() better work. That's what smfGetOptionQuotes()
calls to get option quotes from Yahoo...
On Thu, Apr 27, 2017 at 7:35 AM, randy tofsrud rst66@
...wrote:
> Yes the new update seems to have mostly fixed my problem. I still have 2
> tickers out of approx 30 that are showing ERROR. They are (embarrassingly)
> AFSI June 16 $25 Put and LULU June 16 $70 Call. I have tried both of the
> possible SMF formats (see below).
>
> Interestingly enough (I think) the old =smfGetYahooOptionQuote is also
> returning quotes. Was that expected?
>
>
>
smfGetYahooOptionQu
calls to get option quotes from Yahoo...
On Thu, Apr 27, 2017 at 7:35 AM, randy tofsrud rst66@
...wrote:
> Yes the new update seems to have mostly fixed my problem. I still have 2
> tickers out of approx 30 that are showing ERROR. They are (embarrassingly)
> AFSI June 16 $25 Put and LULU June 16 $70 Call. I have tried both of the
> possible SMF formats (see below).
>
> Interestingly enough (I think) the old =smfGetYahooOptionQ
> returning quotes. Was that expected?
>
>
>
Wed Apr 26, 2017 9:27 pm (PDT) . Posted by:
cyy001
I am getting different stock prices using RCHGetYahooQuotes...
=RCHGetYahooQuotes("SBUX","ol1") returns 61.1
=RCHGetYahooQuotes("HD","ol1") returns 153.11
But the Yahoo site
https://finance.yahoo.com/quote/SBUX?ltr=1 https://finance.yahoo.com/quote/SBUX?ltr=1 shows $61.56 (same as shown in Fidelity)
https://finance.yahoo.com/quote/HD?ltr=1 https://finance.yahoo.com/quote/SBUX?ltr=1 shows $154.22 (same as shown in Fidelity)
Since this is after hours, the difference cannot be due to trading.
Is there a reason why the values the different? Is there another function call I should use to retrieve the stock price?
Best
=RCHGetYahooQuotes("SBUX","ol1") returns 61.1
=RCHGetYahooQuotes("HD","ol1") returns 153.11
But the Yahoo site
https://finance.yahoo.com/quote/SBUX?ltr=1 https://finance.yahoo.com/quote/SBUX?ltr=1 shows $61.56 (same as shown in Fidelity)
https://finance.yahoo.com/quote/HD?ltr=1 https://finance.yahoo.com/quote/SBUX?ltr=1 shows $154.22 (same as shown in Fidelity)
Since this is after hours, the difference cannot be due to trading.
Is there a reason why the values the different? Is there another function call I should use to retrieve the stock price?
Best
Thu Apr 27, 2017 4:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, the two RCHGetYahooQuotes() functions are asking for TWO values to be
returned -- opening price and last traded price. If you're just entering it
into a single cell, all you'll see is the opening price. Just use "l1" if
all you want is the last traded price...
On Wed, Apr 26, 2017 at 9:27 PM, cyy001@
...wrote:
> I am getting different stock prices using RCHGetYahooQuotes...
>
> =RCHGetYahooQuotes("SBUX","ol1") returns 61.1
>
> =RCHGetYahooQuotes("HD","ol1") returns 153.11
>
> But the Yahoo site
>
> https://finance.yahoo.com/quote/SBUX?ltr=1 shows $61.56 (same as shown in
> Fidelity)
>
> https://finance.yahoo.com/quote/HD?ltr=1
> <https://finance.yahoo.com/quote/SBUX?ltr=1> shows $154.22 (same as shown
> in Fidelity)
>
> Since this is after hours, the difference cannot be due to trading.
>
> Is there a reason why the values the different? Is there another function
> call I should use to retrieve the stock price?
>
>
returned -- opening price and last traded price. If you're just entering it
into a single cell, all you'll see is the opening price. Just use "l1" if
all you want is the last traded price...
On Wed, Apr 26, 2017 at 9:27 PM, cyy001@
...wrote:
> I am getting different stock prices using RCHGetYahooQuotes...
>
> =RCHGetYahooQuotes("SBUX","ol1") returns 61.1
>
> =RCHGetYahooQuotes("HD","ol1") returns 153.11
>
> But the Yahoo site
>
> https://finance.yahoo.com/quote/SBUX?ltr=1 shows $61.56 (same as shown in
> Fidelity)
>
> https://finance.yahoo.com/quote/HD?ltr=1
> <https://finance.yahoo.com/quote/SBUX?ltr=1> shows $154.22 (same as shown
> in Fidelity)
>
> Since this is after hours, the difference cannot be due to trading.
>
> Is there a reason why the values the different? Is there another function
> call I should use to retrieve the stock price?
>
>
Thu Apr 27, 2017 1:35 am (PDT) . Posted by:
reiswaffel1980
Wow thanks Randy!!!
Amazing support!!!
Have a great day
Amazing support!!!
Have a great day
Thu Apr 27, 2017 4:30 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
Randy,
Is there a URL similar to
http://quotes.morningstar.com/stock/c-company-profile?t=MSFT that produces
the "Industry Classification"; portion of the Company Profile that includes
NAICS?
Thanks
--
Robbie Geary
Is there a URL similar to
http://quotes.morningstar.com/stock/c-company-profile?t=MSFT that produces
the "Industry Classification"
NAICS?
Thanks
--
Robbie Geary
Thu Apr 27, 2017 4:34 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
I got it:
http://financials.morningstar.com/cmpind/company-profile/component.action?component=IndustryClassification&t=XNAS:MSFT
On Thu, Apr 27, 2017 at 9:30 PM, Robbie Geary <rgearyiii@gmail.com> wrote:
> Randy,
>
> Is there a URL similar to http://quotes.morningstar.com/
> stock/c-company-profile?t=MSFT that produces the "Industry
> Classification"; portion of the Company Profile that includes NAICS?
>
> Thanks
>
> --
> Robbie Geary
>
--
Robbie Geary
http://financials.morningstar.com/cmpind/company-profile/component.action?component=IndustryClassification&t=XNAS:MSFT
On Thu, Apr 27, 2017 at 9:30 PM, Robbie Geary <rgearyiii@gmail.com> wrote:
> Randy,
>
> Is there a URL similar to http://quotes.morningstar.com/
> stock/c-company-
> Classification"
>
> Thanks
>
> --
> Robbie Geary
>
--
Robbie Geary
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar