Selasa, 12 Januari 2016

[smf_addin] Digest Number 3606

13 Messages

Digest #3606

Messages

Mon Jan 11, 2016 11:26 am (PST) . Posted by:

bobc94595

How do I insert "Ticker" instead of XOM.N, as I am doing in my message above.

I am using: RCHGetTableCell("http://www.reuters.com/finance/stocks/financialHighlights?symbol="&Ticker,1,"Valuation Ratios","P/E Ratio (",,,0) in the spreadsheet to extract PE from the Reuters Overview page, and was hopeful that another "Ticker" formula would be possible for getting the Closing from the same page.

I am using SMF Template: RCHGetTableCell_Key_Financial_Ratios_Reuter

My SMF Version is 2.1.2015.08.13

Mon Jan 11, 2016 1:14 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just do it the exact same way:

=smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol=
"&Ticker,"span",2,"id=""headerQuoteContainer""",,,,1)

On Mon, Jan 11, 2016 at 12:26 PM, conlonrc@... wrote:

>
> How do I insert "Ticker" instead of XOM.N, as I am doing in my message
> above.
>
> I am using: RCHGetTableCell("
> http://www.reuters.com/finance/stocks/financialHighlights?symbol="&Ticker,1,"Valuation
> Ratios","P/E Ratio (",,,0) in the spreadsheet to extract PE from the
> Reuters Overview page, and was hopeful that another "Ticker" formula would
> be possible for getting the Closing from the same page.
>
> I am using SMF Template: RCHGetTableCell_Key_Financial_Ratios_Reuter
>
> My SMF Version is 2.1.2015.08.13
>

Mon Jan 11, 2016 3:02 pm (PST) . Posted by:

bobc94595

Thanks, Randy. Works great.

Mon Jan 11, 2016 6:23 pm (PST) . Posted by:

ojalee1

Randy,

I'm getting some results that I can't figure out with ADVFN. Most tickers work fine and pull the financial data as it should. However, some tickers return nothing but ERROR. I have tried the fix provided in the Tips and FAQs and it resolved other issues I was having but not this one.
Here are my issues:
1) Some tickers return only the Quarterly financials but not the Annual results and vice versa sometimes. For example NFLX returns the annual reports but not the quarterly reports but IBM return the Quarterly financials but returns ERROR for the Annual reports.
2) Another issue that I can't resolve is why some tickers requires imputing the exchange along with the ticker. For example, the only way I can get anything to return on IBM is by putting NYSE:IBM in my ticker field but I can just put in NFLX and it will work.
3) Almost all the tickers return ERROR for the Quarterly results for Quarters #6-10 using the smfGetAdvFNElement.

Any thoughts?

Responding to what you previously asked another poster...
What do you get for:

=RCHGetElementNumber("Version")
I get: Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2014.10.23.B; www; Local; 1)
=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0 http://www.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0", 1, "year end date")
I get:
Error http://www.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0
=smfGetAdvFNElement("KO","A",999)
I get:
22

=smfGetAdvFNElement("KO","A",1,">year end date<")
I get:
2014/12
Thanks in advance.



Mon Jan 11, 2016 6:39 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It sounds to me like AdvFN is defaulting to a non-USA exchange. Those
tickers that aren't working probably have a company on that exchange that
uses the same ticker, or it's still the US company, but they didn't store
the financials on it.

If you type this address in your browse, does it stay the same in the
address bar, or are you redirected to another website (e.g.
http://uk.advfn.com):

http://www.advfn.com/

As an example, see the discussion on the thread around this message:

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

On Mon, Jan 11, 2016 at 7:23 PM, ojalee1@... wrote:

>
> I'm getting some results that I can't figure out with ADVFN. Most tickers
> work fine and pull the financial data as it should. However, some tickers
> return nothing but ERROR. I have tried the fix provided in the Tips and
> FAQs and it resolved other issues I was having but not this one.
> Here are my issues:
> 1) Some tickers return only the Quarterly financials but not the Annual
> results and vice versa sometimes. For example NFLX returns the annual
> reports but not the quarterly reports but IBM return the Quarterly
> financials but returns ERROR for the Annual reports.
> 2) Another issue that I can't resolve is why some tickers requires
> imputing the exchange along with the ticker. For example, the only way I
> can get anything to return on IBM is by putting NYSE:IBM in my ticker field
> but I can just put in NFLX and it will work.
> 3) Almost all the tickers return ERROR for the Quarterly results for
> Quarters #6-10 using the smfGetAdvFNElement.
>
> Any thoughts?
>
> Responding to what you previously asked another poster...
> What do you get for:
>
> =RCHGetElementNumber("Version")
> I get: Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF
> Add-In\RCH_Stock_Market_Functions-2.1.2014.10.23.B; www; Local; 1)
> =RCHGetTableCell("
> http://www.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",
> 1, "year end date")
> I get:
> Error
> <http://www.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0>
> =smfGetAdvFNElement("KO","A",999)
> I get:
> 22
>
> =smfGetAdvFNElement("KO","A",1,">year end date<")
> I get:
> 2014/12
> Thanks in advance.
>

Mon Jan 11, 2016 6:46 pm (PST) . Posted by:

ojalee1

When I put in the uk domain it stays as http://uk.advfn.com http://uk.advfn.com
When I put in advfn.com it redirects to http://www.advfn.com http://www.advfn.com

thanks for your quick response.

Mon Jan 11, 2016 6:48 pm (PST) . Posted by:

ojalee1

if it matters I'm in balmy Chicago.

Mon Jan 11, 2016 7:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

OK. If you're in Chicago, redirection shouldn't be an issue. Let's focus on
one company that's causing you issues. What do you get with:

=smfGetAdvFNElement("NFLX","A",999)

=smfGetAdvFNElement("NFLX","Q",999)

=smfGetAdvFNElement("NFLX","A",1,">year end date<")

=smfGetAdvFNElement("NFLX","Q",1,">quarter end date<")

=smfGetAdvFNElement("NFLX","Q",6,">quarter end date<")

=smfGetAdvFNElement("NFLX","Q",10,">quarter end date<")

=RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=NFLX",
"/stock-market/", 50)

On Mon, Jan 11, 2016 at 7:46 PM, ojalee1@... wrote:

>
> When I put in the uk domain it stays as http://uk.advfn.com
> When I put in advfn.com it redirects to http://www.advfn.com
>
> thanks for your quick response.
>

On Mon, Jan 11, 2016 at 7:48 PM, ojalee1@... wrote:

>
> if it matters I'm in balmy Chicago.
>
>

Mon Jan 11, 2016 7:27 pm (PST) . Posted by:

ojalee1

I get:

14
Error 2014/12 Error Error Error /stock-market/NASDAQ/NFLX/financials?mode=quarterl http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=NFLX

Mon Jan 11, 2016 7:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Can you exit and restart EXCEL and try them in a new worksheet? Any changes?

On Mon, Jan 11, 2016 at 8:27 PM, ojalee1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I get:
>
> Error 2014/12 Error Error Error
> /stock-market/NASDAQ/NFLX/financials?mode=quarterl
> <http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=NFLX>
>

Mon Jan 11, 2016 7:44 pm (PST) . Posted by:

ojalee1

Restarting fixed all my problems. Thanks a million Randy. I've literally have been trying to figure this out for the last 4 hours and you solved my issues in a couple of emails. Thanks again!

Mon Jan 11, 2016 7:47 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What probably happened is you were trying to access AdvFN when they were
doing something to the website or one or more of their servers. So some
pages weren't being retrieved properly from them (causing "Error" results).
The add-in saves a copy of a web page before extracting data from it, so
once you get an "Error" result, you'll continue to get that result until
that faulty saved copy of the web page is purged. That can be done either
via the smfForceRecalculation macro (see "Tips and FAQs" web page) or by
exiting and restarting EXCEL.

On Mon, Jan 11, 2016 at 8:44 PM, ojalee1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Restarting fixed all my problems. Thanks a million Randy. I've literally
> have been trying to figure this out for the last 4 hours and you solved my
> issues in a couple of emails. Thanks again!
>

Mon Jan 11, 2016 8:45 pm (PST) . Posted by:

ojalee1

gotcha that makes sense. I hadn't closed my excel file in a few days while I've been updating it to get advfn data as opposed to gurufocus. Thanks again much appreciated. Next time restarting will be my first step.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar