8 Messages
Digest #4468
Messages
Wed Jan 23, 2019 6:35 am (PST) . Posted by:
alankc_mok
Randy,
I used to get historic quote from Investing.com using the below macro
=RCHGetTableCell("https://www.investing.com/equities/tencent-holdings-hk-historical-data",1,">Jan 22, 2019")
But lately, it is not working. Please help.
Also, can I get historical quote from Yahoo using smfGetYaooPortfolioview ?
Regards
Alan
I used to get historic quote from Investing.com using the below macro
=RCHGetTableCell("https://www.investing.com/equities/tencent-holdings-hk-historical-data",1,"
But lately, it is not working. Please help.
Also, can I get historical quote from Yahoo using smfGetYaooPortfolio
Regards
Alan
Wed Jan 23, 2019 7:39 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That function worked fine for me when I tried it.
smfGetYahooPortfolioView() can get the previous day's closing price, but no
other historical quotes.
On Wed, Jan 23, 2019 at 8:13 AM alankc_mok@... wrote:
>
> I used to get historic quote from Investing.com using the below macro
>
> =RCHGetTableCell("
> https://www.investing.com/equities/tencent-holdings-hk-historical-data",1,">Jan
> 22, 2019")
>
> But lately, it is not working. Please help.
>
> Also, can I get historical quote from Yahoo using smfGetYaooPortfolioview ?
>
>
>
smfGetYahooPortfolioView() can get the previous day's closing price, but no
other historical quotes.
On Wed, Jan 23, 2019 at 8:13 AM alankc_mok@... wrote:
>
> I used to get historic quote from Investing.com using the below macro
>
> =RCHGetTableCell("
> https://www.investing.com/equities/tencent-holdings-hk-historical-data",1,"
> 22, 2019")
>
> But lately, it is not working. Please help.
>
> Also, can I get historical quote from Yahoo using smfGetYaooPortfolio
>
>
>
Thu Jan 24, 2019 3:47 am (PST) . Posted by:
alankc_mok
Randy,
I have a list of ten stock using the format of the above macro. However, some of the Stock can have quote and some didn't. I also try to reinstall the add-in. But still having intermittent problem. Is there any thing I can do to ?
Regards
Alan
I have a list of ten stock using the format of the above macro. However, some of the Stock can have quote and some didn't. I also try to reinstall the add-in. But still having intermittent problem. Is there any thing I can do to ?
Regards
Alan
Wed Jan 23, 2019 7:01 am (PST) . Posted by:
JCHyjun
Hello,
I don't want to re-invent bicycle and hope somebody has answer how to use "Factor of dividend adjustments" in smfGetYahooHistory() already.
How can I calculate real dividends paid?
Thank you
JCH
I don't want to re-invent bicycle and hope somebody has answer how to use "Factor of dividend adjustments" in smfGetYahooHistory(
How can I calculate real dividends paid?
Thank you
JCH
Wed Jan 23, 2019 7:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what you're asking?
If you want the dividend history, just use the "v" value for the "period"
parameter.
On Wed, Jan 23, 2019 at 8:37 AM jchyjun@... wrote:
>
> I don't want to re-invent bicycle and hope somebody has answer how to use
> "Factor of dividend adjustments" in smfGetYahooHistory() already.
> How can I calculate real dividends paid?
>
>
If you want the dividend history, just use the "v" value for the "period"
parameter.
On Wed, Jan 23, 2019 at 8:37 AM jchyjun@... wrote:
>
> I don't want to re-invent bicycle and hope somebody has answer how to use
> "Factor of dividend adjustments" in smfGetYahooHistory(
> How can I calculate real dividends paid?
>
>
Wed Jan 23, 2019 12:26 pm (PST) . Posted by:
JCHyjun
I'd like to estimate min and max yields for past years, so need to know annual dividends, and prices .
When I use "v" parameter I get dividends ONLY.
Dividends (esp. old) are strange when I use "a" parameter., e.g. for MMM I got the following (see below) numbers that do not match with dividend history after splits (see below).
It seems that Yahoo dividends should be recalculated. HOW?
Thank you
JCH
Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split 1/1/19 187.82 196.4 182.89 192.26 34499100 192.26 1 1 5.44 1/1/18 229.788 253.1683 226.8935 244.0266 49012500 250.5 0.974586 1 4.7 1/1/17 170.3736 171.4882 165.5909 166.3946 37973900 174.82 0.952712 1 4.44 1/1/16 137.3722 140.1094 124.9294 139.9726 63774600 151 0.927877 1 4.1 1/1/15 148.8538 150.5348 142.5548 146.5878 54720500 162.3 0.903733 1 3.42 1/1/14 121.8392 122.9336 111.5749 113.0386 60369400 128.19 0.882573 1 2.54 1/1/13 81.29841 87.99631 81.09988 86.71419 62614800 100.55 0.863132 1 2.36 1/1/12 70.39313 73.94808 69.50229 72.81657 70287500 86.71 0.840415 1 2.2 1/1/11 71.08559 74.15846 70.16783 71.96413 70774300 87.92 0.81943 1 2.1 1/1/10 66.3264 67.98676 63.14938 64.23483 75208100 80.49 0.798248 1 2.04 1/1/09 44.40525 46.14906 40.3621 41.52246 103623600 53.79 0.771594 1 2 1/1/08 63.2441 63.63449 54.09232 59.79524 110132700 79.65 0.750761 1 1.92 1/1/07 56.88054 58.60464 53.6231 54.49929 69810800 74.3 0.733658 1 1.84 1/1/06 55.7029 57.18573 51.5481 52.10931 62966600 72.75 0.716344 1 1.68 1/1/05 57.59283 59.92682 56.58354 59.12992 73968800 84.36 0.700899 1 1.44 1/1/04 58.52498 59.35121 53.98758 54.45634 75033700 79.09 0.688529 1 2.31 1 for 2 1/1/03 41.01217 42.94772 40.92238 41.42123 90253400 62.275 0.665134 2 2.48 1/1/02 37.39145 37.69818 31.95032 35.46211 128540800 55.5 0.639006 2 2.4 1/1/01 36.15305 37.18599 31.84912 33.88482 98942800 55.325 0.612115 2 2.32 1/1/00 27.93622 30.19002 26.24587 27.26279 68507000 46.8125 0.581626 2 2.24 1/1/99 19.97914 21.82523 19.1855 21.49705 54950000 38.8125 0.552101 2 2.2 1/1/98 21.47649 22.45641 20.92121 21.94837 52355400 41.75 0.522622 2 2.12 1/1/97 20.745 21.55609 19.96512 21.38223 48916000 42.625 0.499128 2 3.12 1/1/96 15.07802 15.61856 14.11075 14.75058 36448600 32.25 0.455186 2 1.88 1/1/95 11.43717 11.51715 11.01061 11.22662 24769200 26.1875 0.426561 2 2.2 1 for 2 1/1/94 10.62982 11.04619 10.28692 10.56912 33850000 26.8125 0.391883 4 3.32 1/1/93 8.723673 8.74532 8.420618 8.522064 34188000 24.5 0.346349 4 3.2 1/1/92 7.169983 7.472674 6.876752 6.923405 33422400 22.75 0.302691 4 3.12 1/1/91 5.635899 5.668713 5.135477 5.592937 56512400 21.21875 0.262516 4 2.92 1/1/90 4.494971 4.756883 4.254295 4.449221 45083600 19.53125 0.226518 4 2.6 1/1/89 3.006656 3.404686 2.945421 3.382215 49309600 17.125 0.195953 4 2.12 1/1/88 2.749284 2.866049 2.356529 2.582783 49068800 15.125 0.16984 4 2.7912 1 for 2 1/1/87 2.089394 2.487692 2.089394 2.320841 81320800 16.17188 0.142408 8 3.6 1/1/86 1.209548 1.236502 1.15901 1.223987 52897600 11.35938 0.107815 8 0.43752 1/1/85 1.018441 1.092568 1.000715 1.087335 49360800 10.54688 0.103133 8 0.425 1/1/84 1.014658 1.050125 0.91751 0.956388 39596800 9.6875 0.09869 8 0.41252 1/1/83 0.875224 0.959637 0.860415 0.891639 27351200 9.40625 0.094779 8 0.4 1/1/82 0.611541 0.63258 0.582086 0.629466 22575200 7.015625 0.089767 8 0.375 1/1/81 0.627186 0.672365 0.603268 0.616848 26119200 7.265625 0.085042 8 0.35 1/1/80 0.507678 0.510204 0.471055 0.499806 28832800 6.1875 0.080824 8 0.3 1/1/79 0.609964 0.637744 0.599093 0.599343 21142400 7.75 0.077302 8 0.25 1/1/78 0.448082 0.448082 0.427133 0.437073 10723200 5.859375 0.074486 8 0.21252 1/1/77 0.502711 0.512833 0.449853 0.455143 15780800 6.3125 0.071977 8 0.181 1/1/76 0.485821 0.551621 0.478145 0.550743 12397600 7.828125 0.070186 8 0.16876 1/1/75 0.392224 0.405083 0.368647 0.394964 13701600 5.75 0.068586 8 0.15652 1/1/74 0.655656 0.676671 0.60312 0.639772 6688000 9.5 0.067247 8 0.13126 1/1/73 0.710564 0.737534 0.696041 0.700266 4038400 10.53125 0.066388 8 0.12038 1 for 2 1/1/72 0.553233 0.555282 0.529669 0.550987 3523200 8.390625 0.065568 16 0.11576 1/1/71 0.396148 0.399172 0.383548 0.399665 7020800 6.1875 0.064513 16 0.08201 1/1/70 0.435406 0.455761 0.395688 0.398955 5204800 6.273438 0.063548 16
When I use "v" parameter I get dividends ONLY.
Dividends (esp. old) are strange when I use "a" parameter., e.g. for MMM I got the following (see below) numbers that do not match with dividend history after splits (see below).
It seems that Yahoo dividends should be recalculated. HOW?
Thank you
JCH
Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split 1/1/19 187.82 196.4 182.89 192.26 34499100 192.26 1 1 5.44 1/1/18 229.788 253.1683 226.8935 244.0266 49012500 250.5 0.974586 1 4.7 1/1/17 170.3736 171.4882 165.5909 166.3946 37973900 174.82 0.952712 1 4.44 1/1/16 137.3722 140.1094 124.9294 139.9726 63774600 151 0.927877 1 4.1 1/1/15 148.8538 150.5348 142.5548 146.5878 54720500 162.3 0.903733 1 3.42 1/1/14 121.8392 122.9336 111.5749 113.0386 60369400 128.19 0.882573 1 2.54 1/1/13 81.29841 87.99631 81.09988 86.71419 62614800 100.55 0.863132 1 2.36 1/1/12 70.39313 73.94808 69.50229 72.81657 70287500 86.71 0.840415 1 2.2 1/1/11 71.08559 74.15846 70.16783 71.96413 70774300 87.92 0.81943 1 2.1 1/1/10 66.3264 67.98676 63.14938 64.23483 75208100 80.49 0.798248 1 2.04 1/1/09 44.40525 46.14906 40.3621 41.52246 103623600 53.79 0.771594 1 2 1/1/08 63.2441 63.63449 54.09232 59.79524 110132700 79.65 0.750761 1 1.92 1/1/07 56.88054 58.60464 53.6231 54.49929 69810800 74.3 0.733658 1 1.84 1/1/06 55.7029 57.18573 51.5481 52.10931 62966600 72.75 0.716344 1 1.68 1/1/05 57.59283 59.92682 56.58354 59.12992 73968800 84.36 0.700899 1 1.44 1/1/04 58.52498 59.35121 53.98758 54.45634 75033700 79.09 0.688529 1 2.31 1 for 2 1/1/03 41.01217 42.94772 40.92238 41.42123 90253400 62.275 0.665134 2 2.48 1/1/02 37.39145 37.69818 31.95032 35.46211 128540800 55.5 0.639006 2 2.4 1/1/01 36.15305 37.18599 31.84912 33.88482 98942800 55.325 0.612115 2 2.32 1/1/00 27.93622 30.19002 26.24587 27.26279 68507000 46.8125 0.581626 2 2.24 1/1/99 19.97914 21.82523 19.1855 21.49705 54950000 38.8125 0.552101 2 2.2 1/1/98 21.47649 22.45641 20.92121 21.94837 52355400 41.75 0.522622 2 2.12 1/1/97 20.745 21.55609 19.96512 21.38223 48916000 42.625 0.499128 2 3.12 1/1/96 15.07802 15.61856 14.11075 14.75058 36448600 32.25 0.455186 2 1.88 1/1/95 11.43717 11.51715 11.01061 11.22662 24769200 26.1875 0.426561 2 2.2 1 for 2 1/1/94 10.62982 11.04619 10.28692 10.56912 33850000 26.8125 0.391883 4 3.32 1/1/93 8.723673 8.74532 8.420618 8.522064 34188000 24.5 0.346349 4 3.2 1/1/92 7.169983 7.472674 6.876752 6.923405 33422400 22.75 0.302691 4 3.12 1/1/91 5.635899 5.668713 5.135477 5.592937 56512400 21.21875 0.262516 4 2.92 1/1/90 4.494971 4.756883 4.254295 4.449221 45083600 19.53125 0.226518 4 2.6 1/1/89 3.006656 3.404686 2.945421 3.382215 49309600 17.125 0.195953 4 2.12 1/1/88 2.749284 2.866049 2.356529 2.582783 49068800 15.125 0.16984 4 2.7912 1 for 2 1/1/87 2.089394 2.487692 2.089394 2.320841 81320800 16.17188 0.142408 8 3.6 1/1/86 1.209548 1.236502 1.15901 1.223987 52897600 11.35938 0.107815 8 0.43752 1/1/85 1.018441 1.092568 1.000715 1.087335 49360800 10.54688 0.103133 8 0.425 1/1/84 1.014658 1.050125 0.91751 0.956388 39596800 9.6875 0.09869 8 0.41252 1/1/83 0.875224 0.959637 0.860415 0.891639 27351200 9.40625 0.094779 8 0.4 1/1/82 0.611541 0.63258 0.582086 0.629466 22575200 7.015625 0.089767 8 0.375 1/1/81 0.627186 0.672365 0.603268 0.616848 26119200 7.265625 0.085042 8 0.35 1/1/80 0.507678 0.510204 0.471055 0.499806 28832800 6.1875 0.080824 8 0.3 1/1/79 0.609964 0.637744 0.599093 0.599343 21142400 7.75 0.077302 8 0.25 1/1/78 0.448082 0.448082 0.427133 0.437073 10723200 5.859375 0.074486 8 0.21252 1/1/77 0.502711 0.512833 0.449853 0.455143 15780800 6.3125 0.071977 8 0.181 1/1/76 0.485821 0.551621 0.478145 0.550743 12397600 7.828125 0.070186 8 0.16876 1/1/75 0.392224 0.405083 0.368647 0.394964 13701600 5.75 0.068586 8 0.15652 1/1/74 0.655656 0.676671 0.60312 0.639772 6688000 9.5 0.067247 8 0.13126 1/1/73 0.710564 0.737534 0.696041 0.700266 4038400 10.53125 0.066388 8 0.12038 1 for 2 1/1/72 0.553233 0.555282 0.529669 0.550987 3523200 8.390625 0.065568 16 0.11576 1/1/71 0.396148 0.399172 0.383548 0.399665 7020800 6.1875 0.064513 16 0.08201 1/1/70 0.435406 0.455761 0.395688 0.398955 5204800 6.273438 0.063548 16
Wed Jan 23, 2019 4:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The stream of numbers you sent would only mean anything after spending a
lot of time reorganizing it. As I recall, dividend adjustments from Yahoo
are not correct for anything other than daily data.
The best way to do what you're attempting would be to retrieve daily data
in one array and dividend data in another array and then do vlookup() or
sumproduct() functions to extract and consolidate what you need as you need
it. At issue would also be whether you are interested in yields based on
trailing 12 months or expected for the next 12 months.
On Wed, Jan 23, 2019 at 1:26 PM jchyjun@... wrote:
>
> I'd like to estimate min and max yields for past years, so need to know
> annual dividends, and prices .
> When I use "v" parameter I get dividends ONLY.
> Dividends (esp. old) are strange when I use "a" parameter., e.g. for MMM
> I got the following (see below) numbers that do not match with dividend
> history after splits (see below).
>
> It seems that Yahoo dividends should be recalculated. HOW?
>
>
>
lot of time reorganizing it. As I recall, dividend adjustments from Yahoo
are not correct for anything other than daily data.
The best way to do what you're attempting would be to retrieve daily data
in one array and dividend data in another array and then do vlookup() or
sumproduct() functions to extract and consolidate what you need as you need
it. At issue would also be whether you are interested in yields based on
trailing 12 months or expected for the next 12 months.
On Wed, Jan 23, 2019 at 1:26 PM jchyjun@... wrote:
>
> I'd like to estimate min and max yields for past years, so need to know
> annual dividends, and prices .
> When I use "v" parameter I get dividends ONLY.
> Dividends (esp. old) are strange when I use "a" parameter., e.g. for MMM
> I got the following (see below) numbers that do not match with dividend
> history after splits (see below).
>
> It seems that Yahoo dividends should be recalculated. HOW?
>
>
>
Wed Jan 23, 2019 5:01 pm (PST) . Posted by:
JCHyjun
Thank you, Randy!
I hoped that some SMF users figured out how to solve problem using just one array.
JCH
I hoped that some SMF users figured out how to solve problem using just one array.
JCH
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar