Kamis, 09 Juni 2011

[smf_addin] Digest Number 1851

Messages In This Digest (14 Messages)

Messages

1a.

Re: FX Rates

Posted by: "bushpilote" bushpilote@yahoo.ca   bushpilote

Wed Jun 8, 2011 4:50 am (PDT)



Got it. Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to array-enter the formula over a range -- here's the result I get:
>
> Jul.Day YYYY/MM/DD Wdy EUR/USD 2455716 2011/06/03 Fri 0.68475
> But if you only enter the formula in a single cell, all you'd get is the
> value for the first row and first column of the table.
>
> On Tue, Jun 7, 2011 at 5:12 AM, bushpilote <bushpilote@...> wrote:
>
> >
> > Works fine for you meaning that you are getting USDEUR rate of .6848?
> >
> > At my end the formula results in "Jul.Day". Formatting the cell in not an
> > issue.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Wed Jun 8, 2011 6:37 am (PDT)



Hello Randy, I've been trying out your addin and it is amazing for getting yahoo quotes. Now on to something more adventurous, to get more detailed tables from indian websites using gethtmltable function, and i'm stuck. I cannot seem to find the directly relevant table locator text strings to use within the function when i "view source" of the main webpage in internet explorer. If i click directly on the tables of interest, the "view source" does show relevant strings, but they have not worked. Using Excel 2007.

Here are two example hyperlinks (from two different websites), and from these pages i was trying to get the main tables (e.g. detailed trading activity and 52 wk high/lows) under the Quotes section-

http://www.indsec.co.in/Fundamental.asp?SectionName=QUOTES&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1

http://www.way2wealth.com/CompanyInfo.asp?Location=Quotes&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1Location=Quotes

Any help greatly appreciated!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2b.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 8, 2011 11:10 am (PDT)



The problem is that the data is presented in frames, so the tables aren't
actually within the source code of those web pages.

From the first page:

=RCHGetHTMLTable("
http://www.indsec.co.in/Fundamental/quotes.asp?CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Last
Traded Price",-1,"",1)

From the second page:

=RCHGetHTMLTable("
http://www.contentlinks.asiancerc.com/way2wealth/fundamental/Quotes.asp?CompanyCode=15530059&Ticker=JSW+Steel","Last
Traded Price",-1,"",1)

On Wed, Jun 8, 2011 at 3:22 AM, winvestr <winvestr@gmail.com> wrote:

> Hello Randy, I've been trying out your addin and it is amazing for getting
> yahoo quotes. Now on to something more adventurous, to get more detailed
> tables from indian websites using gethtmltable function, and i'm stuck. I
> cannot seem to find the directly relevant table locator text strings to use
> within the function when i "view source" of the main webpage in internet
> explorer. If i click directly on the tables of interest, the "view source"
> does show relevant strings, but they have not worked. Using Excel 2007.
>
> Here are two example hyperlinks (from two different websites), and from
> these pages i was trying to get the main tables (e.g. detailed trading
> activity and 52 wk high/lows) under the Quotes section-
>
>
> http://www.indsec.co.in/Fundamental.asp?SectionName=QUOTES&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1
>
>
> http://www.way2wealth.com/CompanyInfo.asp?Location=Quotes&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1Location=Quotes
>
> Any help greatly appreciated!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2c.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Au" uanant@ymail.com   uanant@ymail.com

Wed Jun 8, 2011 12:27 pm (PDT)



Randy,
On the same node, how to extract the data from this link. 
http://www.indsec.co.in/Fundamental.asp?SectionName=BS&CompanyCode=12150008&CompanyName=Reliance+Industries+Ltd%2E&Ticker=RIL&MajorSector=1

Lets say I want to get equity share capital for Mar 2011

Thanks for your help
Au

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, June 8, 2011 2:09 PM
Subject: Re: [smf_addin] Need help with extracting table (non-Yahoo)

 
The problem is that the data is presented in frames, so the tables aren't actually within the source code of those web pages.

From the first page:

=RCHGetHTMLTable("http://www.indsec.co.in/Fundamental/quotes.asp?CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Last Traded Price",-1,"",1)

From the second page:

=RCHGetHTMLTable("http://www.contentlinks.asiancerc.com/way2wealth/fundamental/Quotes.asp?CompanyCode=15530059&Ticker=JSW+Steel","Last Traded Price",-1,"",1)

On Wed, Jun 8, 2011 at 3:22 AM, winvestr <winvestr@gmail.com> wrote:

Hello Randy, I've been trying out your addin and it is amazing for getting yahoo quotes. Now on to something more adventurous, to get  more detailed tables from indian websites using gethtmltable function, and i'm stuck. I cannot seem to find the directly relevant table locator text strings to use within the function when i "view source" of the main webpage in internet explorer. If i click directly on the tables of interest, the "view source" does show relevant strings, but they have not worked.  Using Excel 2007.
>
>Here are two example hyperlinks (from two different websites), and from these pages i was trying to get the main tables (e.g. detailed trading activity and 52 wk high/lows) under the Quotes section-
>
>http://www.indsec.co.in/Fundamental.asp?SectionName=QUOTES&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1
>
>http://www.way2wealth.com/CompanyInfo.asp?Location=Quotes&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1Location=Quotes
>
>Any help greatly appreciated!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2d.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 8, 2011 1:33 pm (PDT)



From the frame URL:

=RCHGetTableCell("
http://www.indsec.co.in/Fundamental/FundaReports.asp?ReportType=BS&CompanyCode=12150008&CompanyName=Reliance+Industries+Ltd.&Ticker=RIL&MajorSector=1",1,">Equity
Share Capital")

On Wed, Jun 8, 2011 at 12:26 PM, Au <uanant@ymail.com> wrote:

>
>
> On the same node, how to extract the data from this link.
>
> http://www.indsec.co.in/Fundamental.asp?SectionName=BS&CompanyCode=12150008&CompanyName=Reliance+Industries+Ltd%2E&Ticker=RIL&MajorSector=1
>
> Lets say I want to get equity share capital for Mar 2011
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2e.

Re: Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Wed Jun 8, 2011 5:03 pm (PDT)



It worked! Thank you Randy!

I'm not clear though about how one would go about figuring out the appropriate table locator arguments. In response to my question, you used the following locator arguments [...,"Last Traded Price",-1,"",1] and the function returned the table perfectly.

Looking at the structure of the above successful query, I tried a similar approach to get the P&L statement table from the same site, but only received blank cells with the attempt copied below... could you demystify how you go about selecting the appropriate locator arguments?

=RCHGetHTMLTable("http://www.indsec.co.in/Fundamental.asp?SectionName=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1","Operating Income ",-1,"",1)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that the data is presented in frames, so the tables aren't
> actually within the source code of those web pages.
>
> From the first page:
>
> =RCHGetHTMLTable("
> http://www.indsec.co.in/Fundamental/quotes.asp?CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Last
> Traded Price",-1,"",1)
>
> From the second page:
>
> =RCHGetHTMLTable("
> http://www.contentlinks.asiancerc.com/way2wealth/fundamental/Quotes.asp?CompanyCode=15530059&Ticker=JSW+Steel","Last
> Traded Price",-1,"",1)
>
> On Wed, Jun 8, 2011 at 3:22 AM, winvestr <winvestr@...> wrote:
>
> > Hello Randy, I've been trying out your addin and it is amazing for getting
> > yahoo quotes. Now on to something more adventurous, to get more detailed
> > tables from indian websites using gethtmltable function, and i'm stuck. I
> > cannot seem to find the directly relevant table locator text strings to use
> > within the function when i "view source" of the main webpage in internet
> > explorer. If i click directly on the tables of interest, the "view source"
> > does show relevant strings, but they have not worked. Using Excel 2007.
> >
> > Here are two example hyperlinks (from two different websites), and from
> > these pages i was trying to get the main tables (e.g. detailed trading
> > activity and 52 wk high/lows) under the Quotes section-
> >
> >
> > http://www.indsec.co.in/Fundamental.asp?SectionName=QUOTES&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1
> >
> >
> > http://www.way2wealth.com/CompanyInfo.asp?Location=Quotes&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1Location=Quotes
> >
> > Any help greatly appreciated!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2f.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 8, 2011 6:32 pm (PDT)



As I also indicated, the data is NOT on that web page. So you're never going
to come up with parameters to extract it off that web page.

Instead, that web page is displaying another web page within a frame. You
need to extract that data from THAT web page.

On Wed, Jun 8, 2011 at 5:02 PM, winvestr <winvestr@gmail.com> wrote:

> It worked! Thank you Randy!
>
> I'm not clear though about how one would go about figuring out the
> appropriate table locator arguments. In response to my question, you used
> the following locator arguments [...,"Last Traded Price",-1,"",1] and the
> function returned the table perfectly.
>
> Looking at the structure of the above successful query, I tried a similar
> approach to get the P&L statement table from the same site, but only
> received blank cells with the attempt copied below... could you demystify
> how you go about selecting the appropriate locator arguments?
>
> =RCHGetHTMLTable("
> http://www.indsec.co.in/Fundamental.asp?SectionName=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1","Operating
> Income ",-1,"",1)
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2g.

Re: Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Wed Jun 8, 2011 7:17 pm (PDT)



OK.. so here's what i did. Opened the page mentioned in the msg referenced below, eyeballed the table and selected a text string (e.g. "Operating Income") that looked unique within the page. Right-clicked on the table to view source of that frame. Verified that the selected string appears in the source of the relevant frame. Then tried that string in the function, then tried another one... repeated several times. All i got was blank cells in the array. So clearly i'm missing something in the process?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As I also indicated, the data is NOT on that web page. So you're never going
> to come up with parameters to extract it off that web page.
>
> Instead, that web page is displaying another web page within a frame. You
> need to extract that data from THAT web page.
>
> On Wed, Jun 8, 2011 at 5:02 PM, winvestr <winvestr@...> wrote:
>
> > It worked! Thank you Randy!
> >
> > I'm not clear though about how one would go about figuring out the
> > appropriate table locator arguments. In response to my question, you used
> > the following locator arguments [...,"Last Traded Price",-1,"",1] and the
> > function returned the table perfectly.
> >
> > Looking at the structure of the above successful query, I tried a similar
> > approach to get the P&L statement table from the same site, but only
> > received blank cells with the attempt copied below... could you demystify
> > how you go about selecting the appropriate locator arguments?
> >
> > =RCHGetHTMLTable("
> > http://www.indsec.co.in/Fundamental.asp?SectionName=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd%2E&Ticker=JSW+Steel&MajorSector=1","Operating
> > Income ",-1,"",1)
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2h.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 8, 2011 9:48 pm (PDT)



This appears to work fine for me:

=RCHGetHTMLTable("
http://www.indsec.co.in/Fundamental/FundaReports.asp?ReportType=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Operating
Income",-1,"",1)

Are you not using the URL of the frame?

On Wed, Jun 8, 2011 at 7:17 PM, winvestr <winvestr@gmail.com> wrote:

> OK.. so here's what i did. Opened the page mentioned in the msg referenced
> below, eyeballed the table and selected a text string (e.g. "Operating
> Income") that looked unique within the page. Right-clicked on the table to
> view source of that frame. Verified that the selected string appears in the
> source of the relevant frame. Then tried that string in the function, then
> tried another one... repeated several times. All i got was blank cells in
> the array. So clearly i'm missing something in the process?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2i.

Re: Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Thu Jun 9, 2011 1:53 am (PDT)



> Are you not using the URL of the frame?

So that's what i'm missing. In fact i have no idea how to get the url of the frame, and didn't even know it would be accessible. Will do a google search on that right now. Please let me know if this topic has been explained elsewhere in the group. I have been browsing thru various posts within the group and did not find it yet.

Randy, i'm truly amazed at the level of support you provide to this group and to newbies like me. Don't know how to thank you enough.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This appears to work fine for me:
>
> =RCHGetHTMLTable("
> http://www.indsec.co.in/Fundamental/FundaReports.asp?ReportType=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Operating
> Income",-1,"",1)
>
> Are you not using the URL of the frame?
>
> On Wed, Jun 8, 2011 at 7:17 PM, winvestr <winvestr@...> wrote:
>
> > OK.. so here's what i did. Opened the page mentioned in the msg referenced
> > below, eyeballed the table and selected a text string (e.g. "Operating
> > Income") that looked unique within the page. Right-clicked on the table to
> > view source of that frame. Verified that the selected string appears in the
> > source of the relevant frame. Then tried that string in the function, then
> > tried another one... repeated several times. All i got was blank cells in
> > the array. So clearly i'm missing something in the process?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2j.

Re: Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Thu Jun 9, 2011 2:08 am (PDT)



Wanted to mention that i finally did figure it out... got the url thru page info option in firefox. Copy and paste operation did not work, but at least i can visually see it and type it in.

Thank you again Randy.

--- In smf_addin@yahoogroups.com, "winvestr" <winvestr@...> wrote:
>
> > Are you not using the URL of the frame?
>
> So that's what i'm missing. In fact i have no idea how to get the url of the frame, and didn't even know it would be accessible. Will do a google search on that right now. Please let me know if this topic has been explained elsewhere in the group. I have been browsing thru various posts within the group and did not find it yet.
>
> Randy, i'm truly amazed at the level of support you provide to this group and to newbies like me. Don't know how to thank you enough.
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > This appears to work fine for me:
> >
> > =RCHGetHTMLTable("
> > http://www.indsec.co.in/Fundamental/FundaReports.asp?ReportType=PL&CompanyCode=15530059&CompanyName=JSW+Steel+Ltd.&Ticker=JSW+Steel&MajorSector=1","Operating
> > Income",-1,"",1)
> >
> > Are you not using the URL of the frame?
> >
> > On Wed, Jun 8, 2011 at 7:17 PM, winvestr <winvestr@> wrote:
> >
> > > OK.. so here's what i did. Opened the page mentioned in the msg referenced
> > > below, eyeballed the table and selected a text string (e.g. "Operating
> > > Income") that looked unique within the page. Right-clicked on the table to
> > > view source of that frame. Verified that the selected string appears in the
> > > source of the relevant frame. Then tried that string in the function, then
> > > tried another one... repeated several times. All i got was blank cells in
> > > the array. So clearly i'm missing something in the process?
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2k.

Re: Need help with extracting table (non-Yahoo)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Jun 9, 2011 2:15 am (PDT)



In FireFox, if I right click on that table in the original URL, a context
menu item is "This Frame" and a sub-menu item from there is "Open Frame in
New Tab". That's how I always get the URL -- just open it up in a new tab
and then copy and paste from the address bar.

On Thu, Jun 9, 2011 at 2:07 AM, winvestr <winvestr@gmail.com> wrote:

> Wanted to mention that i finally did figure it out... got the url thru page
> info option in firefox. Copy and paste operation did not work, but at least
> i can visually see it and type it in.
>
> Thank you again Randy.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2l.

Re: Need help with extracting table (non-Yahoo)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Thu Jun 9, 2011 2:33 am (PDT)



Brilliant :)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> In FireFox, if I right click on that table in the original URL, a context
> menu item is "This Frame" and a sub-menu item from there is "Open Frame in
> New Tab". That's how I always get the URL -- just open it up in a new tab
> and then copy and paste from the address bar.
>
> On Thu, Jun 9, 2011 at 2:07 AM, winvestr <winvestr@...> wrote:
>
> > Wanted to mention that i finally did figure it out... got the url thru page
> > info option in firefox. Copy and paste operation did not work, but at least
> > i can visually see it and type it in.
> >
> > Thank you again Randy.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
3.

AdvFn EBIT discrepancy

Posted by: "alexander" alex.life2539@gmail.com   life2539

Wed Jun 8, 2011 1:39 pm (PDT)



Hi,

this is more of a problem on the site than this addin. I noticed when I was doing my homework on the calculation for EBIT and EBITDA that they didn't seem to match up with the values as they are supposed to be.

I examined KFT annual data(12/2010 and older) and checked how to get to EBIT from the values of EBITDA. Apparently, AdvFn's EBIT does not deduct Amortization of intangibles.

So to get AdvFn's EBIT from AdvFn's EBITDA, you have to add/deduct all other entries that is part of Depreciation, Amortization, and other income, EXCEPT Amortization of intangibles (I feel like I'm contradicting the definition).

So if anybody is using this value, I'd like to know how you adjusted it or how I must be interpreting these values. I do not have any other sources which I can cross check this information with.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 03.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)