Sabtu, 08 September 2018

[smf_addin] Digest Number 4394

15 Messages

Digest #4394

Messages

Fri Sep 7, 2018 7:50 am (PDT) . Posted by:

stan_12@ymail.com

Hi everyone,
I am using the smfPricesByDates-function to get the year end closing prices of around 200 symbols for the last 10 years.


This function by default delivers an adjusted Close.


Is it also possible to get yahoo's "Close" which they show on the left of the Adj Close on their historical data page?


Best Regards ... Stan

Fri Sep 7, 2018 11:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but smfPricesByDates() only gets adjusted prices. It typically
wouldn't make sense to get prices for multiple dates for an equity over
time without having them adjusted for dividends. They just wouldn't be
comparable.

On Fri, Sep 7, 2018 at 7:50 AM stan_12@
....
wrote:

> I am using the smfPricesByDates-function to get the year end closing
> prices of around 200 symbols for the last 10 years.
>
> This function by default delivers an adjusted Close.
>
> Is it also possible to get yahoo's "Close" which they show on the left of
> the Adj Close on their historical data page?
>
>
>

Sat Sep 8, 2018 4:24 am (PDT) . Posted by:

stan_12@ymail.com

Hi Randy,
thanks for your quick answer.

My aim is to calculate the average Dividend/Price- Ratio. If I divide the Dividend through the Div-Adjusted Close the historic Div/Price-Ratios are getting higher than they really were at that time. That's why I would prefer the unadjusted Close.

Can you recommend another function to get to the unadjusted close? I tried "smfGetYahooHistory" but it was very slow as I have 200+ symbols. I probably got the configuration wrong.

I have the year-end dates for the last 10 years in the columns, and symbols in the rows.

Example:
=smfGetYahooHistory("IBM",,"12/31/2007",,"U",0)

In the Temp Internet FIles I could see that for every date a new file was created, hence the slowliness.
Probably array-entering something is the solution, but i could figure out how.

Best Regards ... Stan

Fri Sep 7, 2018 6:06 pm (PDT) . Posted by:

mokwit

Randy,

Just want to be sure that the Yahoo fundamental data is not working because Yahoo data is over in Smf add in rather than because I have not updated something or something like that.


Fri Sep 7, 2018 8:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'd need more specifics on what you're asking about. What function is not
working for you? What parameters are you using?

In addition, what do you get with:

=RCHGetElementNumber("Version")

On Fri, Sep 7, 2018 at 6:06 PM pmanz@
....
wrote:

>
> Just want to be sure that the Yahoo fundamental data is not working
> because Yahoo data is over in Smf add in rather than because I have not
> updated something or something like that.
>
>
>

Fri Sep 7, 2018 8:42 pm (PDT) . Posted by:

mokwit

This version:
Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; ; ; 1) which is the last date I could find for download add in on website

What is not working is everything in the old "Key staistics" spreadsheet

examples
Profit margin TTM =RCHGetElementNumber(Ticker,952)

Operating Cash Flow =RCHGetElementNumber(Ticker,970)

just get small caps "error" instead of data

Fri Sep 7, 2018 9:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

These are working here:

=RCHGetElementNumber("MMM";,952)
=RCHGetElementNumber("MMM";,970)

Do they not work for you, with that ticker symbol?

On Fri, Sep 7, 2018 at 8:42 PM pmanz@
....
wrote:

>
> This version:
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\Program
> Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; ; ; 1) which is the last
> date I could find for download add in on website
>
> What is not working is everything in the old "Key staistics" spreadsheet
>
> examples
> Profit margin TTM =RCHGetElementNumber(Ticker,952)
>
> Operating Cash Flow =RCHGetElementNumber(Ticker,970)
>
> just get small caps "error" instead of data
>
>
>

Fri Sep 7, 2018 9:07 pm (PDT) . Posted by:

mokwit

No, still get "Error" - tried with other tickers T F FB AAPL

Fri Sep 7, 2018 9:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Have you done this Internet Options setting?

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464

Try exiting EXCEL, changing that setting, the restart EXCEL and try the
formulas again.

On Fri, Sep 7, 2018 at 9:07 PM pmanz@
....
wrote:

>
> No, still get "Error" - tried with other tickers T F FB AAPL
>
>

Fri Sep 7, 2018 10:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

OK, what do you get with these:

=RCHGetTableCell("https://finance.yahoo.com/q/ks?s=MMM",1,"FINANCIAL
HIGHLIGHTS","PROFIT MARGIN")
=RCHGetTableCell("https://finance.yahoo.com/q/ks?s=MMM",1,">Profit Margin")
=RCHGetWebData("https://finance.yahoo.com/q/ks?s=MMM","Profit Margin",300)

=RCHGetTableCell("https://finance.yahoo.com/quote/MMM/key-statistics",1,">Profit
Margin")
=RCHGetWebData("https://finance.yahoo.com/quote/MMM/key-statistics","Profit
Margin",300)

If those return "Error", can you see the key statistics web page if you
visit those URLs in the EXCEL IE Object (keyboard shortcut alt+d+d+w)? You
can CANCEL out after you see the result of the two web pages.

On Fri, Sep 7, 2018 at 10:05 PM pmanz@
....
wrote:

>
> Checked - was already set to "enable"
>
>

Fri Sep 7, 2018 11:49 pm (PDT) . Posted by:

mokwit

Having trouble making that shortcut work - alt then first D gets me into "select data sources->my data sources" box

Fri Sep 7, 2018 11:51 pm (PDT) . Posted by:

mokwit

Forgot to mention that I got "error" with all 5 links.

Sat Sep 8, 2018 2:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. That keyboard shortcut has worked on every version of EXCEL I've had.

I'm not sure how else to tell you how to get there, since the method that
works on my version may not apply to yours. I would:

1. Select the "Data" tab
2. Select the "From Web" option
3. Check "Advanced" and enter the URL --
https://finance.yahoo.com/quote/MMM/key-statistics
4. Click OK
5. After it connects, click on "Web View"
6. Do you see the Yahoo key statistics web page?
7. Click "Cancel" to exit

What version of IE to do you have? What do you get in IE from this web page:

http://www.pinlady.net/PluginDetect/IE/

What do you see if you use that URL in step (3) above?

On Fri, Sep 7, 2018 at 11:49 PM pmanz@usa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Having trouble making that shortcut work - alt then first D gets me into
> "select data sources->my data sources" box
>
>
>

Sat Sep 8, 2018 2:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's not good. What do you get with this:

=RCHGetWebData("https://finance.yahoo.com/quote/MMM/key-statistics")
=LEN(RCHGetWebData("https://finance.yahoo.com/quote/MMM/key-statistics"))

On Fri, Sep 7, 2018 at 11:51 PM pmanz@
....
wrote:

>
> Forgot to mention that I got "error" with all 5 links.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 04.24

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)