15 Messages
Digest #3969
Messages
Mon Apr 17, 2017 11:12 am (PDT) . Posted by:
rjemery7
Using your tools, how can Beta be obtained for any equity?
Mon Apr 17, 2017 12:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would depend on the data source you want to use. From past discussions,
I recall various sources had betas based on either a 1-year, 3-year, or
5-year basis.
I think the Yahoo Key Statistics have an element definition for a beta
value? Check the data glossary on Yahoo -- I think it's a 1-year value.
On Mon, Apr 17, 2017 at 11:12 AM, rjemery@
...wrote:
> Using your tools, how can Beta be obtained for any equity?
>
>
I recall various sources had betas based on either a 1-year, 3-year, or
5-year basis.
I think the Yahoo Key Statistics have an element definition for a beta
value? Check the data glossary on Yahoo -- I think it's a 1-year value.
On Mon, Apr 17, 2017 at 11:12 AM, rjemery@
...wrote:
> Using your tools, how can Beta be obtained for any equity?
>
>
Mon Apr 17, 2017 11:13 am (PDT) . Posted by:
rjemery7
Using RCHGetYahooQuotes(), it is possible to obtain such data as Float Shares, EPS Estimates, etc., for as of the current date. How could that same information be obtained on a historical basis?
Mon Apr 17, 2017 12:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to check either AdvFN or GuruFocus. They may have those values
from the historical financial statements.
I don't know of a historical source of analyst estimates, other than their
stated look-back periods on the web pages.
On Mon, Apr 17, 2017 at 11:13 AM, rjemery@
...wrote:
> Using RCHGetYahooQuotes(), it is possible to obtain such data as Float
> Shares, EPS Estimates, etc., for as of the current date. How could that
> same information be obtained on a historical basis?
>
from the historical financial statements.
I don't know of a historical source of analyst estimates, other than their
stated look-back periods on the web pages.
On Mon, Apr 17, 2017 at 11:13 AM, rjemery@
...wrote:
> Using RCHGetYahooQuotes(
> Shares, EPS Estimates, etc., for as of the current date. How could that
> same information be obtained on a historical basis?
>
Mon Apr 17, 2017 11:38 am (PDT) . Posted by:
rjemery7
If TO is the suffix for the Toronto Exchange, where can I find a list of suffixes for other exchanges that Yahoo Finance has equity coverage?
Mon Apr 17, 2017 12:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no idea.
On Mon, Apr 17, 2017 at 11:38 AM, rjemery@
...wrote:
>
> If TO is the suffix for the Toronto Exchange, where can I find a list of
> suffixes for other exchanges that Yahoo Finance has equity coverage?
>
On Mon, Apr 17, 2017 at 11:38 AM, rjemery@
...wrote:
>
> If TO is the suffix for the Toronto Exchange, where can I find a list of
> suffixes for other exchanges that Yahoo Finance has equity coverage?
>
Mon Apr 17, 2017 11:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo changed the URL protocol for the historical quotes from "http://" to
"https://", so I had to update the add-in code. I've uploaded the new file
to the website:
http://ogres-crypt.com/SMF/
On Mon, Apr 17, 2017 at 8:12 AM, sanjay.p.chhabria@
...wrote:
>
> This morning this function returns a #N/A value. Other functions seem to
> be working. Would appreciate any help troubleshooting this.
>
"https://", so I had to update the add-in code. I've uploaded the new file
to the website:
http://ogres-crypt.com/SMF/
On Mon, Apr 17, 2017 at 8:12 AM, sanjay.p.chhabria@
...wrote:
>
> This morning this function returns a #N/A value. Other functions seem to
> be working. Would appreciate any help troubleshooting this.
>
Mon Apr 17, 2017 12:22 pm (PDT) . Posted by:
tonyestep
Ah, thanks so much, Randy. I had just finished manually grabbing several CSV files of historical data, re-formatting them, copying them into the place where the Yahoo function had bombed, and so on -- an ugly task. Sure am glad to see the SMF function working again.
You're the greatest!
You're the greatest!
Mon Apr 17, 2017 11:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Wow. Another change from Yahoo already? Good thing I installed Office 365
yesterday...
*Date* *Routine* *Description*
2017-04-17 RCHGetYahooHistory
smfPricesByDates Fix for Yahoo changes of historical data URL protocol from
"http://" to "https://"
I've uploaded a new version of the add-in and a new change log:
http://ogres-crypt.com/SMF/
http://ogres-crypt.com/SMF/Documentation/index.html
yesterday...
*Date* *Routine* *Description*
2017-04-17 RCHGetYahooHistory
smfPricesByDates Fix for Yahoo changes of historical data URL protocol from
"http://" to "https://"
I've uploaded a new version of the add-in and a new change log:
http://ogres-crypt.com/SMF/
http://ogres-crypt.com/SMF/Documentation/index.html
Mon Apr 17, 2017 12:50 pm (PDT) . Posted by:
"Joe Mo" joe_mo37
Thank you Randy for sharing your gift for coding with us and your generous devotion to keeping your code updated for us!
On Monday, April 17, 2017 1:58 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Wow. Another change from Yahoo already? Good thing I installed Office 365 yesterday...
| Date | Routine | Description |
| 2017-04-17 | RCHGetYahooHistory
smfPricesByDates | Fix for Yahoo changes of historical data URL protocol from "http://" to "https://" |
I've uploaded a new version of the add-in and a new change log:
http://ogres-crypt.com/SMF/
http://ogres-crypt.com/SMF/Documentation/index.html
#yiv1611955529 #yiv1611955529 -- #yiv1611955529ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1611955529 #yiv1611955529ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1611955529 #yiv1611955529ygrp-mkp #yiv1611955529hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1611955529 #yiv1611955529ygrp-mkp #yiv1611955529ads {margin-bottom:10px;}#yiv1611955529 #yiv1611955529ygrp-mkp .yiv1611955529ad {padding:0 0;}#yiv1611955529 #yiv1611955529ygrp-mkp .yiv1611955529ad p {margin:0;}#yiv1611955529 #yiv1611955529ygrp-mkp .yiv1611955529ad a {color:#0000ff;text-decoration:none;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ygrp-lc {font-family:Arial;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ygrp-lc #yiv1611955529hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ygrp-lc .yiv1611955529ad {margin-bottom:10px;padding:0 0;}#yiv1611955529 #yiv1611955529actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1611955529 #yiv1611955529activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1611955529 #yiv1611955529activity span {font-weight:700;}#yiv1611955529 #yiv1611955529activity span:first-child {text-transform:uppercase;}#yiv1611955529 #yiv1611955529activity span a {color:#5085b6;text-decoration:none;}#yiv1611955529 #yiv1611955529activity span span {color:#ff7900;}#yiv1611955529 #yiv1611955529activity span .yiv1611955529underline {text-decoration:underline;}#yiv1611955529 .yiv1611955529attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1611955529 .yiv1611955529attach div a {text-decoration:none;}#yiv1611955529 .yiv1611955529attach img {border:none;padding-right:5px;}#yiv1611955529 .yiv1611955529attach label {display:block;margin-bottom:5px;}#yiv1611955529 .yiv1611955529attach label a {text-decoration:none;}#yiv1611955529 blockquote {margin:0 0 0 4px;}#yiv1611955529 .yiv1611955529bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1611955529 .yiv1611955529bold a {text-decoration:none;}#yiv1611955529 dd.yiv1611955529last p a {font-family:Verdana;font-weight:700;}#yiv1611955529 dd.yiv1611955529last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1611955529 dd.yiv1611955529last p span.yiv1611955529yshortcuts {margin-right:0;}#yiv1611955529 div.yiv1611955529attach-table div div a {text-decoration:none;}#yiv1611955529 div.yiv1611955529attach-table {width:400px;}#yiv1611955529 div.yiv1611955529file-title a, #yiv1611955529 div.yiv1611955529file-title a:active, #yiv1611955529 div.yiv1611955529file-title a:hover, #yiv1611955529 div.yiv1611955529file-title a:visited {text-decoration:none;}#yiv1611955529 div.yiv1611955529photo-title a, #yiv1611955529 div.yiv1611955529photo-title a:active, #yiv1611955529 div.yiv1611955529photo-title a:hover, #yiv1611955529 div.yiv1611955529photo-title a:visited {text-decoration:none;}#yiv1611955529 div#yiv1611955529ygrp-mlmsg #yiv1611955529ygrp-msg p a span.yiv1611955529yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1611955529 .yiv1611955529green {color:#628c2a;}#yiv1611955529 .yiv1611955529MsoNormal {margin:0 0 0 0;}#yiv1611955529 o {font-size:0;}#yiv1611955529 #yiv1611955529photos div {float:left;width:72px;}#yiv1611955529 #yiv1611955529photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1611955529 #yiv1611955529photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1611955529 #yiv1611955529reco-category {font-size:77%;}#yiv1611955529 #yiv1611955529reco-desc {font-size:77%;}#yiv1611955529 .yiv1611955529replbq {margin:4px;}#yiv1611955529 #yiv1611955529ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1611955529 #yiv1611955529ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1611955529 #yiv1611955529ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1611955529 #yiv1611955529ygrp-mlmsg select, #yiv1611955529 input, #yiv1611955529 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1611955529 #yiv1611955529ygrp-mlmsg pre, #yiv1611955529 code {font:115% monospace;}#yiv1611955529 #yiv1611955529ygrp-mlmsg * {line-height:1.22em;}#yiv1611955529 #yiv1611955529ygrp-mlmsg #yiv1611955529logo {padding-bottom:10px;}#yiv1611955529 #yiv1611955529ygrp-msg p a {font-family:Verdana;}#yiv1611955529 #yiv1611955529ygrp-msg p#yiv1611955529attach-count span {color:#1E66AE;font-weight:700;}#yiv1611955529 #yiv1611955529ygrp-reco #yiv1611955529reco-head {color:#ff7900;font-weight:700;}#yiv1611955529 #yiv1611955529ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ov li a {font-size:130%;text-decoration:none;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1611955529 #yiv1611955529ygrp-sponsor #yiv1611955529ov ul {margin:0;padding:0 0 0 8px;}#yiv1611955529 #yiv1611955529ygrp-text {font-family:Georgia;}#yiv1611955529 #yiv1611955529ygrp-text p {margin:0 0 1em 0;}#yiv1611955529 #yiv1611955529ygrp-text tt {font-size:120%;}#yiv1611955529 #yiv1611955529ygrp-vital ul li:last-child {border-right:none !important;}#yiv1611955529
On Monday, April 17, 2017 1:58 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Wow. Another change from Yahoo already? Good thing I installed Office 365 yesterday...
| Date | Routine | Description |
| 2017-04-17 | RCHGetYahooHistory
smfPricesByDates | Fix for Yahoo changes of historical data URL protocol from "http://" to "https://" |
I've uploaded a new version of the add-in and a new change log:
http://ogres-crypt.com/SMF/
http://ogres-crypt.com/SMF/Documentation/index.html
#yiv1611955529 #yiv1611955529 -- #yiv1611955529ygrp-
Mon Apr 17, 2017 2:06 pm (PDT) . Posted by:
marcnyc11
Thanks Randy! You're awesome. Really appreciate the quick update.
Marc
Marc
Mon Apr 17, 2017 2:58 pm (PDT) . Posted by:
palminha
Dear Randy,
Today the subject formula don´t work, is it temporary or permanent ?
Is there any other similar formula that I can use in my files to replace smfPricesByDates if the stop definitive ?
Thank your for your fantastic job!
Best Regards
Today the subject formula don´t work, is it temporary or permanent ?
Is there any other similar formula that I can use in my files to replace smfPricesByDates if the stop definitive ?
Thank your for your fantastic job!
Best Regards
Mon Apr 17, 2017 3:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Already been fixed. You just need the new version of the add-in that was
announced this morning after I uploaded it.
On Mon, Apr 17, 2017 at 2:58 PM, palminha@
...wrote:
> Today the subject formula don´t work, is it temporary or permanent ?
>
> Is there any other similar formula that I can use in my files to replace
> smfPricesByDates if the stop definitive ?
>
>
>
announced this morning after I uploaded it.
On Mon, Apr 17, 2017 at 2:58 PM, palminha@
...wrote:
> Today the subject formula don´t work, is it temporary or permanent ?
>
> Is there any other similar formula that I can use in my files to replace
> smfPricesByDates if the stop definitive ?
>
>
>
Mon Apr 17, 2017 3:19 pm (PDT) . Posted by:
palminha
Dear Randy,
Something is not working for me :(( I have updated your uploaded file and still gives me #N/A
I´m using excel 2000 can you give me some advise?
Thank you so much for your support!
Kind Regards
Something is not working for me :(( I have updated your uploaded file and still gives me #N/A
I´m using excel 2000 can you give me some advise?
Thank you so much for your support!
Kind Regards
Mon Apr 17, 2017 3:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried this here, and it's working OK for me:
=smfPricesByDates("SPY","3/31/17","4/5/17","4/12/17","4/17/17")
Check to see which version of the add-in EXCEL is using:
=RCHGetElementNumber("Version")
On Mon, Apr 17, 2017 at 3:19 PM, palminha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Something is not working for me :(( I have updated your uploaded file and
> still gives me #N/A
>
> I´m using excel 2000 can you give me some advise?
>
>
=smfPricesByDates("SPY","3/31/17","4/5/17","4/12/17","4/17/17")
Check to see which version of the add-in EXCEL is using:
=RCHGetElementNumber("Version")
On Mon, Apr 17, 2017 at 3:19 PM, palminha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Something is not working for me :(( I have updated your uploaded file and
> still gives me #N/A
>
> I´m using excel 2000 can you give me some advise?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar