14 Messages
Digest #3576
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
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
>
>
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?
>
general, it shouldn'
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@.
>
> 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.
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.
>
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
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...
=RCHGetElementNumbe
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
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...
>
> =RCHGetElementNumbe
>
> 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?
>
On Mon, Dec 7, 2015 at 11:02 AM, Gaston Bullrich gaston.bullrich@
>
> 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
>
>
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...
>
> =RCHGetElementNumbe
>
> 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\SMF_Templates\9-21-15 SMF download; ; Local; 1)
now and seems to be working except for ticker GOV....
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\SMF_Templates\9-21-15
> SMF download; ; Local; 1)
> now and seems to be working except for ticker GOV....
>
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.
> 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:
Posting Komentar