Selasa, 08 Desember 2015

[smf_addin] Digest Number 3576

14 Messages

Digest #3576
2a
Re: Combining Morningstar and yahoo by "Randy Harmelink" rharmelink
2c
Re: Combining Morningstar and yahoo by "Randy Harmelink" rharmelink
3b
3c
Re: Shares Short/Short Ratio returning error by "Randy Harmelink" rharmelink
3d
Re: Shares Short/Short Ratio returning error by "Randy Harmelink" rharmelink
3f
Re: Shares Short/Short Ratio returning error by "Randy Harmelink" rharmelink

Messages

Mon Dec 7, 2015 6:35 am (PST) . Posted by:

jrwbob

Randy, the past dividend element would be fine for those securities. Is there a list of Yahoo elements link that I might see for other items of possible interest?
thanks

Mon Dec 7, 2015 7:02 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the XLS file distributed with the add-in. It contains a list of
all the defined elements for RCHGetElementNumber().

On Mon, Dec 7, 2015 at 7:35 AM, jrwbob@... wrote:

>
> Randy, the past dividend element would be fine for those securities.
> Is there a list of Yahoo elements link that I might see for other items of
> possible interest?
> thanks
>
>

Mon Dec 7, 2015 7:01 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Shouldn't be a problem. Just use the functions that get you the data. In
general, it shouldn't matter if the data is coming from different sources.
However, I'd be cautious about combining similar types of data from
different source (e.g. financial statements data).

On Mon, Dec 7, 2015 at 2:12 AM, cgrauballe@... wrote:

>
> Is there any way to combine the use of morningstar and yahoo?
>
> The thing is i use all the financial figures from morningstar, IS, BS, CF
> etc. But, i dont have the stock price development over the last 5 years
> from there so it creates problem when i put in my ticker, and it updates.
> Is there any way to overcome this problem?
>

Mon Dec 7, 2015 11:58 am (PST) . Posted by:

cgrauballe

But you would need to grab stock prices from this page right: MSFT Microsoft Corp Stock Price History http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US

MSFT Microsoft Corp Stock Price History http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US Get stock price history data for MSFT Microsoft Corp including short and long-term pricing by day, month, and year.



View on performance.morningstar.com http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US
Preview by Yahoo




that was exactly my point. It seems difficult to combine, and i have all the financial things from MS, but historic prices from Yahoo, which makes its difficult since some tickers are different in between the pages.

Mon Dec 7, 2015 12:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Nope. You can use RCHGetYahooHistory() to get historical quotes from Yahoo,
and RCHGetElementNumber() or RCHGetTableCell(), or any other function, to
get data from MorningStar.

Although you are correct that ticker symbols can be an issue. But you can
use different ticker symbols for the different functions.

On Mon, Dec 7, 2015 at 12:58 PM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> But you would need to grab stock prices from this page right: MSFT
> Microsoft Corp Stock Price History
> <http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US>
> MSFT Microsoft Corp Stock Price History
> <http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US>
> Get stock price history data for MSFT Microsoft Corp including short and
> long-term pricing by day, month, and year.
> View on performance.morningstar.com
> <http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=MSFT®ion=usa&culture=en-US>
> Preview by Yahoo
>
>
> that was exactly my point. It seems difficult to combine, and i have all
> the financial things from MS, but historic prices from Yahoo, which makes
> its difficult since some tickers are different in between the pages.
>

Tue Dec 8, 2015 12:29 am (PST) . Posted by:

cgrauballe

Okay. It was just to avoid looking up 2 tickers everytime, but guess thats not possible. Thanks anyway :)

Mon Dec 7, 2015 7:57 am (PST) . Posted by:

mac_questions

Hi there,
I am trying to pull down the following data in excell:

Shares Short -- Current Short Ratio Short % of Float Shares Short -- Prior
For some reason when I use the following formula it only returns "Error" I have tried several of the SMF links, even the outdated ones. Can you please tell me which formula to use and which RCH Stock Market link to use...

=RCHGetElementNumber(A2,986)

for 985, 986,987,988


Thanks,
Diana







Mon Dec 7, 2015 10:02 am (PST) . Posted by:

"Gaston Bullrich" gbullr

How do I disable then auto MSN messenger start?

On Mon, Dec 7, 2015 at 10:57 AM, d_folino@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi there,
>
> I am trying to pull down the following data in excell:
>
> Shares Short -- Current Short Ratio Short % of Float Shares Short -- Prior
> For some reason when I use the following formula it only returns "Error" I
> have tried several of the SMF links, even the outdated ones.
> Can you please tell me which formula to use and which RCH Stock Market
> link to use...
>
> =RCHGetElementNumber(A2,986)
>
> for 985, 986,987,988
>
>
> Thanks,
>
> Diana
>
>
>
>
>
>

--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907

Mon Dec 7, 2015 11:35 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I have no idea what that question is asking?

On Mon, Dec 7, 2015 at 11:02 AM, Gaston Bullrich gaston.bullrich@... wrote:

>
> How do I disable then auto MSN messenger start?
>

Mon Dec 7, 2015 11:41 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried those four element numbers with ticker symbol MMM and they
worked fine.

What ticker symbols are you trying them for?

On Mon, Dec 7, 2015 at 8:57 AM, d_folino@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I am trying to pull down the following data in excell:
>
> Shares Short -- Current Short Ratio Short % of Float Shares Short -- Prior
> For some reason when I use the following formula it only returns "Error" I
> have tried several of the SMF links, even the outdated ones.
> Can you please tell me which formula to use and which RCH Stock Market
> link to use...
>
> =RCHGetElementNumber(A2,986)
>
> for 985, 986,987,988
>
>

Mon Dec 7, 2015 1:21 pm (PST) . Posted by:

mac_questions

Ok, I believe it is the version I was using... I am using Stock Market Functions add-in, Version 2.1.2015.07.08 (Z:\VISTA&#92;SMF_Templates\9-21-15 SMF download; ; Local; 1)
now and seems to be working except for ticker GOV....

Mon Dec 7, 2015 1:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

GOV doesn't have a Key Statistics web page on Yahoo, so it won't work...

On Mon, Dec 7, 2015 at 2:21 PM, d_folino@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Ok, I believe it is the version I was using... I am using Stock Market
> Functions add-in, Version 2.1.2015.07.08 (Z:\VISTA&#92;SMF_Templates\9-21-15
> SMF download; ; Local; 1)
> now and seems to be working except for ticker GOV....
>

Mon Dec 7, 2015 1:45 pm (PST) . Posted by:

mac_questions

Oh geez thank you... By the way, you have made my life so easy with this add-in - you're awesome!!! :):):):)

Mon Dec 7, 2015 6:24 pm (PST) . Posted by:

mark.boogaers

Thanks. Got it working although not sure which login actually did the trick.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar