7 New Messages
Digest #2568
Messages
Sun Mar 31, 2013 8:13 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, any chance you might add the code to put the Element name in the cells in row 3?
Notice the 3518 column has a name of Trailing P/E and 3519 is blank.
This is because the previous use of the spreadsheet had those values.
This next one you may not be able to do but I thought I'd ask it anyway.
Also, any chance you can set the cells starting in row 4 and below to the proper format?
Notice the 3519 column which is Dividends per Share and it is a dollar value but it shown as a percentage.
I know I can manually set the format but it would be so much better to do it program wise.
Happy Easter Everyone,
Kermit
<=== Enter ticker symbols here and element definitions above and then press Ctrl-Shift-J to update table
941
942
3518
3519
353
Ticker
Market
Cap
Enterprise
Value
Trailing
P/E
Analyst Consensus
AB
$2,300,000
$2,300,000
1.23
114.00%
Hold
AGD
Error
Error
Error
Error
NA
AGNC
$11,110,000
$85,000,000
5
560.00%
Moderate Buy
AI
$338,500
$335,260
3.5
338.00%
Moderate Buy
AINV
1700000
2690000
1.04
112.00%
Hold
AMTG
539570
4070000
3.4
30.00%
Hold
anh
904740
9100000
0.69
94.00%
Moderate Buy
AOD
Error
Error
Error
Error
NA
APO
2860000
12810000
1.35
68.00%
Moderate Buy
ARCC
Error
Error
1.6
141.00%
Moderate Buy
ARI
493290
603390
1.6
160.00%
Moderate Buy
ARR
2020000
19800000
1.2
141.00%
Hold
Sun Mar 31, 2013 12:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Sun, Mar 31, 2013 at 8:13 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> *Randy, any chance you might add the code to put the Element name in the
> cells in row 3?*
>
> *Notice the 3518 column has a name of Trailing P/E and 3519 is blank.*
>
> *This is because the previous use of the spreadsheet had those values.*
>
Not really, because in general there is no way for the add-in to be able to
tell what is in those columns. Except when element numbers are used. For my
own usage, I almost never use element numbers for the column definition,
creating my own formulas instead.
If you want, you can use something like:
=RCHGetElementNumber("Element",C2)
...for when they do come from element numbers, if that is your primary
usage. I too often found those to be too long to be useful in such
headings, and preferred setting my own.
*
*
> *Also, any chance you can set the cells starting in row 4 and below to
> the proper format?*
>
> *Notice the 3519 column which is Dividends per Share and it is a dollar
> value but it shown as a percentage.*
>
> *I know I can manually set the format but it would be so much better to
> do it program wise. *
>
How would it know what format to set? Suppose a value of 1.39 is returned.
Is that $1.39 of EPS, 139% of something, or something like a Debt-to-Equity
ratio?
Even the element numbers don't have anything stored that would tell it what
format to use.
<kermitp@tampabay.
>
> *Randy, any chance you might add the code to put the Element name in the
> cells in row 3?*
>
> *Notice the 3518 column has a name of Trailing P/E and 3519 is blank.*
>
> *This is because the previous use of the spreadsheet had those values.*
>
Not really, because in general there is no way for the add-in to be able to
tell what is in those columns. Except when element numbers are used. For my
own usage, I almost never use element numbers for the column definition,
creating my own formulas instead.
If you want, you can use something like:
=RCHGetElementNumbe
...for when they do come from element numbers, if that is your primary
usage. I too often found those to be too long to be useful in such
headings, and preferred setting my own.
*
*
> *Also, any chance you can set the cells starting in row 4 and below to
> the proper format?*
>
> *Notice the 3519 column which is Dividends per Share and it is a dollar
> value but it shown as a percentage.*
>
> *I know I can manually set the format but it would be so much better to
> do it program wise. *
>
How would it know what format to set? Suppose a value of 1.39 is returned.
Is that $1.39 of EPS, 139% of something, or something like a Debt-to-Equity
ratio?
Even the element numbers don't have anything stored that would tell it what
format to use.
Sun Mar 31, 2013 10:10 am (PDT) . Posted by:
"foolishblisterbutt" foolishblisterbutt
Hi,
It's not a database, but it's an excel sheet that pulls a lot of data. It's true what you say, that I shouldn't overburden the server and that's why I put it at manual calculation. I only expect to pull the data once a month.
I programmed my own routine, so it works for me now :-)
Thanks for your help :-)
Best regards,
Frederik
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I notice both your ticker symbols start with "AA...".
>
> You're not loading some type of database of stocks, are you?
>
> The add-in is only designed for ad hoc data retrieval and has a limit of
> 1000 web pages per session. I feel it's unfair to burden the free data
> sources with excessive data requests, especially since they could easily
> redesign their web pages to prevent the add-in from retrieving data. If
> someone needs that level of data, they should be subscribing to some type
> of data service.
>
> Portfolio123.com is an excellent "point in time" backtester and screener
> with thousands of data elements, including financial statement items. AAII
> has a less expensive Stock Investor Pro product.
>
> On Fri, Mar 29, 2013 at 11:53 PM, foolishblisterbutt <fgschack@...>wrote:
>
> >
> > It actually works when I only use a few symbols, so the problem is
> > probably the amount of lookups that I do, they might block you if you make
> > too many requests.
> >
>
It's not a database, but it's an excel sheet that pulls a lot of data. It's true what you say, that I shouldn'
I programmed my own routine, so it works for me now :-)
Thanks for your help :-)
Best regards,
Frederik
--- In smf_addin@yahoogrou
>
> I notice both your ticker symbols start with "AA..."
>
> You're not loading some type of database of stocks, are you?
>
> The add-in is only designed for ad hoc data retrieval and has a limit of
> 1000 web pages per session. I feel it's unfair to burden the free data
> sources with excessive data requests, especially since they could easily
> redesign their web pages to prevent the add-in from retrieving data. If
> someone needs that level of data, they should be subscribing to some type
> of data service.
>
> Portfolio123.
> with thousands of data elements, including financial statement items. AAII
> has a less expensive Stock Investor Pro product.
>
> On Fri, Mar 29, 2013 at 11:53 PM, foolishblisterbutt <fgschack@
>
> >
> > It actually works when I only use a few symbols, so the problem is
> > probably the amount of lookups that I do, they might block you if you make
> > too many requests.
> >
>
Sun Mar 31, 2013 12:41 pm (PDT) . Posted by:
"Sean" mighty.quaker
I have been pulling data from Bloomberg.com for about 18 months using this command. Here's an example:
smfGetTagContent("http://www.bloomberg.com/quote/rty:ind ","span",29)
However, it does not seem to work anymore. My Windows and Excel version have not changed.
From time to time, it will return the Value# message in the cell. In the past, I've had to alter the Span number (ie change 29 to 28 or 27) and that did the trick. That does not seem to work this time. I'm not sure how to fix it this time. Any help is appreciated.
Sean
smfGetTagContent(
However, it does not seem to work anymore. My Windows and Excel version have not changed.
From time to time, it will return the Value# message in the cell. In the past, I've had to alter the Span number (ie change 29 to 28 or 27) and that did the trick. That does not seem to work this time. I'm not sure how to fix it this time. Any help is appreciated.
Sean
Sun Mar 31, 2013 12:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When you don't use search strings to position yourself, you leave your
extraction vulnerable to any change they might make to the web page. For
example, if all they do is insert a little advertisement code that contains
a span tag, your count of 29 will be off. And that advertisement code might
change with every refresh of the web page.
How about something like:
=smfGetTagContent("http://www.bloomberg.com/quote/rty:ind
","span",-2,"trending_")
On Sun, Mar 31, 2013 at 4:59 AM, Sean <Sean.McLaughlin@cnl.com > wrote:
> I have been pulling data from Bloomberg.com for about 18 months using this
> command. Here's an example:
>
> smfGetTagContent("http://www.bloomberg.com/quote/rty:ind ","span",29)
>
> However, it does not seem to work anymore. My Windows and Excel version
> have not changed.
>
> From time to time, it will return the Value# message in the cell. In the
> past, I've had to alter the Span number (ie change 29 to 28 or 27) and that
> did the trick. That does not seem to work this time. I'm not sure how to
> fix it this time. Any help is appreciated.
>
>
extraction vulnerable to any change they might make to the web page. For
example, if all they do is insert a little advertisement code that contains
a span tag, your count of 29 will be off. And that advertisement code might
change with every refresh of the web page.
How about something like:
=smfGetTagContent(
","
On Sun, Mar 31, 2013 at 4:59 AM, Sean <Sean.McLaughlin@
> I have been pulling data from Bloomberg.com for about 18 months using this
> command. Here's an example:
>
> smfGetTagContent(
>
> However, it does not seem to work anymore. My Windows and Excel version
> have not changed.
>
> From time to time, it will return the Value# message in the cell. In the
> past, I've had to alter the Span number (ie change 29 to 28 or 27) and that
> did the trick. That does not seem to work this time. I'm not sure how to
> fix it this time. Any help is appreciated.
>
>
Sun Mar 31, 2013 11:43 pm (PDT) . Posted by:
"haltonbrat96" haltonbrat96
Is there an "Element Listing" for YAHOO and/or other data sources which can be used in RCHGetElementNumber for instance.
Also, is it possible to get a 10 year history similar to the 5 year history I an currently using.
Peter J Cresswell
Also, is it possible to get a 10 year history similar to the 5 year history I an currently using.
Peter J Cresswell
Sun Mar 31, 2013 11:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The definition of all the element numbers is in the XLS file distributed
with the ZIP archives.
I have no idea what 5 year history you are using.
AdvFN is the typical source if a lot of historical financial statements
data is desired.
On Sun, Mar 31, 2013 at 11:43 PM, haltonbrat96 <haltonbrat96@yahoo.com.au >wrote:
> Is there an "Element Listing" for YAHOO and/or other data sources which
> can be used in RCHGetElementNumber for instance.
>
> Also, is it possible to get a 10 year history similar to the 5 year
> history I an currently using.
>
with the ZIP archives.
I have no idea what 5 year history you are using.
AdvFN is the typical source if a lot of historical financial statements
data is desired.
On Sun, Mar 31, 2013 at 11:43 PM, haltonbrat96 <haltonbrat96@
> Is there an "Element Listing" for YAHOO and/or other data sources which
> can be used in RCHGetElementNumber for instance.
>
> Also, is it possible to get a 10 year history similar to the 5 year
> history I an currently using.
>
Tidak ada komentar:
Posting Komentar