8 New Messages
Digest #2586
Messages
Mon Apr 15, 2013 7:39 am (PDT) . Posted by:
"Philip S" philip_r_small
Hi Randy
Is it possible to extract data from the table from this site for specific funds or groups of funds?
http://www.aegon.co.uk/Funds/Fund-prices-and-performance/Performance/index.htm
Many thanks with helo with this.
Is it possible to extract data from the table from this site for specific funds or groups of funds?
http://www.aegon.
Many thanks with helo with this.
Mon Apr 15, 2013 8:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data is actually in a frame, but you can grab the table from that frame:
=RCHGetHTMLTable("
http://www.aegon.co.uk/static/aegonuk/funds/fund-performance/iframe_index.html
",
"Fund Name",-1,"",1)
On Mon, Apr 15, 2013 at 7:39 AM, Philip S <Philip_R_Small@hotmail.com >wrote:
>
> Is it possible to extract data from the table from this site for specific
> funds or groups of funds?
>
>
> http://www.aegon.co.uk/Funds/Fund-prices-and-performance/Performance/index.htm
>
>
=RCHGetHTMLTable(
http://www.aegon.
",
"Fund Name",-
On Mon, Apr 15, 2013 at 7:39 AM, Philip S <Philip_R_Small@
>
> Is it possible to extract data from the table from this site for specific
> funds or groups of funds?
>
>
> http://www.aegon.
>
>
Mon Apr 15, 2013 8:23 am (PDT) . Posted by:
"Philip S" philip_r_small
Hi Randy
Thanks for the very quick response. If I paste this into the spreadsheet (say in to cell A1) all I get is "Fund name" in that cell. Is there something else I should do to pick up the rest of the table? I have not used the RCHGetHTMLTable function before.
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The data is actually in a frame, but you can grab the table from that frame:
>
> =RCHGetHTMLTable("
> http://www.aegon.co.uk/static/aegonuk/funds/fund-performance/iframe_index.html
> ",
> "Fund Name",-1,"",1)
>
> On Mon, Apr 15, 2013 at 7:39 AM, Philip S <Philip_R_Small@...>wrote:
>
> >
> > Is it possible to extract data from the table from this site for specific
> > funds or groups of funds?
> >
> >
> > http://www.aegon.co.uk/Funds/Fund-prices-and-performance/Performance/index.htm
> >
> >
>
Thanks for the very quick response. If I paste this into the spreadsheet (say in to cell A1) all I get is "Fund name" in that cell. Is there something else I should do to pick up the rest of the table? I have not used the RCHGetHTMLTable function before.
Thanks
--- In smf_addin@yahoogrou
>
> The data is actually in a frame, but you can grab the table from that frame:
>
> =RCHGetHTMLTable(
> http://www.aegon.
> ",
> "Fund Name",-
>
> On Mon, Apr 15, 2013 at 7:39 AM, Philip S <Philip_R_
>
> >
> > Is it possible to extract data from the table from this site for specific
> > funds or groups of funds?
> >
> >
> > http://www.aegon.
> >
> >
>
Mon Apr 15, 2013 8:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to array-enter it over a range...
On Mon, Apr 15, 2013 at 8:23 AM, Philip S <Philip_R_Small@hotmail.com >wrote:
>
> Thanks for the very quick response. If I paste this into the spreadsheet
> (say in to cell A1) all I get is "Fund name" in that cell. Is there
> something else I should do to pick up the rest of the table? I have not
> used the RCHGetHTMLTable function before.
>
On Mon, Apr 15, 2013 at 8:23 AM, Philip S <Philip_R_Small@
>
> Thanks for the very quick response. If I paste this into the spreadsheet
> (say in to cell A1) all I get is "Fund name" in that cell. Is there
> something else I should do to pick up the rest of the table? I have not
> used the RCHGetHTMLTable function before.
>
Mon Apr 15, 2013 8:31 am (PDT) . Posted by:
"Philip S" philip_r_small
Thank you.... works perfectly....I tried to array enter it but only in the one cell.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You need to array-enter it over a range...
>
> On Mon, Apr 15, 2013 at 8:23 AM, Philip S <Philip_R_Small@...>wrote:
>
> >
> > Thanks for the very quick response. If I paste this into the spreadsheet
> > (say in to cell A1) all I get is "Fund name" in that cell. Is there
> > something else I should do to pick up the rest of the table? I have not
> > used the RCHGetHTMLTable function before.
> >
>
--- In smf_addin@yahoogrou
>
> You need to array-enter it over a range...
>
> On Mon, Apr 15, 2013 at 8:23 AM, Philip S <Philip_R_
>
> >
> > Thanks for the very quick response. If I paste this into the spreadsheet
> > (say in to cell A1) all I get is "Fund name" in that cell. Is there
> > something else I should do to pick up the rest of the table? I have not
> > used the RCHGetHTMLTable function before.
> >
>
Mon Apr 15, 2013 5:12 pm (PDT) . Posted by:
"andyha8" andyha8
I would like to be able to get 14 day Average True Range into my spreadsheet from here:
http://www.barchart.com/technicals/stocks/KKD
I've tried this:
=RCHGetTableCell("http://quote.barchart.com/techrept.asp?sym= "&$G$2,1,"Average True Range")
but I know it's not right because it doesn't factor in the period.
I don't necessarily need to get it from this site any site will do. I want to use it in helping me with placing stops on my covered call trades.
I've been reading that ATR X2 is a good point for a stop/loss.
Thanks Randy
http://www.barchart
I've tried this:
=RCHGetTableCell(
but I know it's not right because it doesn't factor in the period.
I don't necessarily need to get it from this site any site will do. I want to use it in helping me with placing stops on my covered call trades.
I've been reading that ATR X2 is a good point for a stop/loss.
Thanks Randy
Mon Apr 15, 2013 7:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure why you used a different URL in your function?
To get the 14-day:
=RCHGetTableCell("http://www.barchart.com/technicals/stocks/ "&$G$2,4,">Average
True Range","14-Day")
On Mon, Apr 15, 2013 at 5:12 PM, andyha8 <andyha8@gmail.com > wrote:
> I would like to be able to get 14 day Average True Range into my
> spreadsheet from here:
>
> http://www.barchart.com/technicals/stocks/KKD
>
> I've tried this:
>
> =RCHGetTableCell("http://quote.barchart.com/techrept.asp?sym= "&$G$2,1,"Average
> True Range")
>
> but I know it's not right because it doesn't factor in the period.
>
> I don't necessarily need to get it from this site any site will do. I want
> to use it in helping me with placing stops on my covered call trades.
> I've been reading that ATR X2 is a good point for a stop/loss.
>
To get the 14-day:
=RCHGetTableCell(
True Range",
On Mon, Apr 15, 2013 at 5:12 PM, andyha8 <andyha8@gmail.
> I would like to be able to get 14 day Average True Range into my
> spreadsheet from here:
>
> http://www.barchart
>
> I've tried this:
>
> =RCHGetTableCell(
> True Range")
>
> but I know it's not right because it doesn't factor in the period.
>
> I don't necessarily need to get it from this site any site will do. I want
> to use it in helping me with placing stops on my covered call trades.
> I've been reading that ATR X2 is a good point for a stop/loss.
>
Mon Apr 15, 2013 8:31 pm (PDT) . Posted by:
"andyha8" andyha8
Thanks so much Randy. I can only speak for myself when I tell you that I really don't get how to do all of this. I'm just guessing and trying to copy what you do. Again, thanks for helping out, you're amazing!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not sure why you used a different URL in your function?
>
> To get the 14-day:
>
> =RCHGetTableCell("http://www.barchart.com/technicals/stocks/ "&$G$2,4,">Average
> True Range","14-Day")
>
> On Mon, Apr 15, 2013 at 5:12 PM, andyha8 <andyha8@...> wrote:
>
> > I would like to be able to get 14 day Average True Range into my
> > spreadsheet from here:
> >
> > http://www.barchart.com/technicals/stocks/KKD
> >
> > I've tried this:
> >
> > =RCHGetTableCell("http://quote.barchart.com/techrept.asp?sym= "&$G$2,1,"Average
> > True Range")
> >
> > but I know it's not right because it doesn't factor in the period.
> >
> > I don't necessarily need to get it from this site any site will do. I want
> > to use it in helping me with placing stops on my covered call trades.
> > I've been reading that ATR X2 is a good point for a stop/loss.
> >
>
--- In smf_addin@yahoogrou
>
> Not sure why you used a different URL in your function?
>
> To get the 14-day:
>
> =RCHGetTableCell(
> True Range",
>
> On Mon, Apr 15, 2013 at 5:12 PM, andyha8 <andyha8@
>
> > I would like to be able to get 14 day Average True Range into my
> > spreadsheet from here:
> >
> > http://www.barchart
> >
> > I've tried this:
> >
> > =RCHGetTableCell(
> > True Range")
> >
> > but I know it's not right because it doesn't factor in the period.
> >
> > I don't necessarily need to get it from this site any site will do. I want
> > to use it in helping me with placing stops on my covered call trades.
> > I've been reading that ATR X2 is a good point for a stop/loss.
> >
>
Tidak ada komentar:
Posting Komentar