Messages In This Digest (11 Messages)
- 1a.
- Re: Populate the spreadsheet when open it From: Jacob Jose
- 2a.
- Re: Quotes on Stock Options including Greeks From: Miguel
- 2b.
- Re: Quotes on Stock Options including Greeks From: Randy Harmelink
- 2c.
- Re: Quotes on Stock Options including Greeks From: Miguel
- 3a.
- MSN Money 5 yr growth rate From: scottandrewjackson
- 3b.
- Re: MSN Money 5 yr growth rate From: Randy Harmelink
- 4a.
- If function From: scottandrewjackson
- 4b.
- Re: If function From: James Nylen
- 4c.
- Re: If function From: Scott Jackson
- 4d.
- Re: If function From: Randy Harmelink
- 4e.
- Re: If function From: Scott Jackson
Messages
- 1a.
-
Re: Populate the spreadsheet when open it
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Tue Sep 6, 2011 6:41 am (PDT)
That was it!! Thanks a lot.
Regards,
Jose L. Jacob
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, September 5, 2011 3:26:27 PM
Subject: Re: [smf_addin] Populate the spreadsheet when open it
Possibly manual calculation?
On Mon, Sep 5, 2011 at 9:58 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>I am using the SMF Add-In for some time now, and only have praise for the product.
>
>I am working on a new workbook, and all of a sudden, when opening the workbook, the SMF is not populating the values from the different web sites. It is opening with the values when I saved the workbook the last time this thing worked. As far as I can see, the other workbooks are fine except this one.
>
>Do you thing is it a setting in Excel for this particular spreadsheet?
>
- 2a.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Miguel" spectratecharchitecture@gmail.com spectratecharchitecture
Tue Sep 6, 2011 1:15 pm (PDT)
hello randy, how can i include your functions in a macro? this way, i dont have run "forceRecalculation", i rather have a macro that runs it for me every x minutes?
--- In smf_addin@yahoogroups.com , "swiftyjpowell" <telework@...> wrote:
>
> You're right. OX2 worked for the Put Delta data so now I've got it all set up. I can upload the template... it's a very handy position sizing calculator for stocks and options.
>
- 2b.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Sep 6, 2011 1:31 pm (PDT)
There's a VBA example pointed to in the "Links" area of the group. Also,
check the message archives for "onTime".
However, note that I'm not fond of people doing stuff like that. It's unfair
to use the free services repeatedly if you're not really LOOKING at the data
for each iteration of updating. If you need that type of display, you should
get a dedicated quotes service.
On Tue, Sep 6, 2011 at 1:15 PM, Miguel <spectratecharchitecture@gmail. >wrote:com
> hello randy, how can i include your functions in a macro? this way, i dont
> have run "forceRecalculation", i rather have a macro that runs it for me
> every x minutes?
>
- 2c.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Miguel" spectratecharchitecture@gmail.com spectratecharchitecture
Tue Sep 6, 2011 6:49 pm (PDT)
I appreciate your help Randy, but don't feel like that. Your help has allowed me and my group to mine data in ways we never knew. It made us learn VBA, it made us learn excel to a more advanced level. As I said when I first met you, we have OptionsXpress accounts and we get free realtime quotes, but that's it. A flashing number and realtime charts. We've used what we've learned here to identify trends that no data service can provide, trends in volatility, trends in economics, all of this data can be drawn into a chart and a trend can be spotted, and no streaming data service can identify those for you. We are working on an economic heatmap right now, options heatmap, and more great things that just pull info from other sites. I wish I could contribute something to the group, but like I said, I'm learning as I go. I guess I can contribute our finished excel sheet when we are done with it, but it wouldn't be anything new, it was created using your help and all of the tools found in this group.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> There's a VBA example pointed to in the "Links" area of the group. Also,
> check the message archives for "onTime".
>
> However, note that I'm not fond of people doing stuff like that. It's unfair
> to use the free services repeatedly if you're not really LOOKING at the data
> for each iteration of updating. If you need that type of display, you should
> get a dedicated quotes service.
>
> On Tue, Sep 6, 2011 at 1:15 PM, Miguel <spectratecharchitecture@... >wrote:
>
> > hello randy, how can i include your functions in a macro? this way, i dont
> > have run "forceRecalculation", i rather have a macro that runs it for me
> > every x minutes?
> >
>
- 3a.
-
MSN Money 5 yr growth rate
Posted by: "scottandrewjackson" scottandrewjackson@yahoo.com scottandrewjackson
Tue Sep 6, 2011 1:45 pm (PDT)
I am calculating portfolio statistics and using the RCHgettablecell function I can't pull the 5 yr growth rate.
=RCHGetTableCell("http://investing. money.msn. "&C6&",3,""Company"com/investments/ earnings- estimates? symbol=US% 3a )
http://investing.money.msn. com/investments/ earnings- estimates? symbol=wen
- 3b.
-
Re: MSN Money 5 yr growth rate
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Sep 6, 2011 1:58 pm (PDT)
Your function invocation doesn't make sense -- you only have a single
parameter to the function, this URL:
"http://investing.money.msn. com/investments/ earnings- estimates? symbol=US% 3a
"&C6&",3,""Company"
...because you are concatenating three items:
"http://investing.money.msn. "com/investments/ earnings- estimates? symbol=US% 3a
C6
",3,""Company"
I think you want something like:
=RCHGetTableCell("
http://investing.money.msn. "&C6,4,"Nextcom/investments/ earnings- estimates? symbol=
5 Yrs","Company")
...because "Company" alone is NOT a good search term. It's found all over
the source code of the web page, because there are a lot of links with the
word "company" in it.
On Tue, Sep 6, 2011 at 1:45 PM, scottandrewjackson <
scottandrewjackson@yahoo.com > wrote:
> I am calculating portfolio statistics and using the RCHgettablecell
> function I can't pull the 5 yr growth rate.
>
> =RCHGetTableCell("
> http://investing.money.msn. com/investments/ earnings- estimates? symbol=US% 3a
> "&C6&",3,""Company")
>
> http://investing.money.msn. com/investments/ earnings- estimates? symbol=wen
>
- 4a.
-
If function
Posted by: "scottandrewjackson" scottandrewjackson@yahoo.com scottandrewjackson
Tue Sep 6, 2011 2:37 pm (PDT)
I am returning a NA from the RCHGETTABLECELL
I need to multipy cells and then sum the column but some of the cells return NA, so my sum for the column is returning a "#VALUE!"
this is what I am trying to use:
=IF(H7*G7=NA,0,H7*G7)
Thank you
- 4b.
-
Re: If function
Posted by: "James Nylen" jnylen@gmail.com jamesnylen
Tue Sep 6, 2011 2:51 pm (PDT)
Use the ISNA() function
On Tue, Sep 6, 2011 at 5:37 PM, scottandrewjackson <
scottandrewjackson@yahoo.com > wrote:
> **
>
>
> I am returning a NA from the RCHGETTABLECELL
>
> I need to multipy cells and then sum the column but some of the cells
> return NA, so my sum for the column is returning a "#VALUE!"
>
> this is what I am trying to use:
> =IF(H7*G7=NA,0,H7*G7)
>
> Thank you
>
>
>
- 4c.
-
Re: If function
Posted by: "Scott Jackson" scottandrewjackson@yahoo.com scottandrewjackson
Tue Sep 6, 2011 2:54 pm (PDT)
I am kind of inexperienced with excel. How would I use the isna function with the "if" function below?
Scott Jackson
Equity Research Analyst
Downriver Capital Management, LLC
(509) 499-6693
www.Downrivercapital.com
Sent from my iPhone
On Sep 6, 2011, at 2:51 PM, James Nylen <jnylen@gmail.com > wrote:
> Use the ISNA() function
>
>
> On Tue, Sep 6, 2011 at 5:37 PM, scottandrewjackson <scottandrewjackson@yahoo.com > wrote:
>
> I am returning a NA from the RCHGETTABLECELL
>
> I need to multipy cells and then sum the column but some of the cells return NA, so my sum for the column is returning a "#VALUE!"
>
> this is what I am trying to use:
> =IF(H7*G7=NA,0,H7*G7)
>
> Thank you
>
>
>
- 4d.
-
Re: If function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Sep 6, 2011 4:16 pm (PDT)
The ISNA() function won't help you. There's a lot of difference between a
string value of "NA" and the EXCEL #N/A! value. What I would suggest:
=IF(ISERROR(H7*G7),0, H7*G7)
Or, try just:
=IFERROR(H7*G7,0)
On Tue, Sep 6, 2011 at 2:37 PM, scottandrewjackson <
scottandrewjackson@yahoo.com > wrote:
> I am returning a NA from the RCHGETTABLECELL
>
> I need to multipy cells and then sum the column but some of the cells
> return NA, so my sum for the column is returning a "#VALUE!"
>
> this is what I am trying to use:
> =IF(H7*G7=NA,0,H7*G7)
>
- 4e.
-
Re: If function
Posted by: "Scott Jackson" scottandrewjackson@yahoo.com scottandrewjackson
Tue Sep 6, 2011 4:35 pm (PDT)
The first one worked great!
Thank you Randy!
Sent from my iPhone
On Sep 6, 2011, at 4:16 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> The ISNA() function won't help you. There's a lot of difference between a string value of "NA" and the EXCEL #N/A! value. What I would suggest:
>
> =IF(ISERROR(H7*G7),0, H7*G7)
>
> Or, try just:
>
> =IFERROR(H7*G7,0)
>
>
> On Tue, Sep 6, 2011 at 2:37 PM, scottandrewjackson <scottandrewjackson@yahoo.com > wrote:
> I am returning a NA from the RCHGETTABLECELL
>
> I need to multipy cells and then sum the column but some of the cells return NA, so my sum for the column is returning a "#VALUE!"
>
> this is what I am trying to use:
> =IF(H7*G7=NA,0,H7*G7)
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar