7 Messages
Digest #4114
Messages
Mon Aug 7, 2017 2:20 pm (PDT) . Posted by:
thefish8467
Hi All,
Need help - I posted my test file here https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download (SMF-DOW Jones 30 Stocks.xlsx). I can not seem to use normal functions in excel (SUM, IF etc.) after pulling in data using RCHGetYahooQuotes - any ideas?
Thanks for the help,
David
Need help - I posted my test file here https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download (SMF-DOW Jones 30 Stocks.xlsx)
Thanks for the help,
David
Mon Aug 7, 2017 2:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ahhh...found your workbook in the "Uploads by forum members" folder...
It appears to work fine. Was something in it giving you your EXCEL function
problems? The VLOOKUP() and VALUE() functions in the one worksheet were
working fine...
On Mon, Aug 7, 2017 at 2:16 PM, dvisser01@
...
wrote:
>
> Hi All,
>
> Need help - I posted my test file here
> <https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download>
> (SMF-DOW Jones 30 Stocks.xlsx). I can not seem to use normal functions in
> excel (SUM, IF etc.) after pulling in data using RCHGetYahooQuotes - any
> ideas?
>
>
>
It appears to work fine. Was something in it giving you your EXCEL function
problems? The VLOOKUP() and VALUE() functions in the one worksheet were
working fine...
On Mon, Aug 7, 2017 at 2:16 PM, dvisser01@
...
wrote:
>
> Hi All,
>
> Need help - I posted my test file here
> <https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download>
> (SMF-DOW Jones 30 Stocks.xlsx)
> excel (SUM, IF etc.) after pulling in data using RCHGetYahooQuotes - any
> ideas?
>
>
>
Mon Aug 7, 2017 3:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Link doesn't work for me. Just attach the file to a message here?
On Mon, Aug 7, 2017 at 2:16 PM, dvisser01@
...
wrote:
>
> Need help - I posted my test file here
> <https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download>
> (SMF-DOW Jones 30 Stocks.xlsx). I can not seem to use normal functions in
> excel (SUM, IF etc.) after pulling in data using RCHGetYahooQuotes - any
> ideas?
>
>
>
On Mon, Aug 7, 2017 at 2:16 PM, dvisser01@
...
wrote:
>
> Need help - I posted my test file here
> <https://xa.yimg.com/df/smf_addin/SMF-DOW+Jones+30+Stocks.xlsx?token=rCDkNIYaL4OY5atUF_NV1XYAQsJ5Dbl1f3HPrbEvGU_OyZhQQGeE6JZ3o2jO4jjptMih7S8fbvT5k2OGlDhQgTc-BVyk9f0ZXXLhK0E8wJ8lxE3F1C3exTMJRg9b08gXVCkgZEfBBaHKLX5KPIxt6gjm9zTN1cNFLZ_KCf1Ggzk&type=download>
> (SMF-DOW Jones 30 Stocks.xlsx)
> excel (SUM, IF etc.) after pulling in data using RCHGetYahooQuotes - any
> ideas?
>
>
>
Mon Aug 7, 2017 4:11 pm (PDT) . Posted by:
buckleca
I've used the static pages from the cheat sheet that you provided. I can't see how to get the current dividend. I can get the current yield and period dividend, but not the actual annual dividend dollar amount.
However, I notice that MorningStar now pulls the quotes with "Beta" and the current dividend is available there.
I don't think I can pull this from the website because it's only available when you click on Dividends. That info doesn't appear in the page source.
Do you know if the current dividend is available in any of the static pages? Can't see in the current list.
Dividend frequency would also be very useful and I could determine that when annual is divided by the period dividend.
Thanks
However, I notice that MorningStar now pulls the quotes with "Beta" and the current dividend is available there.
I don't think I can pull this from the website because it's only available when you click on Dividends. That info doesn't appear in the page source.
Do you know if the current dividend is available in any of the static pages? Can't see in the current list.
Dividend frequency would also be very useful and I could determine that when annual is divided by the period dividend.
Thanks
Mon Aug 7, 2017 4:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not currently seeing the new beta pages, but as I recall, I had
difficulty getting any data from the beta version of MorningStar.
I don't see a TTM dividend amount from the static pages...
I usually use the amounts from the Yahoo Key Statistics page, since they
carry both the TTM amount and the indicated forward dividend amount.
On Mon, Aug 7, 2017 at 4:11 PM, buckleca@
...
wrote:
> I've used the static pages from the cheat sheet that you provided. I can't
> see how to get the current dividend. I can get the current yield and period
> dividend, but not the actual annual dividend dollar amount.
>
> However, I notice that MorningStar now pulls the quotes with "Beta" and
> the current dividend is available there.
> I don't think I can pull this from the website because it's only available
> when you click on Dividends. That info doesn't appear in the page source.
>
> Do you know if the current dividend is available in any of the static
> pages? Can't see in the current list.
>
> Dividend frequency would also be very useful and I could determine that
> when annual is divided by the period dividend.
>
>
difficulty getting any data from the beta version of MorningStar.
I don't see a TTM dividend amount from the static pages...
I usually use the amounts from the Yahoo Key Statistics page, since they
carry both the TTM amount and the indicated forward dividend amount.
On Mon, Aug 7, 2017 at 4:11 PM, buckleca@
...
wrote:
> I've used the static pages from the cheat sheet that you provided. I can't
> see how to get the current dividend. I can get the current yield and period
> dividend, but not the actual annual dividend dollar amount.
>
> However, I notice that MorningStar now pulls the quotes with "Beta" and
> the current dividend is available there.
> I don't think I can pull this from the website because it's only available
> when you click on Dividends. That info doesn't appear in the page source.
>
> Do you know if the current dividend is available in any of the static
> pages? Can't see in the current list.
>
> Dividend frequency would also be very useful and I could determine that
> when annual is divided by the period dividend.
>
>
Mon Aug 7, 2017 4:51 pm (PDT) . Posted by:
lexstar
When using smfGetYahooHistory("SPY",B$1,C$1,"m","dohlcv",0,0,1) where B$1 is any date prior to 8/1/2017 and C$1 is today 8/7/2017, why do I get a date of 8/7/2017 and 8/1/2017 for the month of August? This happens for both ETFs and Stocks.
But, when I use the function with Mutual Funds, I only get one date of 8/1/2017?
Anyway, I can fix it?
But, when I use the function with Mutual Funds, I only get one date of 8/1/2017?
Anyway, I can fix it?
Mon Aug 7, 2017 5:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but that's what Yahoo is sending for the requests. It may have
something to do with mutual fund prices not being updated for today...
On Mon, Aug 7, 2017 at 4:51 PM, lexstar@
...
wrote:
>
> When using smfGetYahooHistory("SPY",B$1,C$1,"m","dohlcv",0,0,1) where B$1
> is any date prior to 8/1/2017 and C$1 is today 8/7/2017, why do I get a
> date of 8/7/2017 and 8/1/2017 for the month of August? This happens for
> both ETFs and Stocks.
>
> But, when I use the function with Mutual Funds, I only get one date of
> 8/1/2017?
>
> Anyway, I can fix it?
>
something to do with mutual fund prices not being updated for today...
On Mon, Aug 7, 2017 at 4:51 PM, lexstar@
...
wrote:
>
> When using smfGetYahooHistory(
> is any date prior to 8/1/2017 and C$1 is today 8/7/2017, why do I get a
> date of 8/7/2017 and 8/1/2017 for the month of August? This happens for
> both ETFs and Stocks.
>
> But, when I use the function with Mutual Funds, I only get one date of
> 8/1/2017?
>
> Anyway, I can fix it?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar