15 New Messages
Digest #2564
2a
Re: How to control addin's updating information at initial open or d by "Kermit W. Prather" kermitpra
2b
Re: How to control addin's updating information at initial open or d by "Randy Harmelink" rharmelink
Messages
Fri Mar 29, 2013 3:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's not a correct version number. What do you get for:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM";,25)
=smfGetAParms(25)
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM ",1,"Last
Price")
On Fri, Mar 29, 2013 at 12:03 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> The latest version that I had was 2.1.2012 and that's the one that causes
> Me proble
>
> Does the latest version that u refer is in the work In progress file?
>
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetTableCell(
http://investing.
Price")
On Fri, Mar 29, 2013 at 12:03 AM, weekeewawa <weekeewawa@yahoo.
>
> The latest version that I had was 2.1.2012 and that's the one that causes
> Me proble
>
> Does the latest version that u refer is in the work In progress file?
>
Fri Mar 29, 2013 5:36 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
this is what i got
1) Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add In; 1)
2) 105.29
3) MSN;Last Price;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0
4)105.29
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's not a correct version number. What do you get for:
>
> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("MMM";,25)
> =smfGetAParms(25)
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM ",1,"Last
> Price")
>
> On Fri, Mar 29, 2013 at 12:03 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > The latest version that I had was 2.1.2012 and that's the one that causes
> > Me proble
> >
> > Does the latest version that u refer is in the work In progress file?
> >
>
this is what i got
1) Stock Market Functions add-in, Version 2.1.2012.12.
2) 105.29
3) MSN;Last Price;http://investing.
4)105.29
--- In smf_addin@yahoogrou
>
> That's not a correct version number. What do you get for:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =smfGetAParms(
> =RCHGetTableCell(
> http://investing.
> Price")
>
> On Fri, Mar 29, 2013 at 12:03 AM, weekeewawa <weekeewawa@
>
> >
> > The latest version that I had was 2.1.2012 and that's the one that causes
> > Me proble
> >
> > Does the latest version that u refer is in the work In progress file?
> >
>
Fri Mar 29, 2013 8:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like everything is working fine...
On Fri, Mar 29, 2013 at 5:36 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy
> this is what i got
>
> 1) Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program
> Files\SMF Add In; 1)
>
> 2) 105.29
>
> 3) MSN;Last Price;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
>
> 4)105.29
>
On Fri, Mar 29, 2013 at 5:36 AM, weekeewawa <weekeewawa@yahoo.
> hello randy
> this is what i got
>
> 1) Stock Market Functions add-in, Version 2.1.2012.12.
> Files\SMF Add In; 1)
>
> 2) 105.29
>
> 3) MSN;Last Price;
> http://investing.
>
> 4)105.29
>
Fri Mar 29, 2013 6:23 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Yes, that was the one I was referring to. However, it really isn't what I want to do.
If I am reading this correctly, this solution means I have to the =IF($A$1<>"Y","--",RCHGetElementNumber(....)) in every cell.
I have a multi-worksheet workbook and I'd like to control when each worksheet refreshes. Plus, I'd like nothing to refresh when I initially open the workbook.
I guess it may not be possible but I'd like Cell A1 of each worksheet to control the addin running or not running.
Can you think of a way I can control the addin execution?
Thanks, really appreciate all you do for us, less skilled users
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, March 28, 2013 9:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] How to control addin's updating information at initial open or during testing
Is this the one you're looking for?
http://finance.groups.yahoo.com/group/smf_addin/message/21417
For things that I want to see open as they were on the previous use, I'm tending to modify my regular function usage to be smfUpdateDownloadTable.
On Thu, Mar 28, 2013 at 3:27 PM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Randy, I know I saw a message awhile back on controlling the addin updating elements start initial open. But I can't find it in the messages.
Can you point me to the message and how to find it in the future?
I would, also, like to control the addin from retrieving the information from the webpage during testing until I am ready to test.
Anyway to do both?
If I am reading this correctly, this solution means I have to the =IF($A$1<
I have a multi-worksheet workbook and I'd like to control when each worksheet refreshes. Plus, I'd like nothing to refresh when I initially open the workbook.
I guess it may not be possible but I'd like Cell A1 of each worksheet to control the addin running or not running.
Can you think of a way I can control the addin execution?
Thanks, really appreciate all you do for us, less skilled users
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, March 28, 2013 9:32 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] How to control addin's updating information at initial open or during testing
Is this the one you're looking for?
http://finance.
For things that I want to see open as they were on the previous use, I'm tending to modify my regular function usage to be smfUpdateDownloadTa
On Thu, Mar 28, 2013 at 3:27 PM, Kermit W. Prather <kermitp@tampabay.
Randy, I know I saw a message awhile back on controlling the addin updating elements start initial open. But I can't find it in the messages.
Can you point me to the message and how to find it in the future?
I would, also, like to control the addin from retrieving the information from the webpage during testing until I am ready to test.
Anyway to do both?
Fri Mar 29, 2013 8:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can refer to the same A1 cell in all worksheets...but in the other
worksheets, it might look something like:
=IF(Sheet1!$A$1<>"Y","--",RCHGetElementNumber(....))
Or, just give the cell a name, and they'll all be the same, as long as the
name has a scope of the workbook:
=IF(rTrigger<>"Y","--",RCHGetElementNumber(....))
But you do need to set the sell to something other than "Y" when you save
it.
And it's not controlling whether something "refreshes", just what is being
calculated when you open the workbook.
On Fri, Mar 29, 2013 at 6:23 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Yes, that was the one I was referring to. However, it really isn't what I
> want to do. ****
>
> ** **
>
> If I am reading this correctly, this solution means I have to the
> =IF($A$1<>"Y","--",RCHGetElementNumber(....)) in every cell.****
>
> ** **
>
> I have a multi-worksheet workbook and I'd like to control when each
> worksheet refreshes. Plus, I'd like nothing to refresh when I initially
> open the workbook. ****
>
> ** **
>
> I guess it may not be possible but I'd like Cell A1 of each worksheet to
> control the addin running or not running.****
>
> ** **
>
> Can you think of a way I can control the addin execution?****
>
> ** **
>
> Thanks, really appreciate all you do for us, less skilled users****
>
>
>
worksheets, it might look something like:
=IF(Sheet1!$
Or, just give the cell a name, and they'll all be the same, as long as the
name has a scope of the workbook:
=IF(rTrigger<
But you do need to set the sell to something other than "Y" when you save
it.
And it's not controlling whether something "refreshes&quo
calculated when you open the workbook.
On Fri, Mar 29, 2013 at 6:23 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Yes, that was the one I was referring to. However, it really isn't what I
> want to do. ****
>
> ** **
>
> If I am reading this correctly, this solution means I have to the
> =IF($A$1<
>
> ** **
>
> I have a multi-worksheet workbook and I'd like to control when each
> worksheet refreshes. Plus, I'd like nothing to refresh when I initially
> open the workbook. ****
>
> ** **
>
> I guess it may not be possible but I'd like Cell A1 of each worksheet to
> control the addin running or not running.****
>
> ** **
>
> Can you think of a way I can control the addin execution?**
>
> ** **
>
> Thanks, really appreciate all you do for us, less skilled users****
>
>
>
Fri Mar 29, 2013 8:56 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I have the last 20 Dividends issues and I want to count the number of time the dividend increased and the number times the dividend decreased and then total them.
I can't seem to figure out and easy way to do it. You can see below the result are vastly different depending on the stock
AGNC is much more consistent in Dividend Payouts.
I can do it this way but seems like there should be an Excel function to do it easier
I'd appreciate any suggestions to make it simpler.
Kermit
Symbol
PT
$0.57
$0.28
$1.87
$0.77
$0.77
$0.90
$2.53
$0.64
$0.60
$0.45
$0.26
$0.17
$0.09
$0.01
$0.16
$0.05
$0.00
$0.21
$0.19
$0.04
Increases
13
1
0
1
0
0
0
1
1
1
1
1
1
1
0
1
1
0
1
1
Decreases
5
0
1
0
0
1
1
0
0
0
0
0
0
0
1
0
0
1
0
0
Symbol
AGNC
$1.25
$1.25
$1.25
$1.25
$1.25
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.50
$0.85
$1.20
$1.00
$0.31
Increases
3
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
1
Decreases
3
0
0
0
0
1
0
0
0
0
0
0
0
0
0
1
0
1
0
0
I can't seem to figure out and easy way to do it. You can see below the result are vastly different depending on the stock
AGNC is much more consistent in Dividend Payouts.
I can do it this way but seems like there should be an Excel function to do it easier
I'd appreciate any suggestions to make it simpler.
Kermit
Symbol
PT
$0.57
$0.28
$1.87
$0.77
$0.77
$0.90
$2.53
$0.64
$0.60
$0.45
$0.26
$0.17
$0.09
$0.01
$0.16
$0.05
$0.00
$0.21
$0.19
$0.04
Increases
13
1
0
1
0
0
0
1
1
1
1
1
1
1
0
1
1
0
1
1
Decreases
5
0
1
0
0
1
1
0
0
0
0
0
0
0
1
0
0
1
0
0
Symbol
AGNC
$1.25
$1.25
$1.25
$1.25
$1.25
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.40
$1.50
$0.85
$1.20
$1.00
$0.31
Increases
3
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
1
Decreases
3
0
0
0
0
1
0
0
0
0
0
0
0
0
0
1
0
1
0
0
Fri Mar 29, 2013 6:41 am (PDT) . Posted by:
"Subu S" mail_to_subu
--- In smf_addin@yahoogrou
>
> I think you want to do something along the lines of an
> smfUpdateDownloadTa
> instead of using
> formulas that recalculate.
Randy
You are the rock star !! You got my question absolutely right !! though I had written it in a clumsy fashion
More detailed reply below :
============
Thanks Kermit & Randy
Appreciate your concern , quick reply
Sorry the links did not work . As Randy mentioned they are temp links ... I understand that now .... Here I go again
1. A short Summary of Graham's methods : http://wp.me/
2. A sample link of an amazing file from this group [just as an example ]
File name : SMF-Template-
@
http://finance.
2.1. so the data I am looking for is somewhere there !
3. What am I looking for : Sample sp sheet here
https://docs.
short link for sp sheet : http://tinyurl.
4. yes. I can see the elements amoung the 1000s that Randy has been kind enough to give. But I've forgotten how to permanently download the data to a sp sheet rather than update them every time the sp sheet is opened ...
Now that Randy has given the right name / hint, I'll search and figure that out possibly
regards
Subu
--- In smf_addin@yahoogrou
>
> Subu, neither of your links worked. Can you try again?
>
> As for the information you are looking for I suggest you open the element
> definition file of the addin and search for the elements
> Such as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
> more
>
> I'm pretty sure all the information has an element in the 14,000 plus
> definitions.
>
> Let us know if you need help in how to evaulaute the information. I,
> personally, don't know Graham's method but might be willing to learn
> something new to me.
>
> Good luck,
>
> Kermit
>
<........
> But the number of data items you're asking for
> would be a tough spreadsheet
> to fill.
>
> And I'm not sure what the purpose of the workbook would be.
> It sounds like
> you need a screening tool, not something like the add-in.
>
> By the way, the "f1.grp.
> temporary ones, so your
> links don't work...
>
> On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_
>
> > Dear Randy and others
> >
> >
> > Good day to you
> >
> > Hope all's well here ...it's been some time since I visited this board
> > [i'm sure my absence must have been a relief :-) ]
> >
> > I have a request and 'am hoping that there *already* exists a solution so
> > that I trouble Randy *very little *
> >
> >
> > What am I looking for :
> > ------------
> > * As most of you know Benjamin Graham the guru of value investing
> > advocated buying great value stocks cheap or say at a discount to value.
> >
> > * He had a few screens to decide on "value" and then couple of formulate
> > to decide cheap / not so cheap
> >
> > * I wish to download this data [as advised by Graham] once in say 3 months
> > or so & extract them to a worksheet ... NOT update every time the sp sheet
> > opens, but one time download and save [and the rest of working I should be
> > able to do on the WS ]
> >
> > * I visited the files section of this group thinking that there should be
> > a ready made XL file that already provided graham #s
> >
> > * I could NOT find it
> >
> > * I found this 10 year XL sheet http://bit.ly/
> > to say the least , but I am looking at a list with the ticker on the left
> > extreme column and data on the rest of the columns ...something like this
> > sheet http://bit.ly/
> > something to download the data, NOT update every time
> >
> > Request :
> > ------------
> > Could I request Randy and others to help me with getting the following
> > data of listed stocks in a table . Ticker on left extreme column, rest on
> > the columns to the right , one time download every three months
> >
> > Better still, to avoid hitting servers often IF there is some data that is
> > say within 1 month old, please mail / post the same and I'll use it
> >
> >
> > Specifics about "..What am I looking for.." /
> > and what did Benjamin Graham say
> > ------------
> >
> > For each item I have listed what I am looking for followed byBenjamin
> > Graham's distilled wisdom
> >
> >
> > 1. What am I looking for = Market Cap
> >
> > Ben Graham = "Adequate"
> > "vicissitudes&
> > those days, In my XL sheet I plan to inflate it to accommodate the money
> > printing ]
> >
> >
> > 2. What am I looking for = Current Ratio
> > 2.1. Value of Total Current assets [for total enterprise]
> > 2.2. Value of long term debt [for total enterprise]
> >
> > Ben Graham = Strong financial condition, measured by current ratios that
> > exceed two and net current assets that exceed long term debt;
> >
> >
> > 3. Net profit for the last 10 years
> >
> > Ben Graham = Earnings stability, measured by 10 consecutive years of
> > positive earnings;
> >
> >
> > 4. Dividends paid over the last 10 years
> >
> > Ben Graham = A dividend record of uninterrupted payments for at least 20
> > years; [Subu's note ... yeah it should be 20 years, but I guess going back
> > 20 is tough ...so I'm diluting it here ... bad ...but ok for the moment]
> >
> >
> > 5. EPS today ; EPS 10 years ago
> >
> > Ben Graham = Earnings-per-
> > ten years;
> >
> >
> > 6. PE Ratio
> >
> > Ben Graham = Moderate price-to-earnings ratios, which typically should not
> > exceed 15; and
> >
> >
> > 7. Price to book ratio
> >
> > Ben Graham = Moderate price-to-book ratios, which typically should not
> > exceed 1½.
> >
>
Fri Mar 29, 2013 6:56 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Subu, I think Randy's answer to my question maybe what you are looking for
to control updating every time you open the file.
http://finance.groups.yahoo.com/group/smf_addin/message/21417
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Subu S
Sent: Friday, March 29, 2013 9:42 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Ben Graham screen
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I think you want to do something along the lines of an
> smfUpdateDownloadTable workbook, since it grabs values instead of
> using formulas that recalculate.
Randy
You are the rock star !! You got my question absolutely right !! though I
had written it in a clumsy fashion
More detailed reply below :
==================================
Thanks Kermit & Randy
Appreciate your concern , quick reply
Sorry the links did not work . As Randy mentioned they are temp links ... I
understand that now .... Here I go again
1. A short Summary of Graham's methods : http://wp.me/p2z5O5-O
2. A sample link of an amazing file from this group [just as an example ]
File name : SMF-Template-MSN-10-Year-Summaries.xls
@
http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20Exam
ples/
2.1. so the data I am looking for is somewhere there !
3. What am I looking for : Sample sp sheet here
https://docs.google.com/spreadsheet/ccc?key=0Au4xdsZGnFNcdFVqMXFWSzhsRHJUajM
5eHlUWlFSdXc&usp=sharing
short link for sp sheet : http://tinyurl.com/ccard94
4. yes. I can see the elements amoung the 1000s that Randy has been kind
enough to give. But I've forgotten how to permanently download the data to a
sp sheet rather than update them every time the sp sheet is opened ...
Now that Randy has given the right name / hint, I'll search and figure that
out possibly
regards
Subu
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> Subu, neither of your links worked. Can you try again?
>
> As for the information you are looking for I suggest you open the
> element definition file of the addin and search for the elements Such
> as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
> more
>
> I'm pretty sure all the information has an element in the 14,000 plus
> definitions.
>
> Let us know if you need help in how to evaulaute the information. I,
> personally, don't know Graham's method but might be willing to learn
> something new to me.
>
> Good luck,
>
> Kermit
>
<.....................>
> But the number of data items you're asking for would be a tough
> spreadsheet to fill.
>
> And I'm not sure what the purpose of the workbook would be.
> It sounds like
> you need a screening tool, not something like the add-in.
>
> By the way, the "f1.grp..." URLs for files are only temporary ones, so
> your links don't work...
>
> On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_subu@...> wrote:
>
> > Dear Randy and others
> >
> >
> > Good day to you
> >
> > Hope all's well here ...it's been some time since I visited this board
> > [i'm sure my absence must have been a relief :-) ]
> >
> > I have a request and 'am hoping that there *already* exists a
> > solution so that I trouble Randy *very little *
> >
> >
> > What am I looking for :
> > --------------------------------
> > * As most of you know Benjamin Graham the guru of value investing
> > advocated buying great value stocks cheap or say at a discount to value.
> >
> > * He had a few screens to decide on "value" and then couple of
> > formulate to decide cheap / not so cheap
> >
> > * I wish to download this data [as advised by Graham] once in say 3
> > months or so & extract them to a worksheet ... NOT update every time
> > the sp sheet opens, but one time download and save [and the rest of
> > working I should be able to do on the WS ]
> >
> > * I visited the files section of this group thinking that there
> > should be a ready made XL file that already provided graham #s
> >
> > * I could NOT find it
> >
> > * I found this 10 year XL sheet http://bit.ly/11RKZzZ which is
> > fantastic to say the least , but I am looking at a list with the
> > ticker on the left extreme column and data on the rest of the
> > columns ...something like this sheet http://bit.ly/YLqGS1 ,,, JUST
> > the format like this .... BUT something to download the data, NOT
> > update every time
> >
> > Request :
> > --------------------------------
> > Could I request Randy and others to help me with getting the
> > following data of listed stocks in a table . Ticker on left extreme
> > column, rest on the columns to the right , one time download every
> > three months
> >
> > Better still, to avoid hitting servers often IF there is some data
> > that is say within 1 month old, please mail / post the same and I'll
> > use it
> >
> >
> > Specifics about "..What am I looking for.." / and what did Benjamin
> > Graham say
> > -------------------------------------------------
> >
> > For each item I have listed what I am looking for followed
> > byBenjamin Graham's distilled wisdom
> >
> >
> > 1. What am I looking for = Market Cap
> >
> > Ben Graham = "Adequate"; enterprise size, as insulation against the
> > "vicissitudes" of the economy [ Subu's note I recall he said $ 100
> > mill those days, In my XL sheet I plan to inflate it to accommodate
> > the money printing ]
> >
> >
> > 2. What am I looking for = Current Ratio
> > 2.1. Value of Total Current assets [for total enterprise]
> > 2.2. Value of long term debt [for total enterprise]
> >
> > Ben Graham = Strong financial condition, measured by current ratios
> > that exceed two and net current assets that exceed long term debt;
> >
> >
> > 3. Net profit for the last 10 years
> >
> > Ben Graham = Earnings stability, measured by 10 consecutive years of
> > positive earnings;
> >
> >
> > 4. Dividends paid over the last 10 years
> >
> > Ben Graham = A dividend record of uninterrupted payments for at
> > least 20 years; [Subu's note ... yeah it should be 20 years, but I
> > guess going back
> > 20 is tough ...so I'm diluting it here ... bad ...but ok for the
> > moment]
> >
> >
> > 5. EPS today ; EPS 10 years ago
> >
> > Ben Graham = Earnings-per-share growth of at least one-third over
> > the last ten years;
> >
> >
> > 6. PE Ratio
> >
> > Ben Graham = Moderate price-to-earnings ratios, which typically
> > should not exceed 15; and
> >
> >
> > 7. Price to book ratio
> >
> > Ben Graham = Moderate price-to-book ratios, which typically should
> > not exceed 1½.
> >
>
------------------------------------
Yahoo! Groups Links
to control updating every time you open the file.
http://finance.
-----Original Message-----
From: smf_addin@yahoogrou
Of Subu S
Sent: Friday, March 29, 2013 9:42 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Ben Graham screen
--- In smf_addin@yahoogrou
>
> I think you want to do something along the lines of an
> smfUpdateDownloadTa
> using formulas that recalculate.
Randy
You are the rock star !! You got my question absolutely right !! though I
had written it in a clumsy fashion
More detailed reply below :
============
Thanks Kermit & Randy
Appreciate your concern , quick reply
Sorry the links did not work . As Randy mentioned they are temp links ... I
understand that now .... Here I go again
1. A short Summary of Graham's methods : http://wp.me/
2. A sample link of an amazing file from this group [just as an example ]
File name : SMF-Template-
@
http://finance.
ples/
2.1. so the data I am looking for is somewhere there !
3. What am I looking for : Sample sp sheet here
https://docs.
5eHlUWlFSdXc&
short link for sp sheet : http://tinyurl.
4. yes. I can see the elements amoung the 1000s that Randy has been kind
enough to give. But I've forgotten how to permanently download the data to a
sp sheet rather than update them every time the sp sheet is opened ...
Now that Randy has given the right name / hint, I'll search and figure that
out possibly
regards
Subu
--- In smf_addin@yahoogrou
>
> Subu, neither of your links worked. Can you try again?
>
> As for the information you are looking for I suggest you open the
> element definition file of the addin and search for the elements Such
> as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
> more
>
> I'm pretty sure all the information has an element in the 14,000 plus
> definitions.
>
> Let us know if you need help in how to evaulaute the information. I,
> personally, don't know Graham's method but might be willing to learn
> something new to me.
>
> Good luck,
>
> Kermit
>
<........
> But the number of data items you're asking for would be a tough
> spreadsheet to fill.
>
> And I'm not sure what the purpose of the workbook would be.
> It sounds like
> you need a screening tool, not something like the add-in.
>
> By the way, the "f1.grp.
> your links don't work...
>
> On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_
>
> > Dear Randy and others
> >
> >
> > Good day to you
> >
> > Hope all's well here ...it's been some time since I visited this board
> > [i'm sure my absence must have been a relief :-) ]
> >
> > I have a request and 'am hoping that there *already* exists a
> > solution so that I trouble Randy *very little *
> >
> >
> > What am I looking for :
> > ------------
> > * As most of you know Benjamin Graham the guru of value investing
> > advocated buying great value stocks cheap or say at a discount to value.
> >
> > * He had a few screens to decide on "value" and then couple of
> > formulate to decide cheap / not so cheap
> >
> > * I wish to download this data [as advised by Graham] once in say 3
> > months or so & extract them to a worksheet ... NOT update every time
> > the sp sheet opens, but one time download and save [and the rest of
> > working I should be able to do on the WS ]
> >
> > * I visited the files section of this group thinking that there
> > should be a ready made XL file that already provided graham #s
> >
> > * I could NOT find it
> >
> > * I found this 10 year XL sheet http://bit.ly/
> > fantastic to say the least , but I am looking at a list with the
> > ticker on the left extreme column and data on the rest of the
> > columns ...something like this sheet http://bit.ly/
> > the format like this .... BUT something to download the data, NOT
> > update every time
> >
> > Request :
> > ------------
> > Could I request Randy and others to help me with getting the
> > following data of listed stocks in a table . Ticker on left extreme
> > column, rest on the columns to the right , one time download every
> > three months
> >
> > Better still, to avoid hitting servers often IF there is some data
> > that is say within 1 month old, please mail / post the same and I'll
> > use it
> >
> >
> > Specifics about "..What am I looking for.." / and what did Benjamin
> > Graham say
> > ------------
> >
> > For each item I have listed what I am looking for followed
> > byBenjamin Graham's distilled wisdom
> >
> >
> > 1. What am I looking for = Market Cap
> >
> > Ben Graham = "Adequate"
> > "vicissitudes&
> > mill those days, In my XL sheet I plan to inflate it to accommodate
> > the money printing ]
> >
> >
> > 2. What am I looking for = Current Ratio
> > 2.1. Value of Total Current assets [for total enterprise]
> > 2.2. Value of long term debt [for total enterprise]
> >
> > Ben Graham = Strong financial condition, measured by current ratios
> > that exceed two and net current assets that exceed long term debt;
> >
> >
> > 3. Net profit for the last 10 years
> >
> > Ben Graham = Earnings stability, measured by 10 consecutive years of
> > positive earnings;
> >
> >
> > 4. Dividends paid over the last 10 years
> >
> > Ben Graham = A dividend record of uninterrupted payments for at
> > least 20 years; [Subu's note ... yeah it should be 20 years, but I
> > guess going back
> > 20 is tough ...so I'm diluting it here ... bad ...but ok for the
> > moment]
> >
> >
> > 5. EPS today ; EPS 10 years ago
> >
> > Ben Graham = Earnings-per-
> > the last ten years;
> >
> >
> > 6. PE Ratio
> >
> > Ben Graham = Moderate price-to-earnings ratios, which typically
> > should not exceed 15; and
> >
> >
> > 7. Price to book ratio
> >
> > Ben Graham = Moderate price-to-book ratios, which typically should
> > not exceed 1½.
> >
>
------------
Yahoo! Groups Links
Fri Mar 29, 2013 7:25 am (PDT) . Posted by:
"Subu S" mail_to_subu
Thanks Kermit, Randy
I've managed to create a Sp sheet with the sample on the files section
The same is uploaded here http://tinyurl.
Further questions :
------------
1. I am unable to get the company name using element # 13862. Many Other elements are working as you can see from the sp sheet !
2. I wish to introduce some formula columns in between without any adv fn elements i.e. columns with a formulae rather than data from web. But I need to have other columns to the right of these with other Adv fn elements .... what should I put on the top row so that the extraction does not stop with the blank column
TIA
regards
Subu
--- In smf_addin@yahoogrou
>
> Subu, I think Randy's answer to my question maybe what you are looking for
> to control updating every time you open the file.
>
>
> http://finance.
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of Subu S
> Sent: Friday, March 29, 2013 9:42 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Re: Ben Graham screen
>
>
> --- In smf_addin@yahoogrou
> >
> > I think you want to do something along the lines of an
> > smfUpdateDownloadTa
> > using formulas that recalculate.
>
> Randy
>
> You are the rock star !! You got my question absolutely right !! though I
> had written it in a clumsy fashion
>
>
> More detailed reply below :
> ============
> Thanks Kermit & Randy
>
> Appreciate your concern , quick reply
>
> Sorry the links did not work . As Randy mentioned they are temp links ... I
> understand that now .... Here I go again
>
>
> 1. A short Summary of Graham's methods : http://wp.me/
>
>
> 2. A sample link of an amazing file from this group [just as an example ]
>
> File name : SMF-Template-
> @
> http://finance.
> ples/
>
> 2.1. so the data I am looking for is somewhere there !
>
>
> 3. What am I looking for : Sample sp sheet here
> https://docs.
> 5eHlUWlFSdXc&
>
> short link for sp sheet : http://tinyurl.
>
>
> 4. yes. I can see the elements amoung the 1000s that Randy has been kind
> enough to give. But I've forgotten how to permanently download the data to a
> sp sheet rather than update them every time the sp sheet is opened ...
>
> Now that Randy has given the right name / hint, I'll search and figure that
> out possibly
>
>
>
> regards
>
>
> Subu
>
>
> --- In smf_addin@yahoogrou
> >
> > Subu, neither of your links worked. Can you try again?
> >
> > As for the information you are looking for I suggest you open the
> > element definition file of the addin and search for the elements Such
> > as Current assets elements 253 - 262, 3042 - 3046, 3662 - 3667, and
> > more
> >
> > I'm pretty sure all the information has an element in the 14,000 plus
> > definitions.
> >
> > Let us know if you need help in how to evaulaute the information. I,
> > personally, don't know Graham's method but might be willing to learn
> > something new to me.
> >
> > Good luck,
> >
> > Kermit
> >
> <........
>
> > But the number of data items you're asking for would be a tough
> > spreadsheet to fill.
> >
> > And I'm not sure what the purpose of the workbook would be.
> > It sounds like
> > you need a screening tool, not something like the add-in.
> >
> > By the way, the "f1.grp.
> > your links don't work...
> >
> > On Thu, Mar 28, 2013 at 7:25 AM, Subu S <mail_to_
> >
> > > Dear Randy and others
> > >
> > >
> > > Good day to you
> > >
> > > Hope all's well here ...it's been some time since I visited this board
> > > [i'm sure my absence must have been a relief :-) ]
> > >
> > > I have a request and 'am hoping that there *already* exists a
> > > solution so that I trouble Randy *very little *
> > >
> > >
> > > What am I looking for :
> > > ------------
> > > * As most of you know Benjamin Graham the guru of value investing
> > > advocated buying great value stocks cheap or say at a discount to value.
> > >
> > > * He had a few screens to decide on "value" and then couple of
> > > formulate to decide cheap / not so cheap
> > >
> > > * I wish to download this data [as advised by Graham] once in say 3
> > > months or so & extract them to a worksheet ... NOT update every time
> > > the sp sheet opens, but one time download and save [and the rest of
> > > working I should be able to do on the WS ]
> > >
> > > * I visited the files section of this group thinking that there
> > > should be a ready made XL file that already provided graham #s
> > >
> > > * I could NOT find it
> > >
> > > * I found this 10 year XL sheet http://bit.ly/
> > > fantastic to say the least , but I am looking at a list with the
> > > ticker on the left extreme column and data on the rest of the
> > > columns ...something like this sheet http://bit.ly/
> > > the format like this .... BUT something to download the data, NOT
> > > update every time
> > >
> > > Request :
> > > ------------
> > > Could I request Randy and others to help me with getting the
> > > following data of listed stocks in a table . Ticker on left extreme
> > > column, rest on the columns to the right , one time download every
> > > three months
> > >
> > > Better still, to avoid hitting servers often IF there is some data
> > > that is say within 1 month old, please mail / post the same and I'll
> > > use it
> > >
> > >
> > > Specifics about "..What am I looking for.." / and what did Benjamin
> > > Graham say
> > > ------------
> > >
> > > For each item I have listed what I am looking for followed
> > > byBenjamin Graham's distilled wisdom
> > >
> > >
> > > 1. What am I looking for = Market Cap
> > >
> > > Ben Graham = "Adequate"
> > > "vicissitudes&
> > > mill those days, In my XL sheet I plan to inflate it to accommodate
> > > the money printing ]
> > >
> > >
> > > 2. What am I looking for = Current Ratio
> > > 2.1. Value of Total Current assets [for total enterprise]
> > > 2.2. Value of long term debt [for total enterprise]
> > >
> > > Ben Graham = Strong financial condition, measured by current ratios
> > > that exceed two and net current assets that exceed long term debt;
> > >
> > >
> > > 3. Net profit for the last 10 years
> > >
> > > Ben Graham = Earnings stability, measured by 10 consecutive years of
> > > positive earnings;
> > >
> > >
> > > 4. Dividends paid over the last 10 years
> > >
> > > Ben Graham = A dividend record of uninterrupted payments for at
> > > least 20 years; [Subu's note ... yeah it should be 20 years, but I
> > > guess going back
> > > 20 is tough ...so I'm diluting it here ... bad ...but ok for the
> > > moment]
> > >
> > >
> > > 5. EPS today ; EPS 10 years ago
> > >
> > > Ben Graham = Earnings-per-
> > > the last ten years;
> > >
> > >
> > > 6. PE Ratio
> > >
> > > Ben Graham = Moderate price-to-earnings ratios, which typically
> > > should not exceed 15; and
> > >
> > >
> > > 7. Price to book ratio
> > >
> > > Ben Graham = Moderate price-to-book ratios, which typically should
> > > not exceed 1½.
> > >
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Fri Mar 29, 2013 8:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I grabbed the smfUpdateDownloadTable-Sample.xls from the FILES area of the
group and 13862 worked fine for me. Do I recall that you have an older
version of EXCEL? If so, it may be exceeding a string limit of that version
of EXCEL.
To add your own calculation, you can put an "X" in the definition of the
column. That tells smfUpdateDownloadTable to leave the column alone.
Another options is to do something like:
~~~1~~~+~~~2~~~
...which would say to add the two previous columns together. If you do
this, you may need to make adjustments if you delete, insert, and move
columns around.
For example, I just created an smfUpdateDownloadTable worksheet that grabs
new streaming releases from NetFlix. Some of the formulas:
IF("~~~1~~~"="",0,IFERROR(0+smfStrExtr(smfGetTagContent("
http://movies.netflix.com/WiMovie/~~~1~~~ ","span",1,"ratings:"),"~"," "),3))
IF("~~~2~~~"="","--",smfGetTagContent("
http://movies.netflix.com/WiMovie/~~~2~~~ ","p",-1,"class=""synopsis"""))
The "~~~1~~~" and "~~~2~~~" refer to a column that contains a retrieved
movie ID number. My end result is something like:
*Movie ID* *Stars* *Synopsis* *Title* *Year* *Length* *Genre* 70143872 3.9 On
the eve of h… George_Gently 2007-2011 4 Series TV Shows 70229260 3.0 As
the focus of… Detropia 2012 1hr 26m Documentaries 70235124 3.7 Get to know
Way… Beauty_Is_Embarrassing 2012 1hr 28m Documentaries 70257818 3.3 Master
thief Wi… Stolen 2012 1hr 35m Action & Adventure 70267730 3.0 A group of
youn… Greystone_Park 2012 1hr 22m Horror Movies
...which I then use to create an HTML document:
<http://movies.netflix.com/WiMovie/70143872 >*George_Gently
(2007-2011)<http://movies.netflix.com/WiMovie/70143872 >
*
TV Shows, 4 Series
On the eve of his retirement, Scotland Yard Inspector George Gently decides
to pursue one final murder case, suspecting that it's the handiwork of a
gangster who's already gotten away with the murder of Gently's own wife.
<http://movies.netflix.com/WiMovie/70229260 >*Detropia
(2012)<http://movies.netflix.com/WiMovie/70229260 >
*
Documentaries, 1hr 26m
As the focus of this sobering documentary, the decline of Detroit also
reflects the nation's larger failure to keep up in a modern global economy.
The film also examines the efforts of its residents to maintain Detroit's
vibrant cultural base.
<http://movies.netflix.com/WiMovie/70235124 >*Beauty_Is_Embarrassing
(2012) <http://movies.netflix.com/WiMovie/70235124 >*
Documentaries, 1hr 28m
Get to know Wayne White, one of America's most unusual and arresting
artists, with this snappy documentary that traces the ups and downs of his
career. The jovial White discusses his art, strums the banjo, plays with
puppets and simply enjoys life. <http://movies.netflix.com/WiMovie/70257818 >
*Stolen (2012) <http://movies.netflix.com/WiMovie/70257818 >*
Action & Adventure, 1hr 35m
Master thief Will Montgomery is ready to leave his criminal past behind.
But when his daughter is kidnapped, he has no choice but to reunite with
his old partner in crime and pull off one last heist.
<http://movies.netflix.com/WiMovie/70267730 >*Greystone_Park
(2012)<http://movies.netflix.com/WiMovie/70267730 >
*
Horror Movies, 1hr 22m
A group of young filmmakers visits an abandoned psychiatric hospital to
investigate horrific rumors about patients being treated inhumanely and to
search for the ghosts of two former residents.
On Fri, Mar 29, 2013 at 7:25 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> Thanks Kermit, Randy
>
> I've managed to create a Sp sheet with the sample on the files section
>
> The same is uploaded here http://tinyurl.com/c2rekxc
>
> Further questions :
> --------------------------
> 1. I am unable to get the company name using element # 13862. Many Other
> elements are working as you can see from the sp sheet !
>
> 2. I wish to introduce some formula columns in between without any adv fn
> elements i.e. columns with a formulae rather than data from web. But I need
> to have other columns to the right of these with other Adv fn elements ....
> what should I put on the top row so that the extraction does not stop with
> the blank column
>
> TIA
>
group and 13862 worked fine for me. Do I recall that you have an older
version of EXCEL? If so, it may be exceeding a string limit of that version
of EXCEL.
To add your own calculation, you can put an "X" in the definition of the
column. That tells smfUpdateDownloadTa
Another options is to do something like:
~~~1~~~+~~~2~
...which would say to add the two previous columns together. If you do
this, you may need to make adjustments if you delete, insert, and move
columns around.
For example, I just created an smfUpdateDownloadTa
new streaming releases from NetFlix. Some of the formulas:
IF("~~~
http://movies.
IF("~~~
http://movies.
The "~~~1~~
movie ID number. My end result is something like:
*Movie ID* *Stars* *Synopsis* *Title* *Year* *Length* *Genre* 70143872 3.9 On
the eve of h… George_Gently 2007-2011 4 Series TV Shows 70229260 3.0 As
the focus of… Detropia 2012 1hr 26m Documentaries 70235124 3.7 Get to know
Way… Beauty_Is_Embarrass
thief Wi… Stolen 2012 1hr 35m Action & Adventure 70267730 3.0 A group of
youn… Greystone_Park 2012 1hr 22m Horror Movies
...which I then use to create an HTML document:
<http://movies.
(2007-2011)<http://movies.
*
TV Shows, 4 Series
On the eve of his retirement, Scotland Yard Inspector George Gently decides
to pursue one final murder case, suspecting that it's the handiwork of a
gangster who's already gotten away with the murder of Gently's own wife.
<http://movies.
(2012)<http://movies.
*
Documentaries, 1hr 26m
As the focus of this sobering documentary, the decline of Detroit also
reflects the nation's larger failure to keep up in a modern global economy.
The film also examines the efforts of its residents to maintain Detroit'
vibrant cultural base.
<http://movies.
(2012) <http://movies.
Documentaries, 1hr 28m
Get to know Wayne White, one of America'
artists, with this snappy documentary that traces the ups and downs of his
career. The jovial White discusses his art, strums the banjo, plays with
puppets and simply enjoys life. <http://movies.
*Stolen (2012) <http://movies.
Action & Adventure, 1hr 35m
Master thief Will Montgomery is ready to leave his criminal past behind.
But when his daughter is kidnapped, he has no choice but to reunite with
his old partner in crime and pull off one last heist.
<http://movies.
(2012)<http://movies.
*
Horror Movies, 1hr 22m
A group of young filmmakers visits an abandoned psychiatric hospital to
investigate horrific rumors about patients being treated inhumanely and to
search for the ghosts of two former residents.
On Fri, Mar 29, 2013 at 7:25 AM, Subu S <mail_to_subu@
>
> Thanks Kermit, Randy
>
> I've managed to create a Sp sheet with the sample on the files section
>
> The same is uploaded here http://tinyurl.
>
> Further questions :
> ------------
> 1. I am unable to get the company name using element # 13862. Many Other
> elements are working as you can see from the sp sheet !
>
> 2. I wish to introduce some formula columns in between without any adv fn
> elements i.e. columns with a formulae rather than data from web. But I need
> to have other columns to the right of these with other Adv fn elements ....
> what should I put on the top row so that the extraction does not stop with
> the blank column
>
> TIA
>
Fri Mar 29, 2013 8:42 am (PDT) . Posted by:
"Subu S" mail_to_subu
Randy ... you really Rock !!
Amazing memory and answers
--- In smf_addin@yahoogrou
> I grabbed the smfUpdateDownloadTa
> FILES area of the
> group and 13862 worked fine for me.
I see
> Do I recall that you have an older
> version of EXCEL?
> If so, it may be exceeding a string limit of that version
> of EXCEL.
That's were your terrific memory got my attention and applause !! yes..I use XL 2003..
BTW, Is there something I can do to avoid the error ?
>
> To add your own calculation, you can put an "X"
> in the definition of the
> column. That tells smfUpdateDownloadTa
> leave the column alone.
>
great
> Another options is to do something like:
>
> ~~~1~~~+~~~2~
>
> ...which would say to add the two previous
> columns together. If you do
> this, you may need to make adjustments if you
> delete, insert, and move
> columns around.
>
again ...great
> For example, I just created an smfUpdateDownloadTa
> worksheet that grabs
> new streaming releases from NetFlix. Some of the formulas:
>
> IF("~~~
> http://movies.
> IF("~~~
> http://movies.
>
> The "~~~1~~
> movie ID number. My end result is something like:
>
*what followed this is truly amazing* !!! just mind boggling to me
Wow
Let me try to combine fields and try
regards
Subu
>
> On Fri, Mar 29, 2013 at 7:25 AM, Subu S <mail_to_
>
> >
> > Thanks Kermit, Randy
> >
> > I've managed to create a Sp sheet with the sample on the files section
> >
> > The same is uploaded here http://tinyurl.
> >
> > Further questions :
> > ------------
> > 1. I am unable to get the company name using element # 13862. Many Other
> > elements are working as you can see from the sp sheet !
> >
> > 2. I wish to introduce some formula columns in between without any adv fn
> > elements i.e. columns with a formulae rather than data from web. But I need
> > to have other columns to the right of these with other Adv fn elements ....
> > what should I put on the top row so that the extraction does not stop with
> > the blank column
> >
> > TIA
> >
>
Fri Mar 29, 2013 8:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Does this work on your machine?
smfGetTagContent("
http://investing.money.msn.com/investments/stock-price?Symbol=~~~~~ ","a",1,"<h1
")
On Fri, Mar 29, 2013 at 8:42 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> > Do I recall that you have an older
> > version of EXCEL?
> > If so, it may be exceeding a string limit of that version
> > of EXCEL.
>
> That's were your terrific memory got my attention and applause !! yes..I
> use XL 2003..
>
> BTW, Is there something I can do to avoid the error ?
>
smfGetTagContent(
http://investing.
")
On Fri, Mar 29, 2013 at 8:42 AM, Subu S <mail_to_subu@
>
> > Do I recall that you have an older
> > version of EXCEL?
> > If so, it may be exceeding a string limit of that version
> > of EXCEL.
>
> That's were your terrific memory got my attention and applause !! yes..I
> use XL 2003..
>
> BTW, Is there something I can do to avoid the error ?
>
Fri Mar 29, 2013 9:31 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, where can I find documentation on the Smfupdatedownloadtable ?
I checked the files area and all I saw was in the Stock Market Functions Add-In Change Log
Where it mentioned you added the macro.
I looked at the VBA code which seems to be all the documentation there is. I can work with that but others may not be able to.
Kemrit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, March 29, 2013 11:32 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Ben Graham screen
I grabbed the smfUpdateDownloadTable-Sample.xls from the FILES area of the group and 13862 worked fine for me. Do I recall that you have an older version of EXCEL? If so, it may be exceeding a string limit of that version of EXCEL.
To add your own calculation, you can put an "X" in the definition of the column. That tells smfUpdateDownloadTable to leave the column alone.
Another options is to do something like:
~~~1~~~+~~~2~~~
...which would say to add the two previous columns together. If you do this, you may need to make adjustments if you delete, insert, and move columns around.
For example, I just created an smfUpdateDownloadTable worksheet that grabs new streaming releases from NetFlix. Some of the formulas:
IF("~~~1~~~"="",0,IFERROR(0+smfStrExtr(smfGetTagContent("http://movies.netflix.com/WiMovie/~~~1~~~ ","span",1,"ratings:"),"~"," "),3))
IF("~~~2~~~"="","--",smfGetTagContent("http://movies.netflix.com/WiMovie/~~~2~~~ ","p",-1,"class=""synopsis"""))
The "~~~1~~~" and "~~~2~~~" refer to a column that contains a retrieved movie ID number. My end result is something like:
Movie ID
Stars
Synopsis
Title
Year
Length
Genre
70143872
3.9
On the eve of h…
George_Gently
2007-2011
4 Series
TV Shows
70229260
3.0
As the focus of…
Detropia
2012
1hr 26m
Documentaries
70235124
3.7
Get to know Way…
Beauty_Is_Embarrassing
2012
1hr 28m
Documentaries
70257818
3.3
Master thief Wi…
Stolen
2012
1hr 35m
Action & Adventure
70267730
3.0
A group of youn…
Greystone_Park
2012
1hr 22m
Horror Movies
...which I then use to create an HTML document:
<http://movies.netflix.com/WiMovie/70143872 >
<http://movies.netflix.com/WiMovie/70143872 > George_Gently (2007-2011)
<http://cdn-0.nflximg.com/us/pages/widget/stars_1_39.gif > TV Shows, 4 Series
On the eve of his retirement, Scotland Yard Inspector George Gently decides to pursue one final murder case, suspecting that it's the handiwork of a gangster who's already gotten away with the murder of Gently's own wife.
<http://movies.netflix.com/WiMovie/70229260 >
<http://movies.netflix.com/WiMovie/70229260 > Detropia (2012)
<http://cdn-0.nflximg.com/us/pages/widget/stars_1_30.gif > Documentaries, 1hr 26m
As the focus of this sobering documentary, the decline of Detroit also reflects the nation's larger failure to keep up in a modern global economy. The film also examines the efforts of its residents to maintain Detroit's vibrant cultural base.
<http://movies.netflix.com/WiMovie/70235124 >
<http://movies.netflix.com/WiMovie/70235124 > Beauty_Is_Embarrassing (2012)
<http://cdn-0.nflximg.com/us/pages/widget/stars_1_37.gif > Documentaries, 1hr 28m
Get to know Wayne White, one of America's most unusual and arresting artists, with this snappy documentary that traces the ups and downs of his career. The jovial White discusses his art, strums the banjo, plays with puppets and simply enjoys life.
<http://movies.netflix.com/WiMovie/70257818 >
Stolen (2012) <http://movies.netflix.com/WiMovie/70257818 >
<http://cdn-0.nflximg.com/us/pages/widget/stars_1_33.gif > Action & Adventure, 1hr 35m
Master thief Will Montgomery is ready to leave his criminal past behind. But when his daughter is kidnapped, he has no choice but to reunite with his old partner in crime and pull off one last heist.
<http://movies.netflix.com/WiMovie/70267730 >
<http://movies.netflix.com/WiMovie/70267730 > Greystone_Park (2012)
<http://cdn-0.nflximg.com/us/pages/widget/stars_1_30.gif > Horror Movies, 1hr 22m
A group of young filmmakers visits an abandoned psychiatric hospital to investigate horrific rumors about patients being treated inhumanely and to search for the ghosts of two former residents.
On Fri, Mar 29, 2013 at 7:25 AM, Subu S <mail_to_subu@yahoo.com > wrote:
Thanks Kermit, Randy
I've managed to create a Sp sheet with the sample on the files section
The same is uploaded here http://tinyurl.com/c2rekxc
Further questions :
--------------------------
1. I am unable to get the company name using element # 13862. Many Other elements are working as you can see from the sp sheet !
2. I wish to introduce some formula columns in between without any adv fn elements i.e. columns with a formulae rather than data from web. But I need to have other columns to the right of these with other Adv fn elements .... what should I put on the top row so that the extraction does not stop with the blank column
TIA
I checked the files area and all I saw was in the Stock Market Functions Add-In Change Log
Where it mentioned you added the macro.
I looked at the VBA code which seems to be all the documentation there is. I can work with that but others may not be able to.
Kemrit
From: smf_addin@yahoogrou
Sent: Friday, March 29, 2013 11:32 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Ben Graham screen
I grabbed the smfUpdateDownloadTa
To add your own calculation, you can put an "X" in the definition of the column. That tells smfUpdateDownloadTa
Another options is to do something like:
~~~1~~~+~~~2~
...which would say to add the two previous columns together. If you do this, you may need to make adjustments if you delete, insert, and move columns around.
For example, I just created an smfUpdateDownloadTa
IF("~~~
IF("~~~
The "~~~1~~
Movie ID
Stars
Synopsis
Title
Year
Length
Genre
70143872
3.9
On the eve of h…
George_Gently
2007-2011
4 Series
TV Shows
70229260
3.0
As the focus of…
Detropia
2012
1hr 26m
Documentaries
70235124
3.7
Get to know Way…
Beauty_Is_Embarrass
2012
1hr 28m
Documentaries
70257818
3.3
Master thief Wi…
Stolen
2012
1hr 35m
Action & Adventure
70267730
3.0
A group of youn…
Greystone_Park
2012
1hr 22m
Horror Movies
...which I then use to create an HTML document:
<http://movies.
<http://movies.
<http://cdn-0.
On the eve of his retirement, Scotland Yard Inspector George Gently decides to pursue one final murder case, suspecting that it's the handiwork of a gangster who's already gotten away with the murder of Gently's own wife.
<http://movies.
<http://movies.
<http://cdn-0.
As the focus of this sobering documentary, the decline of Detroit also reflects the nation's larger failure to keep up in a modern global economy. The film also examines the efforts of its residents to maintain Detroit'
<http://movies.
<http://movies.
<http://cdn-0.
Get to know Wayne White, one of America'
<http://movies.
Stolen (2012) <http://movies.
<http://cdn-0.
Master thief Will Montgomery is ready to leave his criminal past behind. But when his daughter is kidnapped, he has no choice but to reunite with his old partner in crime and pull off one last heist.
<http://movies.
<http://movies.
<http://cdn-0.
A group of young filmmakers visits an abandoned psychiatric hospital to investigate horrific rumors about patients being treated inhumanely and to search for the ghosts of two former residents.
On Fri, Mar 29, 2013 at 7:25 AM, Subu S <mail_to_subu@
Thanks Kermit, Randy
I've managed to create a Sp sheet with the sample on the files section
The same is uploaded here http://tinyurl.
Further questions :
------------
1. I am unable to get the company name using element # 13862. Many Other elements are working as you can see from the sp sheet !
2. I wish to introduce some formula columns in between without any adv fn elements i.e. columns with a formulae rather than data from web. But I need to have other columns to the right of these with other Adv fn elements .... what should I put on the top row so that the extraction does not stop with the blank column
TIA
Fri Mar 29, 2013 9:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are two entries in the LINKS area of the group that point to messages
about it.
The "~~~n~~~" usage is new. This last message may be the first I've
mentioned it outside of change documentation or the module itself. It can
sometimes create more headaches than it's worth, since it gets all screwed
up if you add, delete, or move columns around.
One other thing I found out recently is that you can use a named cell in
the formula, as long as it has an absolute reference and not a relative one.
Whenever I create a new one, I just open up the sample from the FILES area
of the group and modify it, since it has the basic layout all defined,
along with the "Ticker" named cell, which everything is keyed on.
On Fri, Mar 29, 2013 at 9:31 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Randy, where can I find documentation on the Smfupdatedownloadtable ? ***
> *
>
> ** **
>
> I checked the files area and all I saw was in the Stock Market Functions
> Add-In Change Log****
>
> Where it mentioned you added the macro.****
>
> ** **
>
> I looked at the VBA code which seems to be all the documentation there is.
> I can work with that but others may not be able to. ****
>
> ** **
>
> Kemrit****
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] *On
> Behalf Of *Randy Harmelink
> *Sent:* Friday, March 29, 2013 11:32 AM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Re: Ben Graham screen****
>
> ** **
>
>
>
> I grabbed the smfUpdateDownloadTable-Sample.xls from the FILES area of the
> group and 13862 worked fine for me. Do I recall that you have an older
> version of EXCEL? If so, it may be exceeding a string limit of that version
> of EXCEL.
>
> To add your own calculation, you can put an "X" in the definition of the
> column. That tells smfUpdateDownloadTable to leave the column alone.
>
> Another options is to do something like:
>
> ~~~1~~~+~~~2~~~
>
> ...which would say to add the two previous columns together. If you do
> this, you may need to make adjustments if you delete, insert, and move
> columns around.
>
about it.
The "~~~n~~
mentioned it outside of change documentation or the module itself. It can
sometimes create more headaches than it's worth, since it gets all screwed
up if you add, delete, or move columns around.
One other thing I found out recently is that you can use a named cell in
the formula, as long as it has an absolute reference and not a relative one.
Whenever I create a new one, I just open up the sample from the FILES area
of the group and modify it, since it has the basic layout all defined,
along with the "Ticker" named cell, which everything is keyed on.
On Fri, Mar 29, 2013 at 9:31 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, where can I find documentation on the Smfupdatedownloadta
> *
>
> ** **
>
> I checked the files area and all I saw was in the Stock Market Functions
> Add-In Change Log****
>
> Where it mentioned you added the macro.****
>
> ** **
>
> I looked at the VBA code which seems to be all the documentation there is.
> I can work with that but others may not be able to. ****
>
> ** **
>
> Kemrit****
>
> *From:* smf_addin@yahoogrou
> Behalf Of *Randy Harmelink
> *Sent:* Friday, March 29, 2013 11:32 AM
> *To:* smf_addin@yahoogrou
> *Subject:* Re: [smf_addin] Re: Ben Graham screen****
>
> ** **
>
>
>
> I grabbed the smfUpdateDownloadTa
> group and 13862 worked fine for me. Do I recall that you have an older
> version of EXCEL? If so, it may be exceeding a string limit of that version
> of EXCEL.
>
> To add your own calculation, you can put an "X" in the definition of the
> column. That tells smfUpdateDownloadTa
>
> Another options is to do something like:
>
> ~~~1~~~+~~~2~
>
> ...which would say to add the two previous columns together. If you do
> this, you may need to make adjustments if you delete, insert, and move
> columns around.
>
Fri Mar 29, 2013 10:00 am (PDT) . Posted by:
"Randy H" rharmelink
Just as an example, I recently converted one of my covered call
workbooks over to use smfUpdateDownloadTable. It has a lot of column
references. Here are the column definitions:
smfGetOptionStrikes("~~~~~",rExpiry,"C",rSource,1,2,1)
IF(len("~~~1~~~")<5,0,smfGetOptionQuotes("~~~1~~~","b",,rSource))
IF(len("~~~2~~~")<5,0,smfGetOptionQuotes("~~~2~~~","s",,rSource))
IF(len("~~~3~~~")<5,0,smfGetOptionQuotes("~~~3~~~","u",,rSource))
IF(~~~3~~~>0,(MIN(~~~1~~~,~~~2~~~)+~~~3~~~)/~~~1~~~-1,0)
~~~1~~~
IF(~~~5~~~>0,1-MIN(~~~3~~~-~~~5~~~,~~~4~~~)/~~~3~~~,0)
smfGetOptionStrikes("~~~~~",rExpiry,"C",rSource,1)
IF(len("~~~1~~~")<5,0,smfGetOptionQuotes("~~~1~~~","b",,rSource))
IF(len("~~~2~~~")<5,0,smfGetOptionQuotes("~~~2~~~","s",,rSource))
IF(len("~~~3~~~")<5,0,smfGetOptionQuotes("~~~3~~~","u",,rSource))
IF(~~~3~~~>0,(MIN(~~~1~~~,~~~2~~~)+~~~3~~~)/~~~1~~~-1,0)
IF(~~~4~~~>0,(~~~3~~~+~~~4~~~)/~~~2~~~-1,0)
IF(~~~5~~~>0,1-(MIN(~~~3~~~-~~~5~~~,~~~4~~~)/~~~3~~~),0)
Note that the "rExpiry" and "rSource" items are named cells that have a
set option expiration date and a set data source to use (i.e. Yahoo,
OptionsXpress, etc).
All of those are in a "data collection" area that is collapsed, so they
are never seen unless expanded. The end result looks something like:
Best covered call based on RIU Ticker Last Price Strike
RIU RIE D/P Call Ticker Symbol Bid Price MMM $106.31 ITM
0.7% 0.7% 2.0% MMM 4/20 2013 $105.00 Call $2.08 MRK $44.20
ITM 1.1% 1.1% 1.5% MRK 4/20 2013 $44.00 Call $0.68
On Fri, Mar 29, 2013 at 9:31 AM, Kermit W. Prather
<kermitp@tampabay.rr.com <mailto:kermitp@tampabay.rr.com > > wrote:
Randy, where can I find documentation on the Smfupdatedownloadtable ?
workbooks over to use smfUpdateDownloadTa
references. Here are the column definitions:
smfGetOptionStrikes
IF(len("
IF(len("
IF(len("
IF(~~~3~~~>
~~~1~~~
IF(~~~5~~~>
smfGetOptionStrikes
IF(len("
IF(len("
IF(len("
IF(~~~3~~~>
IF(~~~4~~~>
IF(~~~5~~~>
Note that the "rExpiry" and "rSource" items are named cells that have a
set option expiration date and a set data source to use (i.e. Yahoo,
OptionsXpress, etc).
All of those are in a "data collection" area that is collapsed, so they
are never seen unless expanded. The end result looks something like:
Best covered call based on RIU Ticker Last Price Strike
RIU RIE D/P Call Ticker Symbol Bid Price MMM $106.31 ITM
0.7% 0.7% 2.0% MMM 4/20 2013 $105.00 Call $2.08 MRK $44.20
ITM 1.1% 1.1% 1.5% MRK 4/20 2013 $44.00 Call $0.68
On Fri, Mar 29, 2013 at 9:31 AM, Kermit W. Prather
<kermitp@tampabay.
Randy, where can I find documentation on the Smfupdatedownloadta
Tidak ada komentar:
Posting Komentar