Senin, 09 Februari 2015

[smf_addin] Digest Number 3318

15 Messages

Digest #3318
1a
Re: financial times extraction by "Randy Harmelink" rharmelink
2b
Re: Gurufocus Non US Listed Stocks by "Randy Harmelink" rharmelink
3e
Re: RCHGetYahooHistory not getting prior close by "Randy Harmelink" rharmelink
3f
Re: RCHGetYahooHistory not getting prior close by "Randy Harmelink" rharmelink
3g
Re: RCHGetYahooHistory not getting prior close by "Randy Harmelink" rharmelink
3j
Re: RCHGetYahooHistory not getting prior close by "Randy Harmelink" rharmelink
4a
Price Change % by "Alex" ar3582
4b
Re: Price Change % by "Randy Harmelink" rharmelink

Messages

Mon Feb 9, 2015 4:03 am (PST) . Posted by:

"Randy Harmelink" rharmelink

(1) The question about the interim data has been asked many times before. I
don't see any way to get it, because it's updated dynamically using a JSON
call. Sorry.

(2) The business description isn't within a table, so RCHGetHTMLTable()
isn't going to help at all.

This appears to work for picking up the business description:

=smfGetTagContent("
http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=IBM:NYQ
","div",1,">Website")

On Mon, Feb 9, 2015 at 1:57 AM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> there are some more problem.
>
> 1) while trying to extract the financial data from supposedly
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s="&C2&"&subview=BalanceSheet","Annual
> data<",-3,"",-3),
>
> i am able to pickup the annual balance sheet from cell C2.
>
> do you have any trick to pick up the Interim Data as well?
>
> 2) i am trying to pick up the company info for ibm
>
> International Business Machines Corporation (IBM) is an information
> technology (IT) company. IBM operates in five segments: Global Technology
> Services (GTS), Global Business Services (GBS),......
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=IBM:NYQ
> ","About",-2,"",-2)
>
> just dont seem to go anywhere.
>
> Did i pick the wrong table?
>

Mon Feb 9, 2015 8:48 am (PST) . Posted by:

soemoe.theinwin

Hi Randy,

Do you know how to pull in the figure or insitutional ownership into excel?

eg here: http://www.gurufocus.com/ownership/AAPL# http://www.gurufocus.com/ownership/AAPL# on the ownership tab its '63%'


Thanks so much for all you do.





Mon Feb 9, 2015 10:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ownership/AAPL
","h1",-1,"InstitutionalOwnership"))

On Mon, Feb 9, 2015 at 9:48 AM, soemoe.theinwin@... wrote:

>
> Do you know how to pull in the figure or insitutional ownership into excel?
>
> eg here: http://www.gurufocus.com/ownership/AAPL# on the ownership tab
> its '63%'
>
>
>

Mon Feb 9, 2015 8:50 am (PST) . Posted by:

eremon9

I retrieve historical closing prices for a number of tickers from Yahoo using RCHGetYahooHistory() in an array formula. With few exceptions, it's been working well for years. Today it's retrieving all but the most recent closing prices (for 2/6/15). Is anyone else seeing this? –tom

Mon Feb 9, 2015 8:54 am (PST) . Posted by:

"Brad Reel" reeldeal9090

I pulled data last night using that function and it pulled Feb 6 no
problem. I just pulled up a ticker (AEE) and it has historical data for
Feb 6. Usually, when this is a problem, it is because historical data has
not been loaded. Not sure what to tell you, other than it worked for me
last night and the data appears to be there on Yahoo's site.

On Mon, Feb 9, 2015 at 10:50 AM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I retrieve historical closing prices for a number of tickers from Yahoo
> using RCHGetYahooHistory() in an array formula. With few exceptions, it's
> been working well for years. Today it's retrieving all but the most recent
> closing prices (for 2/6/15). Is anyone else seeing this? –tom
>
>
>

Mon Feb 9, 2015 9:15 am (PST) . Posted by:

eremon9

Thanks. I too was able to retrieve Yahoo historical data that includes 2/6/15 on the Yahoo site itself, but am not getting it when recalculating my Excel array formula. I'm guessing there's some difference between the RCH retrieval process and that available on the website.

Mon Feb 9, 2015 10:31 am (PST) . Posted by:

jimmymc00

Maybe you guys can help me. I'm a new user and haven't figured out how to pull "last closing price" from Yahoo. Other data is coming in fine but I don't see an element no. to use for this. I may need to do something with

RCHGetYahooHistory()
? Thanks

-----Original Message-----
From: Brad Reel brad.reel90@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 9, 2015 11:54 am
Subject: Re: [smf_addin] RCHGetYahooHistory not getting prior close

I pulled data last night using that function and it pulled Feb 6 no problem. I just pulled up a ticker (AEE) and it has historical data for Feb 6. Usually, when this is a problem, it is because historical data has not been loaded. Not sure what to tell you, other than it worked for me last night and the data appears to be there on Yahoo's site.

On Mon, Feb 9, 2015 at 10:50 AM, tamurphy@cableone.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

I retrieve historical closing prices for a number of tickers from Yahoo using RCHGetYahooHistory() in an array formula. With few exceptions, it's been working well for years. Today it's retrieving all but the most recent closing prices (for 2/6/15). Is anyone else seeing this? –tom

Mon Feb 9, 2015 10:47 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried with ticker symbol MMM and it seemed to work OK. Can you give
an example of one that didn't?

On Mon, Feb 9, 2015 at 9:50 AM, tamurphy@... wrote:

> I retrieve historical closing prices for a number of tickers from Yahoo
> using RCHGetYahooHistory() in an array formula. With few exceptions, it's
> been working well for years. Today it's retrieving all but the most recent
> closing prices (for 2/6/15). Is anyone else seeing this? –tom
>

Mon Feb 9, 2015 10:49 am (PST) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() should use the same CSV that is available from the
"Download to Spreadsheet" link on the Yahoo page of historical quotes.
Whether or not it would match the quotes displayed on the web page, I can't
say. I would HOPE they would, but wouldn't guarantee it. I don't know if
the CSV file and the web page are built from the same database.

On Mon, Feb 9, 2015 at 10:15 AM, tamurphy@... wrote:

>
> Thanks. I too was able to retrieve Yahoo historical data that includes
> 2/6/15 on the Yahoo site itself, but am not getting
> it when recalculating my Excel array formula. I'm guessing there's some
> difference between the RCH retrieval process and that available on the
> website.
>

Mon Feb 9, 2015 10:59 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You can use RCHGetYahooQuotes() to retrieve the previous day's closing
price. For example:

=RCHGetYahooQuotes("MMM","p")

You should use that function for all current quotes type information. There
are no elements defined for daily quotes type data, because
RCHGetYahooQuotes() would be so much more efficient. It can get a number of
data items on up to 200 ticker symbols with a single Internet access.

On Mon, Feb 9, 2015 at 10:15 AM, jmcatee133@... wrote:

>
> Maybe you guys can help me. I'm a new user and haven't figured out how
> to pull "last closing price" from Yahoo. Other data is coming in fine but
> I don't see an element no. to use for this. I may need to do something with
> RCHGetYahooHistory()
>
>

Mon Feb 9, 2015 11:21 am (PST) . Posted by:

eremon9

Thanks again for your assistance. It turns out the problem is with ^GSPC, which I've been using to retrieve the dates column for the many tickers on my closing price worksheet. –tom

Mon Feb 9, 2015 11:21 am (PST) . Posted by:

eremon9

Thanks for the help. It turns out that my problem is that I was using ^GSPC (S&P500) for retrieving the dates for the many tickers on my closing price worksheet. I'd thought that was a relatively safe choice for consistent error-free performance. It looks like it's (hopefully) just ^GSPC that's not working properly, as I don't download dates for each of the tickers.


Is there an automated way to quickly validate historical data for all stocks on my list?


Thanks again for all your assistance.

Mon Feb 9, 2015 11:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

^GSPC sounds like it would be safe to me, too. Thanks Yahoo.

The only way I can think of to validate the dates is to retrieve a date or
dates for each stock.

This used to be a big issue, when Yahoo didn't carry data on days where a
stock had a volume of zero. Then the historical data wouldn't match up for
those stocks.

On Mon, Feb 9, 2015 at 12:21 PM, tamurphy@... wrote:

> Thanks for the help. It turns out that my problem is that I was using
> ^GSPC (S&P500) for retrieving the dates for the many tickers on my closing
> price worksheet. I'd thought that was a relatively safe choice for
> consistent error-free performance. It looks like it's (hopefully) just
> ^GSPC that's not working properly, as I don't download dates for each of
> the tickers.
>
> Is there an automated way to quickly validate historical data for all
> stocks on my list?
>

Mon Feb 9, 2015 10:32 am (PST) . Posted by:

"Alex" ar3582

Hi is there a working code on how to get price change percentage over different time frames in Excel? Also, I am new to adding formulas in Excel any info. you can pass on to learn how to do this is much appreciated!

Alex
 

Mon Feb 9, 2015 10:54 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the smfPricesByDates() templates on the add-in web site:

http://ogres-crypt.com/SMF/Templates/#smfPricesByDates%28%29

On Mon, Feb 9, 2015 at 10:28 AM, Alex ar3582@... wrote:

>
> Hi is there a working code on how to get price change percentage over
> different time frames in Excel? Also, I am new to adding formulas in Excel
> any info. you can pass on to learn how to do this is much appreciated!
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 11.31

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)