8 New Messages
Digest #2512
Messages
Sat Feb 16, 2013 7:23 am (PST) . Posted by:
"Undisclosed" iamruf
OK. Here is the opening URL:
http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_filter?pi_type=B
and here is the URL after clicking "Get Results" without inserting any Criteria:
http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, February 15, 2013 9:26 PM
Subject: Re: [smf_addin] CDN Mutual Fund Prices
I get an empty page with that URL.
On Fri, Feb 15, 2013 at 5:55 PM, iamruf iamruf@yahoo.com > wrote:
Hi Randy,
>The most comprehensive list of CDN MFunds is found at the site below (16,889 funds). However, there is no download feature.
>I can copy paste 338 pages but wondered if you know of a way to automate the process of scrolling through the pages & copy paste or load to Excel. Please review.
>Thanks
>http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?rep_type=STD&pi_report_tab=159&order_by=&direction=ASC&start_row=&pi_report_option=&pi_report_param=&pi_show_criteria_yn=Y&iaction=fundFilter&pi_portfolio_id=
>
http://globefunddb.
and here is the URL after clicking "Get Results" without inserting any Criteria:
http://globefunddb.
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, February 15, 2013 9:26 PM
Subject: Re: [smf_addin] CDN Mutual Fund Prices
I get an empty page with that URL.
On Fri, Feb 15, 2013 at 5:55 PM, iamruf iamruf@yahoo.
Hi Randy,
>The most comprehensive list of CDN MFunds is found at the site below (16,889 funds). However, there is no download feature.
>I can copy paste 338 pages but wondered if you know of a way to automate the process of scrolling through the pages & copy paste or load to Excel. Please review.
>Thanks
>http://globefunddb.
>
Sat Feb 16, 2013 8:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears possible, but non-trivial.
First off, the "Results" URL only appears viable after a manual visit to
the site and generation of "Get Results". Otherwise, it's not a
bookmarkable URL.
And the table coding is an issue for RCHGetHTMLTable().
But this general format formula seems to work:
=RCHGetTableCell($C$2,D$4,">Price $",,,,$B5,"
iamruf@yahoo.com > wrote:
>
> OK. Here is the opening URL:
>
> http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_filter?pi_type=B
> and here is the URL after clicking "Get Results" without inserting any
> Criteria:
>
> http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
>
>
First off, the "Results" URL only appears viable after a manual visit to
the site and generation of "Get Results"
bookmarkable URL.
And the table coding is an issue for RCHGetHTMLTable(
But this general format formula seems to work:
=RCHGetTableCell(
iamruf@yahoo.
>
> OK. Here is the opening URL:
>
> http://globefunddb.
> and here is the URL after clicking "Get Results" without inserting any
> Criteria:
>
> http://globefunddb.
>
>
Sat Feb 16, 2013 9:20 am (PST) . Posted by:
"Undisclosed" iamruf
Hi Randy,
I have placed this URL in cell C2 (the generation of "Get Results" Fund/Company AGF)
http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
cell D4 = 10
cell B5 = 50
cell C7 = RCHGetTableCell($C$2,D$4,">Price $",,,,$B5,"
rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, February 16, 2013 11:40 AM
Subject: Re: [smf_addin] CDN Mutual Fund Prices
It appears possible, but non-trivial.
First off, the "Results" URL only appears viable after a manual visit to the site and generation of "Get Results". Otherwise, it's not a bookmarkable URL.
And the table coding is an issue for RCHGetHTMLTable().
But this general format formula seems to work:
=RCHGetTableCell($C$2,D$4,">Price $",,,,$B5,"
iamruf@yahoo.com > wrote:
>
>OK. Here is the opening URL:
>http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_filter?pi_type=B
>
>and here is the URL after clicking "Get Results" without inserting any Criteria:
>http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
>
>
I have placed this URL in cell C2 (the generation of "Get Results" Fund/Company AGF)
http://globefunddb.
cell D4 = 10
cell B5 = 50
cell C7 = RCHGetTableCell(
rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, February 16, 2013 11:40 AM
Subject: Re: [smf_addin] CDN Mutual Fund Prices
It appears possible, but non-trivial.
First off, the "Results" URL only appears viable after a manual visit to the site and generation of "Get Results"
And the table coding is an issue for RCHGetHTMLTable(
But this general format formula seems to work:
=RCHGetTableCell(
iamruf@yahoo.
>
>OK. Here is the opening URL:
>http://globefunddb.
>
>and here is the URL after clicking "Get Results" without inserting any Criteria:
>http://globefunddb.
>
>
Sat Feb 16, 2013 9:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Did you generate the "Get Results" in the EXCEL Web Query process (or IE)
first?
Try that URL in the smfGetTagContent-Quick-Webpage-Examination.xls workbook
and see what kinds of "table" and "tr" tags you can find. For example:
*Web Page:*
http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
*HTML Tag:* table *Start String:* * * *Count* *Tag Contents*
1Fund Report… 2 WIDTH="100%" BORDER="0" CELLPADDING=
iamruf@yahoo.com > wrote:
> I have placed this URL in cell C2 (the generation of "Get Results"
> Fund/Company AGF)
>
> http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?pi_report_option=&pi_show_criteria_yn=Y&pi_report_tab=159&rep_type=STD&iaction=fundFilter
> cell D4 = 10
> cell B5 = 50
> cell C7 = RCHGetTableCell($C$2,D$4,">Price $",,,,$B5,"
which returns Error
> What am I doing wrong??
>
first?
Try that URL in the smfGetTagContent-
and see what kinds of "table" and "tr" tags you can find. For example:
*Web Page:*
http://globefunddb.
*HTML Tag:* table *Start String:* * * *Count* *Tag Contents*
1
| Search Criteria: | 5 >Sort Order: Fund Name ASC FACE="ARIAL, HELVETICA"> … 8 | > name="iaction" value="Update Fundlist">td> | Result Page:1 | | |||||||||||
> I have placed this URL in cell C2 (the generation of "Get Results"
> Fund/Company AGF)
>
> http://globefunddb.
> cell D4 = 10
> cell B5 = 50
> cell C7 = RCHGetTableCell(
which returns Error
> What am I doing wrong??
>
Sat Feb 16, 2013 7:08 pm (PST) . Posted by:
"almondtree" almondtree
I got a compile error:can't find project or library, I got a couple of .jpg's I could send, but how do I do this. I had just loaded SMF Functions 2.1.2013.02.12 zip into SMF addin. Even restarted computer same problem. I noticed in .xla 474kb , so I upgated this file to an old file from 1-4-2013. .xla 534kb.. Everything works now.
Sat Feb 16, 2013 7:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Rather than JPGs, can you just tell me which project or library is missing?
On Sat, Feb 16, 2013 at 8:08 PM, almondtree almondtree@yahoo.com > wrote:
> I got a compile error:can't find project or library, I got a couple of
> .jpg's I could send, but how do I do this. I had just loaded SMF Functions
> 2.1.2013.02.12 zip into SMF addin. Even restarted computer same problem. I
> noticed in .xla 474kb , so I upgated this file to an old file from
> 1-4-2013. .xla 534kb.. Everything works now.
>
On Sat, Feb 16, 2013 at 8:08 PM, almondtree almondtree@yahoo.
> I got a compile error:can'
> .jpg's I could send, but how do I do this. I had just loaded SMF Functions
> 2.1.2013.02.
> noticed in .xla 474kb , so I upgated this file to an old file from
> 1-4-2013. .xla 534kb.. Everything works now.
>
Sun Feb 17, 2013 4:33 am (PST) . Posted by:
"Mat Aka" mataka57
When I want for example 'Total Liabilities&#
=rchgetelementnumbe
How do I get the right number?
Thnx
Sun Feb 17, 2013 4:47 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Ummm. Maybe wait until the 2012 financial results are announced, and then
updated online? I'm not privy to their update schedules.
On Sun, Feb 17, 2013 at 3:12 AM, Mat Aka mataka57@yahoo.com > wrote:
>
> When I want for example 'Total Liabilities' of XOM of 2012 I type in:
>
> =rchgetelementnumber("XOM";;3782). The answer is 176,656.00 . But this
> number is from 2011.
>
> How do I get the right number?
>
updated online? I'm not privy to their update schedules.
On Sun, Feb 17, 2013 at 3:12 AM, Mat Aka mataka57@yahoo.
>
> When I want for example 'Total Liabilities&#
>
> =rchgetelementnumbe
> number is from 2011.
>
> How do I get the right number?
>
Tidak ada komentar:
Posting Komentar