6 Messages
Digest #4590
Messages
Tue Jul 30, 2019 9:23 am (PDT) . Posted by:
seongkook_berry
I'm using the GetYahooHistory function to get historical monthly high and low stock prices. I've noticed that the function appears to return adjusted high and low prices when a dividend is issued in the same month. However, I want the unadjusted high and low prices. For example, ENBL monthly high price in February 2019 was $16.49 but the function returns $16.14. Basically, I want the same information from yahoo finance's historical data page (https://finance.yahoo.com/quote/ENBL/history?period1=1546318800&period2=1564459200&interval=1mo&filter=history&frequency=1mo https://finance.yahoo.com/quote/ENBL/history?period1=1546318800&period2=1564459200&interval=1mo&filter=history&frequency=1mo)
Is there a way to get the unadjusted monthly high and low prices?
Is there a way to get the unadjusted monthly high and low prices?
Tue Jul 30, 2019 6:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The smfGetYahooHistory() function allows you to ask for unadjusted prices.
But unadjusted prices are meaningless in comparison to each other...?
For example, if the high price for the month is three times the low price,
there could either have been a huge collapse in the stock, a huge run-up in
the stock, a 3-for-1 stock split, or a 1-for-3 stock split.
On Tue, Jul 30, 2019 at 9:23 AM seongkook_berry@... wrote:
> I'm using the GetYahooHistory function to get historical monthly high and
> low stock prices. I've noticed that the function appears to return adjusted
> high and low prices when a dividend is issued in the same month. However, I
> want the unadjusted high and low prices. For example, ENBL monthly high
> price in February 2019 was $16.49 but the function returns $16.14.
> Basically, I want the same information from yahoo finance's historical data
> page (
> https://finance.yahoo.com/quote/ENBL/history?period1=1546318800&period2=1564459200&interval=1mo&filter=history&frequency=1mo
> )
>
> Is there a way to get the unadjusted monthly high and low prices?
>
>
>
But unadjusted prices are meaningless in comparison to each other...?
For example, if the high price for the month is three times the low price,
there could either have been a huge collapse in the stock, a huge run-up in
the stock, a 3-for-1 stock split, or a 1-for-3 stock split.
On Tue, Jul 30, 2019 at 9:23 AM seongkook_berry@... wrote:
> I'm using the GetYahooHistory function to get historical monthly high and
> low stock prices. I've noticed that the function appears to return adjusted
> high and low prices when a dividend is issued in the same month. However, I
> want the unadjusted high and low prices. For example, ENBL monthly high
> price in February 2019 was $16.49 but the function returns $16.14.
> Basically, I want the same information from yahoo finance's historical data
> page (
> https://finance.yahoo.com/quote/ENBL/history?period1=1546318800&period2=1564459200&interval=1mo&filter=history&frequency=1mo
> )
>
> Is there a way to get the unadjusted monthly high and low prices?
>
>
>
Tue Jul 30, 2019 2:11 pm (PDT) . Posted by:
"Sundeep Chadha" sundeep_chadha
Randy - Tried that - even tried to unlink the xla and re-download and re-link the xla in excel...still the same result. The Company name does not work - Here is the screenshot of the result
Thanks and regards, Sundeep Chadha
On Monday, July 29, 2019, 08:58:26 PM CDT, Randy Harmelink rharmelink@gmail..com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Grab the latest smf-elements-2.txt file from the website.
Be sure to exit EXCEL when you update the file in the add-in folder.
On Mon, Jul 29, 2019 at 4:24 PM Sundeep Chadha sundeep_chadha@... wrote:
=RCHGetElementNumber(Ticker,13863) does not seem to return company name
However - these work just fine. =RCHGetElementNumber(Ticker,13865) <- returns sector name
=RCHGetElementNumber(Ticker,13867) <- Returns industry name
Any idea on why 13863 is not working?
#yiv6975631919 #yiv6975631919 -- #yiv6975631919ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6975631919 #yiv6975631919ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6975631919 #yiv6975631919ygrp-mkp #yiv6975631919hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6975631919 #yiv6975631919ygrp-mkp #yiv6975631919ads {margin-bottom:10px;}#yiv6975631919 #yiv6975631919ygrp-mkp .yiv6975631919ad {padding:0 0;}#yiv6975631919 #yiv6975631919ygrp-mkp .yiv6975631919ad p {margin:0;}#yiv6975631919 #yiv6975631919ygrp-mkp .yiv6975631919ad a {color:#0000ff;text-decoration:none;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ygrp-lc {font-family:Arial;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ygrp-lc #yiv6975631919hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ygrp-lc .yiv6975631919ad {margin-bottom:10px;padding:0 0;}#yiv6975631919 #yiv6975631919actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6975631919 #yiv6975631919activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6975631919 #yiv6975631919activity span {font-weight:700;}#yiv6975631919 #yiv6975631919activity span:first-child {text-transform:uppercase;}#yiv6975631919 #yiv6975631919activity span a {color:#5085b6;text-decoration:none;}#yiv6975631919 #yiv6975631919activity span span {color:#ff7900;}#yiv6975631919 #yiv6975631919activity span .yiv6975631919underline {text-decoration:underline;}#yiv6975631919 .yiv6975631919attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6975631919 .yiv6975631919attach div a {text-decoration:none;}#yiv6975631919 .yiv6975631919attach img {border:none;padding-right:5px;}#yiv6975631919 .yiv6975631919attach label {display:block;margin-bottom:5px;}#yiv6975631919 .yiv6975631919attach label a {text-decoration:none;}#yiv6975631919 blockquote {margin:0 0 0 4px;}#yiv6975631919 .yiv6975631919bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6975631919 .yiv6975631919bold a {text-decoration:none;}#yiv6975631919 dd.yiv6975631919last p a {font-family:Verdana;font-weight:700;}#yiv6975631919 dd.yiv6975631919last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6975631919 dd.yiv6975631919last p span.yiv6975631919yshortcuts {margin-right:0;}#yiv6975631919 div.yiv6975631919attach-table div div a {text-decoration:none;}#yiv6975631919 div.yiv6975631919attach-table {width:400px;}#yiv6975631919 div.yiv6975631919file-title a, #yiv6975631919 div.yiv6975631919file-title a:active, #yiv6975631919 div.yiv6975631919file-title a:hover, #yiv6975631919 div.yiv6975631919file-title a:visited {text-decoration:none;}#yiv6975631919 div.yiv6975631919photo-title a, #yiv6975631919 div.yiv6975631919photo-title a:active, #yiv6975631919 div.yiv6975631919photo-title a:hover, #yiv6975631919 div.yiv6975631919photo-title a:visited {text-decoration:none;}#yiv6975631919 div#yiv6975631919ygrp-mlmsg #yiv6975631919ygrp-msg p a span.yiv6975631919yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6975631919 .yiv6975631919green {color:#628c2a;}#yiv6975631919 .yiv6975631919MsoNormal {margin:0 0 0 0;}#yiv6975631919 o {font-size:0;}#yiv6975631919 #yiv6975631919photos div {float:left;width:72px;}#yiv6975631919 #yiv6975631919photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6975631919 #yiv6975631919photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6975631919 #yiv6975631919reco-category {font-size:77%;}#yiv6975631919 #yiv6975631919reco-desc {font-size:77%;}#yiv6975631919 .yiv6975631919replbq {margin:4px;}#yiv6975631919 #yiv6975631919ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6975631919 #yiv6975631919ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6975631919 #yiv6975631919ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6975631919 #yiv6975631919ygrp-mlmsg select, #yiv6975631919 input, #yiv6975631919 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6975631919 #yiv6975631919ygrp-mlmsg pre, #yiv6975631919 code {font:115% monospace;}#yiv6975631919 #yiv6975631919ygrp-mlmsg * {line-height:1.22em;}#yiv6975631919 #yiv6975631919ygrp-mlmsg #yiv6975631919logo {padding-bottom:10px;}#yiv6975631919 #yiv6975631919ygrp-msg p a {font-family:Verdana;}#yiv6975631919 #yiv6975631919ygrp-msg p#yiv6975631919attach-count span {color:#1E66AE;font-weight:700;}#yiv6975631919 #yiv6975631919ygrp-reco #yiv6975631919reco-head {color:#ff7900;font-weight:700;}#yiv6975631919 #yiv6975631919ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ov li a {font-size:130%;text-decoration:none;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6975631919 #yiv6975631919ygrp-sponsor #yiv6975631919ov ul {margin:0;padding:0 0 0 8px;}#yiv6975631919 #yiv6975631919ygrp-text {font-family:Georgia;}#yiv6975631919 #yiv6975631919ygrp-text p {margin:0 0 1em 0;}#yiv6975631919 #yiv6975631919ygrp-text tt {font-size:120%;}#yiv6975631919 #yiv6975631919ygrp-vital ul li:last-child {border-right:none !important;}#yiv6975631919
Thanks and regards, Sundeep Chadha
On Monday, July 29, 2019, 08:58:26 PM CDT, Randy Harmelink rharmelink@gmail..com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Grab the latest smf-elements-
Be sure to exit EXCEL when you update the file in the add-in folder.
On Mon, Jul 29, 2019 at 4:24 PM Sundeep Chadha sundeep_chadha@
=RCHGetElementNumbe
However - these work just fine. =RCHGetElement
=RCHGetElementNumbe
Any idea on why 13863 is not working?
#yiv6975631919 #yiv6975631919 -- #yiv6975631919ygrp-
Tue Jul 30, 2019 4:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What do you get with:
=RCHGetElementNumber("Definition",13863)
It should be:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
https://finance.yahoo.com/quote/~~~~~","title"),"~"," (~~~~~")
That's the definition I see on the smf-elements-2.txt file from the website.
On Tue, Jul 30, 2019 at 2:13 PM Sundeep Chadha sundeep_chadha@... wrote:
>
> Tried that - even tried to unlink the xla and re-download and re-link the
> xla in excel...still the same result.
> The Company name does not work - Here is the screenshot of the result
>
> [image: Inline image]
>
>
>
>
=RCHGetElementNumber("Definition",13863)
It should be:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
https://finance.yahoo.com/quote/~~~~~","
That's the definition I see on the smf-elements-
On Tue, Jul 30, 2019 at 2:13 PM Sundeep Chadha sundeep_chadha@
>
> Tried that - even tried to unlink the xla and re-download and re-link the
> xla in excel...still the same result.
> The Company name does not work - Here is the screenshot of the result
>
> [image: Inline image]
>
>
>
>
Tue Jul 30, 2019 7:38 pm (PDT) . Posted by:
"Sundeep Chadha" sundeep_chadha
That is NOT what I see in the smf-elements-2 file for 13863 - I just downloaded the file again from http://ogres-crypt.com/SMF/
Here is what I see in the file
Thanks and regards, Sundeep Chadha
On Tuesday, July 30, 2019, 06:22:43 PM CDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
What do you get with:
=RCHGetElementNumber("Definition",13863)
It should be:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("https://finance.yahoo.com/quote/~~~~~","title"),"~"," (~~~~~")
That's the definition I see on the smf-elements-2.txt file from the website.
On Tue, Jul 30, 2019 at 2:13 PM Sundeep Chadha sundeep_chadha@... wrote:
Tried that - even tried to unlink the xla and re-download and re-link the xla in excel...still the same result.
The Company name does not work - Here is the screenshot of the result
#yiv8819454912 #yiv8819454912 -- #yiv8819454912ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8819454912 #yiv8819454912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8819454912 #yiv8819454912ygrp-mkp #yiv8819454912hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8819454912 #yiv8819454912ygrp-mkp #yiv8819454912ads {margin-bottom:10px;}#yiv8819454912 #yiv8819454912ygrp-mkp .yiv8819454912ad {padding:0 0;}#yiv8819454912 #yiv8819454912ygrp-mkp .yiv8819454912ad p {margin:0;}#yiv8819454912 #yiv8819454912ygrp-mkp .yiv8819454912ad a {color:#0000ff;text-decoration:none;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ygrp-lc {font-family:Arial;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ygrp-lc #yiv8819454912hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ygrp-lc .yiv8819454912ad {margin-bottom:10px;padding:0 0;}#yiv8819454912 #yiv8819454912actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8819454912 #yiv8819454912activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8819454912 #yiv8819454912activity span {font-weight:700;}#yiv8819454912 #yiv8819454912activity span:first-child {text-transform:uppercase;}#yiv8819454912 #yiv8819454912activity span a {color:#5085b6;text-decoration:none;}#yiv8819454912 #yiv8819454912activity span span {color:#ff7900;}#yiv8819454912 #yiv8819454912activity span .yiv8819454912underline {text-decoration:underline;}#yiv8819454912 .yiv8819454912attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8819454912 .yiv8819454912attach div a {text-decoration:none;}#yiv8819454912 .yiv8819454912attach img {border:none;padding-right:5px;}#yiv8819454912 .yiv8819454912attach label {display:block;margin-bottom:5px;}#yiv8819454912 .yiv8819454912attach label a {text-decoration:none;}#yiv8819454912 blockquote {margin:0 0 0 4px;}#yiv8819454912 .yiv8819454912bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8819454912 .yiv8819454912bold a {text-decoration:none;}#yiv8819454912 dd.yiv8819454912last p a {font-family:Verdana;font-weight:700;}#yiv8819454912 dd.yiv8819454912last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8819454912 dd.yiv8819454912last p span.yiv8819454912yshortcuts {margin-right:0;}#yiv8819454912 div.yiv8819454912attach-table div div a {text-decoration:none;}#yiv8819454912 div.yiv8819454912attach-table {width:400px;}#yiv8819454912 div.yiv8819454912file-title a, #yiv8819454912 div.yiv8819454912file-title a:active, #yiv8819454912 div.yiv8819454912file-title a:hover, #yiv8819454912 div.yiv8819454912file-title a:visited {text-decoration:none;}#yiv8819454912 div.yiv8819454912photo-title a, #yiv8819454912 div.yiv8819454912photo-title a:active, #yiv8819454912 div.yiv8819454912photo-title a:hover, #yiv8819454912 div.yiv8819454912photo-title a:visited {text-decoration:none;}#yiv8819454912 div#yiv8819454912ygrp-mlmsg #yiv8819454912ygrp-msg p a span.yiv8819454912yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8819454912 .yiv8819454912green {color:#628c2a;}#yiv8819454912 .yiv8819454912MsoNormal {margin:0 0 0 0;}#yiv8819454912 o {font-size:0;}#yiv8819454912 #yiv8819454912photos div {float:left;width:72px;}#yiv8819454912 #yiv8819454912photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8819454912 #yiv8819454912photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8819454912 #yiv8819454912reco-category {font-size:77%;}#yiv8819454912 #yiv8819454912reco-desc {font-size:77%;}#yiv8819454912 .yiv8819454912replbq {margin:4px;}#yiv8819454912 #yiv8819454912ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8819454912 #yiv8819454912ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8819454912 #yiv8819454912ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8819454912 #yiv8819454912ygrp-mlmsg select, #yiv8819454912 input, #yiv8819454912 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8819454912 #yiv8819454912ygrp-mlmsg pre, #yiv8819454912 code {font:115% monospace;}#yiv8819454912 #yiv8819454912ygrp-mlmsg * {line-height:1.22em;}#yiv8819454912 #yiv8819454912ygrp-mlmsg #yiv8819454912logo {padding-bottom:10px;}#yiv8819454912 #yiv8819454912ygrp-msg p a {font-family:Verdana;}#yiv8819454912 #yiv8819454912ygrp-msg p#yiv8819454912attach-count span {color:#1E66AE;font-weight:700;}#yiv8819454912 #yiv8819454912ygrp-reco #yiv8819454912reco-head {color:#ff7900;font-weight:700;}#yiv8819454912 #yiv8819454912ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ov li a {font-size:130%;text-decoration:none;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8819454912 #yiv8819454912ygrp-sponsor #yiv8819454912ov ul {margin:0;padding:0 0 0 8px;}#yiv8819454912 #yiv8819454912ygrp-text {font-family:Georgia;}#yiv8819454912 #yiv8819454912ygrp-text p {margin:0 0 1em 0;}#yiv8819454912 #yiv8819454912ygrp-text tt {font-size:120%;}#yiv8819454912 #yiv8819454912ygrp-vital ul li:last-child {border-right:none !important;}#yiv8819454912
Here is what I see in the file
Thanks and regards, Sundeep Chadha
On Tuesday, July 30, 2019, 06:22:43 PM CDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
What do you get with:
=RCHGetElementNumber("Definition",13863)
It should be:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("https://finance.yahoo.com/quote/~~~~~","
That's the definition I see on the smf-elements-
On Tue, Jul 30, 2019 at 2:13 PM Sundeep Chadha sundeep_chadha@
Tried that - even tried to unlink the xla and re-download and re-link the xla in excel...still the same result.
The Company name does not work - Here is the screenshot of the result
#yiv8819454912 #yiv8819454912 -- #yiv8819454912ygrp-
Tue Jul 30, 2019 11:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I open it directly from the website, I see:
13863;Yahoo;Company
Name;=smfStrExtr(smfGetTagContent("https://finance.yahoo.com/quote/~~~~~","title"),"~","
(~~~~~")
Are you perhaps being given a cached copy of the file, from an old access
of it?
On Tue, Jul 30, 2019 at 7:39 PM Sundeep Chadha sundeep_chadha@... wrote:
>
> That is NOT what I see in the smf-elements-2 file for 13863 - I just
> downloaded the file again from http://ogres-crypt.com/SMF/
>
> Here is what I see in the file
>
> [image: Inline image]
>
>
>
13863;Yahoo;Company
Name;=smfStrExtr(smfGetTagContent("https://finance.yahoo.com/quote/~~~~~","title"),"~","
(~~~~~")
Are you perhaps being given a cached copy of the file, from an old access
of it?
On Tue, Jul 30, 2019 at 7:39 PM Sundeep Chadha sundeep_chadha@... wrote:
>
> That is NOT what I see in the smf-elements-2 file for 13863 - I just
> downloaded the file again from http://ogres-crypt.com/SMF/
>
> Here is what I see in the file
>
> [image: Inline image]
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar