11 New Messages
Digest #2407
5b
5c
Re: Extracting from Financials of http://investing.money.msn.com. by "salexander7781" salexander7781
5d
5e
Re: Extracting from Financials of http://investing.money.msn.com. by "salexander7781" salexander7781
Messages
Tue Nov 20, 2012 6:15 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
If you are truly interested in options and cover calls, you need to checkout Valueline's Option Survey. It's the best kept secret in options and a great deal at $149 year. It has really good options education, tons of PDF's you can download. Read the What We Do below or go to link below. Lawrence was a guest speaker on my 2008 Seminar at Sea that feature 4 full days of stocks and option education. The short of it is they do most of the work for you by ranking the options from 1 to 5 including covered calls. They provide a list of the top 200 in each category. I no longer trade options as I only trade stocks now days. I have gotten lazy in my old age.
Best of all, their option information is downloadable and in Excel format. Plus, they provide several Excel spreadsheets.
Valueline's Option Survey is run by a friend. Don't ask me why they call it a survey. Say hello to Lawrence for me.
Kermit
Valueline Option Survey
Lawrence D. Cavanagh
vloptions@valueline.com
http://www.valueline.com/Products/Options_Products/The_Value_Line_Options_Survey.aspx
What We Do
Every trading day, the Value Line options model looks at all regularly listed US stock, ETF and index options, evaluates them and (if the stocks are ranked by Value Line) ranks them from 1 (for buying) to 5 (for selling). We also rank the calls from 1 to 5 for covered call writing and the puts for "married put" buying.
We now make our new evaluations and rankings on both the bid and the ask prices available to subscribers twice a day (noon and at the close). With our new Interactive Options and Online Options Screener, you get intuitive, easy-to-use, access to our analysis and recommendations on more than 200,000 options, including about 80,000 longer-term options (LEAPS), and more. You also get access to the latest issue of The Weekly Option Strategist (published 48 times a year), that provides vital information on how to best use our service. For a sample of the The Weekly Option Strategist, Click <http://www.valueline.com/uploadedFiles/Valueline/Products/Options_Products/Ot080609.pdf > Here.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Monday, November 19, 2012 6:37 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Option_Harshad_List-00.7c.xls
I wrote the Harshad list file for detecting stocks that were within a certain percentage of the Bollinger Bands and Relative Strength Index. I also look at dividend yield and % of the 52-wk Hi-Lo Spread. Hyperlinks in Column M link to stockcharts.com. Hyperlink in Column N link to the Yahoo Option Tables. The Instructions Tab should tell you to make all changes on the Web_Data Tab. Other changes make to the Call_OTM1 Tab.
The key to any strategy is the Selection Universe (the list of stocks that you are interested in). I am certainly no expert. Check out Yahoo Groups justcoveredcalls and TtP-S.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, November 19, 2012 6:37 AM
Subject: [smf_addin] Re: Option_Harshad_List-00.7c.xls
1º
"Jose -
In the SUBSTITUTE equation, you have a space between the first set of quotation marks.
I got 22.5 when I removed the space.
Ron Spruell"
Yes work. Thanks. I do not see..!!!
But, I make other stock: CSCO and give me a ERROR.
The industry are: "Networking <http://biz.yahoo.com/p/814conameu.html > & Communication Devices" Perhaps problem with "&"?
My command:
B4=CSCO
B33=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Industry:")
=RCHGetTableCell("http://biz.yahoo.com/p/industries.html ";3;SUBSTITUTE(B33;"";""))
But this problem are resolved with yours suggest:
I use first this:
C33 =smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q/pr?s= "&B4;"td";1;"Industry:");"/ic/";".html")
And after:
=RCHGetTableCell("http://biz.yahoo.com/p/industries.html ";3;C33&"conameu")
But if I can use SUBSTITUTE it can be necessary for others and how resolve this problem are interesting.
2º
In this file ...Option_Harshad_List-00.7c.xls is very interesting... but it is possible some of you suggest how to use in practice? How make some decision in trades? Of course if you suggest, are this.. suggest. Not recommendation...
If someone can explain how work ...it is iteresting... I rarely use Options ... but I want learn more and how use this kind of information.
Thanks
Jose
Best of all, their option information is downloadable and in Excel format. Plus, they provide several Excel spreadsheets.
Valueline's Option Survey is run by a friend. Don't ask me why they call it a survey. Say hello to Lawrence for me.
Kermit
Valueline Option Survey
Lawrence D. Cavanagh
vloptions@valueline
http://www.valuelin
What We Do
Every trading day, the Value Line options model looks at all regularly listed US stock, ETF and index options, evaluates them and (if the stocks are ranked by Value Line) ranks them from 1 (for buying) to 5 (for selling). We also rank the calls from 1 to 5 for covered call writing and the puts for "married put" buying.
We now make our new evaluations and rankings on both the bid and the ask prices available to subscribers twice a day (noon and at the close). With our new Interactive Options and Online Options Screener, you get intuitive, easy-to-use, access to our analysis and recommendations on more than 200,000 options, including about 80,000 longer-term options (LEAPS), and more. You also get access to the latest issue of The Weekly Option Strategist (published 48 times a year), that provides vital information on how to best use our service. For a sample of the The Weekly Option Strategist, Click <http://www.valuelin
From: smf_addin@yahoogrou
Sent: Monday, November 19, 2012 6:37 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Option_Harshad_
I wrote the Harshad list file for detecting stocks that were within a certain percentage of the Bollinger Bands and Relative Strength Index. I also look at dividend yield and % of the 52-wk Hi-Lo Spread. Hyperlinks in Column M link to stockcharts.
The key to any strategy is the Selection Universe (the list of stocks that you are interested in). I am certainly no expert. Check out Yahoo Groups justcoveredcalls and TtP-S.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.
To: smf_addin@yahoogrou
Sent: Monday, November 19, 2012 6:37 AM
Subject: [smf_addin] Re: Option_Harshad_
1º
"Jose -
In the SUBSTITUTE equation, you have a space between the first set of quotation marks.
I got 22.5 when I removed the space.
Ron Spruell"
Yes work. Thanks. I do not see..!!!
But, I make other stock: CSCO and give me a ERROR.
The industry are: "Networking <http://biz.yahoo.
My command:
B4=CSCO
B33=RCHGetTableCell
=RCHGetTableCell(
But this problem are resolved with yours suggest:
I use first this:
C33 =smfStrExtr(
And after:
=RCHGetTableCell(
But if I can use SUBSTITUTE it can be necessary for others and how resolve this problem are interesting.
2º
In this file ...Option_Harshad_
If someone can explain how work ...it is iteresting..
Thanks
Jose
Tue Nov 20, 2012 6:30 am (PST) . Posted by:
"doctorajv" doctorajv
First of all, thank you for putting this together. It's so easy to use!
Practical question: How often do array equations with your web calls, like RCHGetYahooHistory, update themselves?
Any other Excel forumula updates itself either when a cell is changed, or when explicitly commanded to "recalculate" [F9]. In the case of "RCHGetYahooHistory," or any of your other web data calls, do they
- update on each "recalc" [F9] or recald "iteration?"
- when the rest of the worksheet recalculates?
- when you first open the worksheet?
- does it "remember" its last web lookup and wait 24 hours? Or some other time interval?
- or do you have to manually go in and trigger a recalc?
Please advise.
Background:
I am running crazy numbers in big worksheets that spend time updating themselves every time they see new history.
What I *want* is for "RCHGetYahooHistory" (or any other call) to update itself every time I open the worksheet where it is used.
What I do *not* want is for "RCHGetYahooHistory" (or any other call)
- to update itself too often, wasting time and bandwidth looking up history that has not changed;
- nor to require me to go in and trigger an update ("<F2>" and "<enter>") in order to reach out and update my history array.
So I basically want to be able to open my Excel file, have it automatically update the history and subsequent [elaborate] computations, then close itself. I will then automate repetition over multiple Excel files for many ticker symbol. The whole batch will basically run overnight. The result will populate a summary upon completion.
So auto-updating quote history is key to my project.
Again, I appreciate your support. As you can see, I am getting some serious mileage out of your Add-Ins. Please let me know if I may do something to help.
Regards,
- AJV
Practical question: How often do array equations with your web calls, like RCHGetYahooHistory, update themselves?
Any other Excel forumula updates itself either when a cell is changed, or when explicitly commanded to "recalculate" [F9]. In the case of "RCHGetYahooHistory
- update on each "recalc" [F9] or recald "iteration?"
- when the rest of the worksheet recalculates?
- when you first open the worksheet?
- does it "remember" its last web lookup and wait 24 hours? Or some other time interval?
- or do you have to manually go in and trigger a recalc?
Please advise.
Background:
I am running crazy numbers in big worksheets that spend time updating themselves every time they see new history.
What I *want* is for "RCHGetYahooHistory
What I do *not* want is for "RCHGetYahooHistory
- to update itself too often, wasting time and bandwidth looking up history that has not changed;
- nor to require me to go in and trigger an update ("<F2>" and "<enter>") in order to reach out and update my history array.
So I basically want to be able to open my Excel file, have it automatically update the history and subsequent [elaborate] computations, then close itself. I will then automate repetition over multiple Excel files for many ticker symbol. The whole batch will basically run overnight. The result will populate a summary upon completion.
So auto-updating quote history is key to my project.
Again, I appreciate your support. As you can see, I am getting some serious mileage out of your Add-Ins. Please let me know if I may do something to help.
Regards,
- AJV
Tue Nov 20, 2012 8:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
In general, the add-in functions are non-volatile, and will not recalculate
with F9. But you can make them volatile by adding a volatile parameter,
such as one of the EXCEL date functions. Otherwise, they should typically
only update if you change one of the parameters. Are you using a date
function, or its results, as input to the RCHGetYahooHistory() function?
All add-in functions should calculate when you open a workbook.
To force a recalculation, you can always use the smfForceRecalculation
macro -- see the LINKS area of the group for more info on it.
On Tue, Nov 20, 2012 at 7:28 AM, doctorajv <ajv@gsh-usa.com > wrote:
> First of all, thank you for putting this together. It's so easy to use!
>
> Practical question: How often do array equations with your web calls,
> like RCHGetYahooHistory, update themselves?
>
> Any other Excel forumula updates itself either when a cell is changed, or
> when explicitly commanded to "recalculate" [F9]. In the case of
> "RCHGetYahooHistory," or any of your other web data calls, do they
>
> - update on each "recalc" [F9] or recald "iteration?"
>
> - when the rest of the worksheet recalculates?
>
> - when you first open the worksheet?
>
> - does it "remember" its last web lookup and wait 24 hours? Or some
> other time interval?
>
> - or do you have to manually go in and trigger a recalc?
>
> Please advise.
>
>
> Background:
>
> I am running crazy numbers in big worksheets that spend time updating
> themselves every time they see new history.
>
> What I *want* is for "RCHGetYahooHistory" (or any other call) to update
> itself every time I open the worksheet where it is used.
>
> What I do *not* want is for "RCHGetYahooHistory" (or any other call)
>
> - to update itself too often, wasting time and bandwidth looking up
> history that has not changed;
>
> - nor to require me to go in and trigger an update ("<F2>" and "<enter>")
> in order to reach out and update my history array.
>
> So I basically want to be able to open my Excel file, have it
> automatically update the history and subsequent [elaborate] computations,
> then close itself. I will then automate repetition over multiple Excel
> files for many ticker symbol. The whole batch will basically run
> overnight. The result will populate a summary upon completion.
>
> So auto-updating quote history is key to my project.
>
> Again, I appreciate your support. As you can see, I am getting some
> serious mileage out of your Add-Ins. Please let me know if I may do
> something to help.
>
with F9. But you can make them volatile by adding a volatile parameter,
such as one of the EXCEL date functions. Otherwise, they should typically
only update if you change one of the parameters. Are you using a date
function, or its results, as input to the RCHGetYahooHistory(
All add-in functions should calculate when you open a workbook.
To force a recalculation, you can always use the smfForceRecalculati
macro -- see the LINKS area of the group for more info on it.
On Tue, Nov 20, 2012 at 7:28 AM, doctorajv <ajv@gsh-usa.
> First of all, thank you for putting this together. It's so easy to use!
>
> Practical question: How often do array equations with your web calls,
> like RCHGetYahooHistory, update themselves?
>
> Any other Excel forumula updates itself either when a cell is changed, or
> when explicitly commanded to "recalculate" [F9]. In the case of
> "RCHGetYahooHistory
>
> - update on each "recalc" [F9] or recald "iteration?"
>
> - when the rest of the worksheet recalculates?
>
> - when you first open the worksheet?
>
> - does it "remember" its last web lookup and wait 24 hours? Or some
> other time interval?
>
> - or do you have to manually go in and trigger a recalc?
>
> Please advise.
>
>
> Background:
>
> I am running crazy numbers in big worksheets that spend time updating
> themselves every time they see new history.
>
> What I *want* is for "RCHGetYahooHistory
> itself every time I open the worksheet where it is used.
>
> What I do *not* want is for "RCHGetYahooHistory
>
> - to update itself too often, wasting time and bandwidth looking up
> history that has not changed;
>
> - nor to require me to go in and trigger an update ("<F2>" and "<enter>")
> in order to reach out and update my history array.
>
> So I basically want to be able to open my Excel file, have it
> automatically update the history and subsequent [elaborate] computations,
> then close itself. I will then automate repetition over multiple Excel
> files for many ticker symbol. The whole batch will basically run
> overnight. The result will populate a summary upon completion.
>
> So auto-updating quote history is key to my project.
>
> Again, I appreciate your support. As you can see, I am getting some
> serious mileage out of your Add-Ins. Please let me know if I may do
> something to help.
>
Tue Nov 20, 2012 10:07 am (PST) . Posted by:
"ajv@gsh-usa.com" doctorajv
I appreciate you getting back to me so fast. That's a perfect
answer for me; add-ins, in general, including yours, -
recalculate [in this case, web data lookup & repopulate
destination array] each time the workbook is opened; -
recalculate when a precedent in the equation [array equation in
this case] is updated (must be written into the array equation)
- or when otherwise forced - but never automatically on "F9"
or on circular-equation "iterations."
As a newbie to all this, I appreciate your patience. I can't
wait to get using this and generating some great results.
Thanks and regards,
- AJV
A.J. Vigil ajv@gsh-usa.com <mailto:ajv@gsh-usa.com >
-------- Original Message --------
Subject: Re: [smf_addin] Q: Update interval on RCHGetYahooHistory
From: Randy Harmelink <rharmelink@gmail.com
<mailto:rharmelink@gmail.com > >
Date: Tue, November 20, 2012 11:15 am
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com >
In general, the add-in functions are non-volatile, and will
not recalculate with F9. But you can make them volatile by adding
a volatile parameter, such as one of the EXCEL date functions.
Otherwise, they should typically only update if you change one of
the parameters. Are you using a date function, or its results, as
input to the RCHGetYahooHistory() function?
All add-in functions should calculate when you open a workbook.
To force a recalculation, you can always use the
smfForceRecalculation macro -- see the LINKS area of the group
for more info on it.
On Tue, Nov 20, 2012 at 7:28 AM, doctorajv <ajv@gsh-usa.com
<mailto:ajv@gsh-usa.com > > wrote:
First of all, thank you for putting this together. It's so easy
to use!
Practical question: How often do array equations with your web
calls, like RCHGetYahooHistory, update themselves?
Any other Excel forumula updates itself either when a cell is
changed, or when explicitly commanded to "recalculate" [F9]. In
the case of "RCHGetYahooHistory," or any of your other web data
calls, do they
- update on each "recalc" [F9] or recald "iteration?"
- when the rest of the worksheet recalculates?
- when you first open the worksheet?
- does it "remember" its last web lookup and wait 24 hours? Or
some other time interval?
- or do you have to manually go in and trigger a recalc?
Please advise.
Background:
I am running crazy numbers in big worksheets that spend time
updating themselves every time they see new history.
What I *want* is for "RCHGetYahooHistory" (or any other call) to
update itself every time I open the worksheet where it is used.
What I do *not* want is for "RCHGetYahooHistory" (or any other
call)
- to update itself too often, wasting time and bandwidth looking
up history that has not changed;
- nor to require me to go in and trigger an update ("<F2>" and
"<enter>") in order to reach out and update my history array.
So I basically want to be able to open my Excel file, have it
automatically update the history and subsequent [elaborate]
computations, then close itself. I will then automate repetition
over multiple Excel files for many ticker symbol. The whole
batch will basically run overnight. The result will populate a
summary upon completion.
So auto-updating quote history is key to my project.
Again, I appreciate your support. As you can see, I am getting
some serious mileage out of your Add-Ins. Please let me know if
I may do something to help.
#wmQuoteWrapper #ygrp-mkp { border: 1px solid #d8d8d8;
font-family: Arial; margin: 10px 0; padding: 0 10px; }
#wmQuoteWrapper #ygrp-mkp hr { border: 1px solid #d8d8d8; }
#wmQuoteWrapper #ygrp-mkp #hd { color: #628c2a; font-size: 85%;
font-weight: 700; line-height: 122%; margin: 10px 0; }
#wmQuoteWrapper #ygrp-mkp #ads { margin-bottom: 10px; }
#wmQuoteWrapper #ygrp-mkp .ad { padding: 0 0; } #wmQuoteWrapper
#ygrp-mkp .ad p { margin: 0; } #wmQuoteWrapper #ygrp-mkp .ad a
{ color: #0000ff; text-decoration: none; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc { font-family: Arial; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc #hd { margin: 10px 0px; font-weight: 700;
font-size: 78%; line-height: 122%; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc .ad { margin-bottom: 10px; padding: 0 0;
} #wmQuoteWrapper #actions { font-family: Verdana; font-size:
11px; padding: 10px 0; } #wmQuoteWrapper #activity {
background-color: #e0ecee; float: left; font-family: Verdana;
font-size: 10px; padding: 10px; } #wmQuoteWrapper #activity span
{ font-weight: 700; } #wmQuoteWrapper #activity span:first-child
{ text-transform: uppercase; } #wmQuoteWrapper #activity span a
{ color: #5085b6; text-decoration: none; } #wmQuoteWrapper
#activity span span { color: #ff7900; } #wmQuoteWrapper
#activity span .underline { text-decoration: underline; }
#wmQuoteWrapper .attach { clear: both; display: table;
font-family: Arial; font-size: 12px; padding: 10px 0; width:
400px; } #wmQuoteWrapper .attach div a { text-decoration: none;
} #wmQuoteWrapper .attach img { border: none; padding-right:
5px; } #wmQuoteWrapper .attach label { display: block;
margin-bottom: 5px; } #wmQuoteWrapper .attach label a {
text-decoration: none; } #wmQuoteWrapper blockquote { margin: 0
0 0 4px; } #wmQuoteWrapper .bold { font-family: Arial;
font-size: 13px; font-weight: 700; } #wmQuoteWrapper .bold a {
text-decoration: none; } #wmQuoteWrapper dd.last p a {
font-family: Verdana; font-weight: 700; } #wmQuoteWrapper
dd.last p span { margin-right: 10px; font-family: Verdana;
font-weight: 700; } #wmQuoteWrapper dd.last p span.yshortcuts {
margin-right: 0; } #wmQuoteWrapper div.attach-table div div a {
text-decoration: none; } #wmQuoteWrapper div.attach-table {
width: 400px; } #wmQuoteWrapper div.file-title a,
#wmQuoteWrapper div.file-title a:active, #wmQuoteWrapper
div.file-title a:hover, #wmQuoteWrapper div.file-title a:visited
{ text-decoration: none; } #wmQuoteWrapper div.photo-title a,
#wmQuoteWrapper div.photo-title a:active, #wmQuoteWrapper
div.photo-title a:hover, #wmQuoteWrapper div.photo-title
a:visited { text-decoration: none; } #wmQuoteWrapper
div#ygrp-mlmsg #ygrp-msg p a span.yshortcuts { font-family:
Verdana; font-size: 10px; font-weight: normal; } #wmQuoteWrapper
.green { color: #628c2a; } #wmQuoteWrapper .MsoNormal {
margin: 0 0 0 0; } #wmQuoteWrapper o { font-size: 0; }
#wmQuoteWrapper #photos div { float: left; width: 72px; }
#wmQuoteWrapper #photos div div { border: 1px solid #666666;
height: 62px; overflow: hidden; width: 62px; } #wmQuoteWrapper
#photos div label { color: #666666; font-size: 10px; overflow:
hidden; text-align: center; white-space: nowrap; width: 64px; }
#wmQuoteWrapper #reco-category { font-size: 77%; }
#wmQuoteWrapper #reco-desc { font-size: 77%; } #wmQuoteWrapper
.replbq { margin: 4px; } #wmQuoteWrapper #ygrp-actbar div
a:first-child { /* border-right: 0px solid #000;*/ margin-right:
2px; padding-right: 5px; } #wmQuoteWrapper #ygrp-mlmsg {
font-size: 13px; font-family: Arial, helvetica,clean, sans-serif;
*font-size: small; *font: x-small; } #wmQuoteWrapper #ygrp-mlmsg
table { font-size: inherit; font: 100%; } #wmQuoteWrapper
#ygrp-mlmsg select, #wmQuoteWrapper input, #wmQuoteWrapper
textarea { font: 99% Arial, Helvetica, clean, sans-serif; }
#wmQuoteWrapper #ygrp-mlmsg pre, #wmQuoteWrapper code {
font:115% monospace; *font-size:100%; } #wmQuoteWrapper
#ygrp-mlmsg * { line-height: 1.22em; } #wmQuoteWrapper
#ygrp-mlmsg #logo { padding-bottom: 10px; } #wmQuoteWrapper
#ygrp-msg p a { font-family: Verdana; } #wmQuoteWrapper
#ygrp-msg p#attach-count span { color: #1E66AE; font-weight:
700; } #wmQuoteWrapper #ygrp-reco #reco-head { color: #ff7900;
font-weight: 700; } #wmQuoteWrapper #ygrp-reco { margin-bottom:
20px; padding: 0px; } #wmQuoteWrapper #ygrp-sponsor #ov li a {
font-size: 130%; text-decoration: none; } #wmQuoteWrapper
#ygrp-sponsor #ov li { font-size: 77%; list-style-type: square;
padding: 6px 0; } #wmQuoteWrapper #ygrp-sponsor #ov ul {
margin: 0; padding: 0 0 0 8px; } #wmQuoteWrapper #ygrp-text {
font-family: Georgia; } #wmQuoteWrapper #ygrp-text p { margin:
0 0 1em 0; } #wmQuoteWrapper #ygrp-text tt { font-size: 120%; }
#wmQuoteWrapper #ygrp-vital ul li:last-child { border-right:
none !important; }
answer for me; add-ins, in general, including yours, -
recalculate [in this case, web data lookup & repopulate
destination array] each time the workbook is opened; -
recalculate when a precedent in the equation [array equation in
this case] is updated (must be written into the array equation)
- or when otherwise forced - but never automatically on "F9"
or on circular-equation "iterations.
As a newbie to all this, I appreciate your patience. I can't
wait to get using this and generating some great results.
Thanks and regards,
- AJV
A.J. Vigil ajv@gsh-usa.
-------- Original Message --------
Subject: Re: [smf_addin] Q: Update interval on RCHGetYahooHistory
From: Randy Harmelink <rharmelink@gmail.
<mailto:rharmelink@gmail.
Date: Tue, November 20, 2012 11:15 am
To: smf_addin@yahoogrou
In general, the add-in functions are non-volatile, and will
not recalculate with F9. But you can make them volatile by adding
a volatile parameter, such as one of the EXCEL date functions.
Otherwise, they should typically only update if you change one of
the parameters. Are you using a date function, or its results, as
input to the RCHGetYahooHistory(
All add-in functions should calculate when you open a workbook.
To force a recalculation, you can always use the
smfForceRecalculati
for more info on it.
On Tue, Nov 20, 2012 at 7:28 AM, doctorajv <ajv@gsh-usa.
<mailto:ajv@gsh-usa.
First of all, thank you for putting this together. It's so easy
to use!
Practical question: How often do array equations with your web
calls, like RCHGetYahooHistory, update themselves?
Any other Excel forumula updates itself either when a cell is
changed, or when explicitly commanded to "recalculate" [F9]. In
the case of "RCHGetYahooHistory
calls, do they
- update on each "recalc" [F9] or recald "iteration?"
- when the rest of the worksheet recalculates?
- when you first open the worksheet?
- does it "remember" its last web lookup and wait 24 hours? Or
some other time interval?
- or do you have to manually go in and trigger a recalc?
Please advise.
Background:
I am running crazy numbers in big worksheets that spend time
updating themselves every time they see new history.
What I *want* is for "RCHGetYahooHistory
update itself every time I open the worksheet where it is used.
What I do *not* want is for "RCHGetYahooHistory
call)
- to update itself too often, wasting time and bandwidth looking
up history that has not changed;
- nor to require me to go in and trigger an update ("<F2>" and
"<enter>") in order to reach out and update my history array.
So I basically want to be able to open my Excel file, have it
automatically update the history and subsequent [elaborate]
computations, then close itself. I will then automate repetition
over multiple Excel files for many ticker symbol. The whole
batch will basically run overnight. The result will populate a
summary upon completion.
So auto-updating quote history is key to my project.
Again, I appreciate your support. As you can see, I am getting
some serious mileage out of your Add-Ins. Please let me know if
I may do something to help.
#wmQuoteWrapper #ygrp-mkp { border: 1px solid #d8d8d8;
font-family: Arial; margin: 10px 0; padding: 0 10px; }
#wmQuoteWrapper #ygrp-mkp hr { border: 1px solid #d8d8d8; }
#wmQuoteWrapper #ygrp-mkp #hd { color: #628c2a; font-size: 85%;
font-weight: 700; line-height: 122%; margin: 10px 0; }
#wmQuoteWrapper #ygrp-mkp #ads { margin-bottom: 10px; }
#wmQuoteWrapper #ygrp-mkp .ad { padding: 0 0; } #wmQuoteWrapper
#ygrp-mkp .ad p { margin: 0; } #wmQuoteWrapper #ygrp-mkp .ad a
{ color: #0000ff; text-decoration: none; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc { font-family: Arial; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc #hd { margin: 10px 0px; font-weight: 700;
font-size: 78%; line-height: 122%; } #wmQuoteWrapper
#ygrp-sponsor #ygrp-lc .ad { margin-bottom: 10px; padding: 0 0;
} #wmQuoteWrapper #actions { font-family: Verdana; font-size:
11px; padding: 10px 0; } #wmQuoteWrapper #activity {
background-color: #e0ecee; float: left; font-family: Verdana;
font-size: 10px; padding: 10px; } #wmQuoteWrapper #activity span
{ font-weight: 700; } #wmQuoteWrapper #activity span:first-child
{ text-transform: uppercase; } #wmQuoteWrapper #activity span a
{ color: #5085b6; text-decoration: none; } #wmQuoteWrapper
#activity span span { color: #ff7900; } #wmQuoteWrapper
#activity span .underline { text-decoration: underline; }
#wmQuoteWrapper .attach { clear: both; display: table;
font-family: Arial; font-size: 12px; padding: 10px 0; width:
400px; } #wmQuoteWrapper .attach div a { text-decoration: none;
} #wmQuoteWrapper .attach img { border: none; padding-right:
5px; } #wmQuoteWrapper .attach label { display: block;
margin-bottom: 5px; } #wmQuoteWrapper .attach label a {
text-decoration: none; } #wmQuoteWrapper blockquote { margin: 0
0 0 4px; } #wmQuoteWrapper .bold { font-family: Arial;
font-size: 13px; font-weight: 700; } #wmQuoteWrapper .bold a {
text-decoration: none; } #wmQuoteWrapper dd.last p a {
font-family: Verdana; font-weight: 700; } #wmQuoteWrapper
dd.last p span { margin-right: 10px; font-family: Verdana;
font-weight: 700; } #wmQuoteWrapper dd.last p span.yshortcuts {
margin-right: 0; } #wmQuoteWrapper div.attach-table div div a {
text-decoration: none; } #wmQuoteWrapper div.attach-table {
width: 400px; } #wmQuoteWrapper div.file-title a,
#wmQuoteWrapper div.file-title a:active, #wmQuoteWrapper
div.file-title a:hover, #wmQuoteWrapper div.file-title a:visited
{ text-decoration: none; } #wmQuoteWrapper div.photo-title a,
#wmQuoteWrapper div.photo-title a:active, #wmQuoteWrapper
div.photo-title a:hover, #wmQuoteWrapper div.photo-title
a:visited { text-decoration: none; } #wmQuoteWrapper
div#ygrp-mlmsg #ygrp-msg p a span.yshortcuts { font-family:
Verdana; font-size: 10px; font-weight: normal; } #wmQuoteWrapper
.green { color: #628c2a; } #wmQuoteWrapper .MsoNormal {
margin: 0 0 0 0; } #wmQuoteWrapper o { font-size: 0; }
#wmQuoteWrapper #photos div { float: left; width: 72px; }
#wmQuoteWrapper #photos div div { border: 1px solid #666666;
height: 62px; overflow: hidden; width: 62px; } #wmQuoteWrapper
#photos div label { color: #666666; font-size: 10px; overflow:
hidden; text-align: center; white-space: nowrap; width: 64px; }
#wmQuoteWrapper #reco-category { font-size: 77%; }
#wmQuoteWrapper #reco-desc { font-size: 77%; } #wmQuoteWrapper
.replbq { margin: 4px; } #wmQuoteWrapper #ygrp-actbar div
a:first-child { /* border-right: 0px solid #000;*/ margin-right:
2px; padding-right: 5px; } #wmQuoteWrapper #ygrp-mlmsg {
font-size: 13px; font-family: Arial, helvetica,clean, sans-serif;
*font-size: small; *font: x-small; } #wmQuoteWrapper #ygrp-mlmsg
table { font-size: inherit; font: 100%; } #wmQuoteWrapper
#ygrp-mlmsg select, #wmQuoteWrapper input, #wmQuoteWrapper
textarea { font: 99% Arial, Helvetica, clean, sans-serif; }
#wmQuoteWrapper #ygrp-mlmsg pre, #wmQuoteWrapper code {
font:115% monospace; *font-size:100%
#ygrp-mlmsg * { line-height: 1.22em; } #wmQuoteWrapper
#ygrp-mlmsg #logo { padding-bottom: 10px; } #wmQuoteWrapper
#ygrp-msg p a { font-family: Verdana; } #wmQuoteWrapper
#ygrp-msg p#attach-count span { color: #1E66AE; font-weight:
700; } #wmQuoteWrapper #ygrp-reco #reco-head { color: #ff7900;
font-weight: 700; } #wmQuoteWrapper #ygrp-reco { margin-bottom:
20px; padding: 0px; } #wmQuoteWrapper #ygrp-sponsor #ov li a {
font-size: 130%; text-decoration: none; } #wmQuoteWrapper
#ygrp-sponsor #ov li { font-size: 77%; list-style-type: square;
padding: 6px 0; } #wmQuoteWrapper #ygrp-sponsor #ov ul {
margin: 0; padding: 0 0 0 8px; } #wmQuoteWrapper #ygrp-text {
font-family: Georgia; } #wmQuoteWrapper #ygrp-text p { margin:
0 0 1em 0; } #wmQuoteWrapper #ygrp-text tt { font-size: 120%; }
#wmQuoteWrapper #ygrp-vital ul li:last-child { border-right:
none !important; }
Tue Nov 20, 2012 10:51 am (PST) . Posted by:
"sihlai" sihlai
I just upgraded to a new machine and started using Excel 2010. For spreadsheets that previously contain RCH stock market functions, each cell with RCH stock market functions has been stuffed with prefix
C:\Microsoft Office\RCH_Stock_Market_Functions-2.1.2010.08.02\RCH_Stock_Market_Functions.xla!
in front of the formula. For example:
='C:\Microsoft Office\RCH_Stock_Market_Functions-2.1.2010.08.02\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MSFT","l1",,NOW())
If I take out the whole prefix, then the formula works, but with the prefix, it doesn't work. I opened a few other previous spreadsheets containing RCH stock market functions, and they are all filled with that prefix. Is there something I can do to avoid having the prefix filled in?
C:\Microsoft Office\RCH_Stock_
in front of the formula. For example:
='C:\Microsoft Office\RCH_Stock_
If I take out the whole prefix, then the formula works, but with the prefix, it doesn't work. I opened a few other previous spreadsheets containing RCH stock market functions, and they are all filled with that prefix. Is there something I can do to avoid having the prefix filled in?
Tue Nov 20, 2012 11:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The only way to avoid the issue is to locate the add-in where those
workbooks are looking for it. But there are a variety of locations used by
workbooks in the FILES area of the group.
So, whenever I run into link errors like that, I just run the smfFixLinks
macro. I have it on a button on my toolbar.
Once the workbooks are saved with the current location of the add-in, they
won't have the issue again. The issue arises because EXCEL saves a
hard-coded location to the add-in whenever a workbook is saved. If the
add-in isn't located there when the workbook is opened, it tags it as an
unresolved link and leaves that hard-coded location on the formula.
On Tue, Nov 20, 2012 at 11:51 AM, sihlai <sihlai@yahoo.ca > wrote:
> I just upgraded to a new machine and started using Excel 2010. For
> spreadsheets that previously contain RCH stock market functions, each cell
> with RCH stock market functions has been stuffed with prefix
>
> C:\Microsoft
> Office\RCH_Stock_Market_Functions-2.1.2010.08.02\RCH_Stock_Market_Functions.xla!
>
> in front of the formula. For example:
>
> ='C:\Microsoft
> Office\RCH_Stock_Market_Functions-2.1.2010.08.02\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("MSFT","l1",,NOW())
>
> If I take out the whole prefix, then the formula works, but with the
> prefix, it doesn't work. I opened a few other previous spreadsheets
> containing RCH stock market functions, and they are all filled with that
> prefix. Is there something I can do to avoid having the prefix filled in?
>
workbooks are looking for it. But there are a variety of locations used by
workbooks in the FILES area of the group.
So, whenever I run into link errors like that, I just run the smfFixLinks
macro. I have it on a button on my toolbar.
Once the workbooks are saved with the current location of the add-in, they
won't have the issue again. The issue arises because EXCEL saves a
hard-coded location to the add-in whenever a workbook is saved. If the
add-in isn't located there when the workbook is opened, it tags it as an
unresolved link and leaves that hard-coded location on the formula.
On Tue, Nov 20, 2012 at 11:51 AM, sihlai <sihlai@yahoo.
> I just upgraded to a new machine and started using Excel 2010. For
> spreadsheets that previously contain RCH stock market functions, each cell
> with RCH stock market functions has been stuffed with prefix
>
> C:\Microsoft
> Office\RCH_Stock_
>
> in front of the formula. For example:
>
> ='C:\Microsoft
> Office\RCH_Stock_
>
> If I take out the whole prefix, then the formula works, but with the
> prefix, it doesn't work. I opened a few other previous spreadsheets
> containing RCH stock market functions, and they are all filled with that
> prefix. Is there something I can do to avoid having the prefix filled in?
>
Tue Nov 20, 2012 2:39 pm (PST) . Posted by:
"salexander7781" salexander7781
Hello,
I apologize if this was answered before. I am trying to extract figures for Gross Profit, Depreciation/Amortization etc from the msn link:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT
Here are the things I tried unsuccessfully:
1) =RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol= "MSFT"",1,">Gross Profit")
2) This one seems to work however I don't know how to fill in the information about the Gross Profit figure that I want in the formula:
=smfGetTagContent("http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT ","a",-1,"/company-report/?symbol=")
If I open the source of the page in Chrome, I see the code below that contains the Gross Profit numbers I want
<tr class='mnboldtopline'>
<td id="GrossProfit" class="mnfirsttd">
<span class="mnminmargin">
Gross Profit</span>
</td>
<td>56,193.0</td>
<td>54,366.0</td>
<td>50,089.0</td>
<td>46,282.0</td>
<td>48,822.0</td>
</tr>
Many thanks.
I apologize if this was answered before. I am trying to extract figures for Gross Profit, Depreciation/
http://investing.
Here are the things I tried unsuccessfully:
1) =RCHGetTableCell(
2) This one seems to work however I don't know how to fill in the information about the Gross Profit figure that I want in the formula:
=smfGetTagContent(
If I open the source of the page in Chrome, I see the code below that contains the Gross Profit numbers I want
<tr class='mnboldtoplin
<td id="GrossProfit" class="mnfirsttd"
<span class="mnminmargin"
Gross Profit</span>
</td>
<td>56,193.0<
<td>54,366.0<
<td>50,089.0<
<td>46,282.0<
<td>48,822.0<
</tr>
Many thanks.
Tue Nov 20, 2012 2:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You should take a look at this template:
RCHGetTableCell-Template-MSN-Financial-Statements.xls
The formula there for the first year of Gross Profit is:
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol= "&Ticker,
1,"Gross Profit")
On Tue, Nov 20, 2012 at 1:42 PM, salexander7781 <salexand@gmail.com > wrote:
>
> I apologize if this was answered before. I am trying to extract figures
> for Gross Profit, Depreciation/Amortization etc from the msn link:
>
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT
>
> Here are the things I tried unsuccessfully:
> 1) =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol= "MSFT"",1,">Gross
> Profit")
>
> 2) This one seems to work however I don't know how to fill in the
> information about the Gross Profit figure that I want in the formula:
>
> =smfGetTagContent("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT
> ","a",-1,"/company-report/?symbol=")
>
> If I open the source of the page in Chrome, I see the code below that
> contains the Gross Profit numbers I want
> <tr class='mnboldtopline'>
> <td id="GrossProfit" class="mnfirsttd">
> <span class="mnminmargin">
> Gross Profit</span>
> </td>
> <td>56,193.0</td>
> <td>54,366.0</td>
> <td>50,089.0</td>
> <td>46,282.0</td>
> <td>48,822.0</td>
> </tr>
>
> Many thanks.
>
RCHGetTableCell-
The formula there for the first year of Gross Profit is:
=RCHGetTableCell(
http://investing.
1,"Gross Profit")
On Tue, Nov 20, 2012 at 1:42 PM, salexander7781 <salexand@gmail.
>
> I apologize if this was answered before. I am trying to extract figures
> for Gross Profit, Depreciation/
>
> http://investing.
>
> Here are the things I tried unsuccessfully:
> 1) =RCHGetTableCell(
> http://investing.
> Profit")
>
> 2) This one seems to work however I don't know how to fill in the
> information about the Gross Profit figure that I want in the formula:
>
> =smfGetTagContent(
> http://investing.
> ","a",-1,"/company-
>
> If I open the source of the page in Chrome, I see the code below that
> contains the Gross Profit numbers I want
> <tr class='mnboldtoplin
> <td id="GrossProfit" class="mnfirsttd"
> <span class="mnminmargin"
> Gross Profit</span>
> </td>
> <td>56,193.0<
> <td>54,366.0<
> <td>50,089.0<
> <td>46,282.0<
> <td>48,822.0<
> </tr>
>
> Many thanks.
>
Tue Nov 20, 2012 3:00 pm (PST) . Posted by:
"salexander7781" salexander7781
Thank you Randy. That worked fine. But I couldn't find the template xls file you were referring to in either my installation directory (C:\Program Files\SMF Add-In) or in the Files area.
Could you please let me know where this excel file is ? Thanks again!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You should take a look at this template:
>
> RCHGetTableCell-Template-MSN-Financial-Statements.xls
>
> The formula there for the first year of Gross Profit is:
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol= "&Ticker,
> 1,"Gross Profit")
>
> On Tue, Nov 20, 2012 at 1:42 PM, salexander7781 <salexand@...> wrote:
>
> >
> > I apologize if this was answered before. I am trying to extract figures
> > for Gross Profit, Depreciation/Amortization etc from the msn link:
> >
> > http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT
> >
> > Here are the things I tried unsuccessfully:
> > 1) =RCHGetTableCell("
> > http://investing.money.msn.com/investments/stock-income-statement/?symbol= "MSFT"",1,">Gross
> > Profit")
> >
> > 2) This one seems to work however I don't know how to fill in the
> > information about the Gross Profit figure that I want in the formula:
> >
> > =smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-income-statement/?symbol=MSFT
> > ","a",-1,"/company-report/?symbol=")
> >
> > If I open the source of the page in Chrome, I see the code below that
> > contains the Gross Profit numbers I want
> > <tr class='mnboldtopline'>
> > <td id="GrossProfit" class="mnfirsttd">
> > <span class="mnminmargin">
> > Gross Profit</span>
> > </td>
> > <td>56,193.0</td>
> > <td>54,366.0</td>
> > <td>50,089.0</td>
> > <td>46,282.0</td>
> > <td>48,822.0</td>
> > </tr>
> >
> > Many thanks.
> >
>
Could you please let me know where this excel file is ? Thanks again!
--- In smf_addin@yahoogrou
>
> You should take a look at this template:
>
> RCHGetTableCell-
>
> The formula there for the first year of Gross Profit is:
>
> =RCHGetTableCell(
> http://investing.
> 1,"Gross Profit")
>
> On Tue, Nov 20, 2012 at 1:42 PM, salexander7781 <salexand@..
>
> >
> > I apologize if this was answered before. I am trying to extract figures
> > for Gross Profit, Depreciation/
> >
> > http://investing.
> >
> > Here are the things I tried unsuccessfully:
> > 1) =RCHGetTableCell(
> > http://investing.
> > Profit")
> >
> > 2) This one seems to work however I don't know how to fill in the
> > information about the Gross Profit figure that I want in the formula:
> >
> > =smfGetTagContent(
> > http://investing.
> > ","a",-1,"/company-
> >
> > If I open the source of the page in Chrome, I see the code below that
> > contains the Gross Profit numbers I want
> > <tr class='mnboldtoplin
> > <td id="GrossProfit" class="mnfirsttd"
> > <span class="mnminmargin"
> > Gross Profit</span>
> > </td>
> > <td>56,193.0<
> > <td>54,366.0<
> > <td>50,089.0<
> > <td>46,282.0<
> > <td>48,822.0<
> > </tr>
> >
> > Many thanks.
> >
>
Tue Nov 20, 2012 3:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's in this folder:
http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/
On Tue, Nov 20, 2012 at 3:59 PM, salexander7781 <salexand@gmail.com > wrote:
> Thank you Randy. That worked fine. But I couldn't find the template xls
> file you were referring to in either my installation directory (C:\Program
> Files\SMF Add-In) or in the Files area.
>
> Could you please let me know where this excel file is ? Thanks again!
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > You should take a look at this template:
> >
> > RCHGetTableCell-Template-MSN-Financial-Statements.xls
>
http://finance.
On Tue, Nov 20, 2012 at 3:59 PM, salexander7781 <salexand@gmail.
> Thank you Randy. That worked fine. But I couldn't find the template xls
> file you were referring to in either my installation directory (C:\Program
> Files\SMF Add-In) or in the Files area.
>
> Could you please let me know where this excel file is ? Thanks again!
>
> --- In smf_addin@yahoogrou
> >
> > You should take a look at this template:
> >
> > RCHGetTableCell-
>
Tue Nov 20, 2012 3:23 pm (PST) . Posted by:
"salexander7781" salexander7781
I can't believe how patient you are to a noob. Thank you.
--- In smf_addin@yahoogrou
>
> It's in this folder:
>
> http://finance.
>
> On Tue, Nov 20, 2012 at 3:59 PM, salexander7781 <salexand@..
>
> > Thank you Randy. That worked fine. But I couldn't find the template xls
> > file you were referring to in either my installation directory (C:\Program
> > Files\SMF Add-In) or in the Files area.
> >
> > Could you please let me know where this excel file is ? Thanks again!
> >
> > --- In smf_addin@yahoogrou
> > >
> > > You should take a look at this template:
> > >
> > > RCHGetTableCell-
> >
>
Tidak ada komentar:
Posting Komentar