7 New Messages
Digest #2903
2b
Re: SMF-Template-Zacks-Earnings-Announcements.xls from work in progr by "Randy Harmelink" rharmelink
Messages
Sun Dec 22, 2013 8:46 am (PST) . Posted by:
raniersfury
I pulled down the new .zip file and replaced the versions under Program Files, but didn't seem to have any luck - highly likely I did not do this correctly.
Is it still possible to retrieve the high and low PE via RCHGetElementNumber, or due to the AdvFN website changes, do you now have to retrieve it with the RCHGetHTMLTable (using the 15yr workbook)?
When I try the RCHGetElementNumber 7156-7165 and 7166-7175, it returns "Error".
I can't seem to figure out the "code" to retrieve this info via RCHGetTableCell. I think the below is a start (the C1 reference pulls NYSE or NASDAQ), but I can't figure out how to "code" the rest of the string to pull High and Low PE from the site.
=RCHGetTableCell("http://www.advfn.com/exchanges/"&C1&"/"&Ticker&"/financials?btn=start_date&start_date=10&mode=annual_reports")
Is it still possible to retrieve the high and low PE via RCHGetElementNumber
When I try the RCHGetElementNumber 7156-7165 and 7166-7175, it returns "Error"
I can't seem to figure out the "code" to retrieve this info via RCHGetTableCell. I think the below is a start (the C1 reference pulls NYSE or NASDAQ), but I can't figure out how to "code" the rest of the string to pull High and Low PE from the site.
=RCHGetTableCell(
Sun Dec 22, 2013 10:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You don't know what to code for the "start_date" parameter of the URL
either. That's the main problem with AdvFN. The paging is based on the
oldest date of the equity, not on the most recent date. So a fixed
"start_date" will only work for companies that have the full range of data
provided by AdvFN. Anything with less will give you a range of data you
probably don't want.
In any case, the other parameters would look something like:
=RCHGetTableCell("http://www.advfn.com/exchanges/"&C1&"/"&Ticker&"/financials?btn=start_date&start_date=10&mode=annual_reports",1,">High
PE Ratio")
In the case of ticker "MMM", varying the 1 above from 1 to 5 will get you
the high PE ratios of 2003 thru 2007.
If you change the "start_date" to 15, the 1 thru 5 values would get you
2008 thru 2012.
However, with a different ticker symbol, you might get different fiscal
years for those two "start_date" values. That's the whole reason I had to
write a special routine for AdvFN -- the location of data varies based on
the amount of history carried by AdvFN. So fixed values in
RCHGetTableCell() functions don't do the trick.
PS: I'm assuming (hoping) you exited EXCEL before replacing the older
add-in version with the newer one?
On Sun, Dec 22, 2013 at 9:46 AM, <cburkhalterjr@yahoo.com> wrote:
>
> I pulled down the new .zip file and replaced the versions under Program
> Files, but didn't seem to have any luck - highly likely I did not do this
> correctly.
>
> Is it still possible to retrieve the high and low PE via
> RCHGetElementNumber, or due to the AdvFN website changes, do you now have
> to retrieve it with the RCHGetHTMLTable (using the 15yr workbook)?
>
> When I try the RCHGetElementNumber 7156-7165 and 7166-7175, it returns
> "Error".
>
> I can't seem to figure out the "code" to retrieve this info via
> RCHGetTableCell. I think the below is a start (the C1 reference pulls NYSE
> or NASDAQ), but I can't figure out how to "code" the rest of the string to
> pull High and Low PE from the site.
>
> =RCHGetTableCell("http://www.advfn.com/exchanges/
> "&C1&"/"&Ticker&"/financials?btn=start_date&start_date=10&mode=annual_reports")
>
either. That's the main problem with AdvFN. The paging is based on the
oldest date of the equity, not on the most recent date. So a fixed
"start_
provided by AdvFN. Anything with less will give you a range of data you
probably don't want.
In any case, the other parameters would look something like:
=RCHGetTableCell(
PE Ratio")
In the case of ticker "MMM"
the high PE ratios of 2003 thru 2007.
If you change the "start_
2008 thru 2012.
However, with a different ticker symbol, you might get different fiscal
years for those two "start_
write a special routine for AdvFN -- the location of data varies based on
the amount of history carried by AdvFN. So fixed values in
RCHGetTableCell(
PS: I'm assuming (hoping) you exited EXCEL before replacing the older
add-in version with the newer one?
On Sun, Dec 22, 2013 at 9:46 AM, <cburkhalterjr@
>
> I pulled down the new .zip file and replaced the versions under Program
> Files, but didn't seem to have any luck - highly likely I did not do this
> correctly.
>
> Is it still possible to retrieve the high and low PE via
> RCHGetElementNumber
> to retrieve it with the RCHGetHTMLTable (using the 15yr workbook)?
>
> When I try the RCHGetElementNumber 7156-7165 and 7166-7175, it returns
> "Error"
>
> I can't seem to figure out the "code" to retrieve this info via
> RCHGetTableCell. I think the below is a start (the C1 reference pulls NYSE
> or NASDAQ), but I can't figure out how to "code" the rest of the string to
> pull High and Low PE from the site.
>
> =RCHGetTableCell(
> "&C1&"
>
Sun Dec 22, 2013 10:19 pm (PST) . Posted by:
raniersfury
Randy - Thanks, I'm now able to pull the info using the string you posted. Even though the Start Date complicates things a little, I can generally spot when it gets out of sorts.
Appreciate the help and quick responses. This is a great forum for novice investors to try to become a better investor, so thanks for setting it up.
Appreciate the help and quick responses. This is a great forum for novice investors to try to become a better investor, so thanks for setting it up.
Sun Dec 22, 2013 1:41 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy, what EXCEL version are you using?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, December 20, 2013 5:10:08 PM
Subject: Re: [smf_addin] SMF-Template-Zacks-Earnings-Announcements.xls from work in progress folder
That means it's an EXCEL 2003 limitation that is causing the problem...
On Fri, Dec 20, 2013 at 2:27 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>With 254, it works. When I change to 1023 I get #VALUE! returned.
>
>
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, December 20, 2013 5:10:08 PM
Subject: Re: [smf_addin] SMF-Template-
That means it's an EXCEL 2003 limitation that is causing the problem...
On Fri, Dec 20, 2013 at 2:27 PM, Jacob Jose <pepecan47@yahoo.
>
>With 254, it works. When I change to 1023 I get #VALUE! returned.
>
>
Sun Dec 22, 2013 1:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
EXCEL 2007.
On Sun, Dec 22, 2013 at 2:41 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Hi Randy, what EXCEL version are you using?
>
On Sun, Dec 22, 2013 at 2:41 PM, Jacob Jose <pepecan47@yahoo.
>
> Hi Randy, what EXCEL version are you using?
>
Sun Dec 22, 2013 2:05 pm (PST) . Posted by:
amitc@ymail.com
Hello Randy,
My current version I would guess you mean 2013-01-04 version. Thanks for the smfGetOptionExpiry tip, that would explain.
About smfGet888OptionQuote too.
It would be good to move both the tip to the documentation page when the 2013 add-in version is marked as stable.
Regards
Amit
My current version I would guess you mean 2013-01-04 version. Thanks for the smfGetOptionExpiry tip, that would explain.
About smfGet888OptionQuot
It would be good to move both the tip to the documentation page when the 2013 add-in version is marked as stable.
Regards
Amit
Sun Dec 22, 2013 3:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There already is a mention in the function documentation about the security
cookie...
But I will need to update the expiration date section of all of the
functions.
On Sun, Dec 22, 2013 at 3:05 PM, <ac11@rajgad.com> wrote:
> About smfGet888OptionQuote too.
>
> It would be good to move both the tip to the documentation page when the
> 2013 add-in version is marked as stable.
>
cookie...
But I will need to update the expiration date section of all of the
functions.
On Sun, Dec 22, 2013 at 3:05 PM, <ac11@rajgad.
> About smfGet888OptionQuot
>
> It would be good to move both the tip to the documentation page when the
> 2013 add-in version is marked as stable.
>
Tidak ada komentar:
Posting Komentar