7 New Messages
Digest #2309
| 3a Randy's RCHGetYahooQuotes template by "christian.pitt@sbcglobal.net" christian.pitt@sbcglobal.net 3c Re: Randy's RCHGetYahooQuotes template by "christian.pitt@sbcglobal.net" christian.pitt@sbcglobal.net |
Messages
Thu Aug 9, 2012 5:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That is a very complicated question because it depends on exactly what
you're asking and exactly what you're doing.
You could use other functions. You could not recalculate. You could save
values instead of using formulas.
On Thu, Aug 9, 2012 at 3:50 AM, ufdn16 <ufdn16@yahoo.com > wrote:
> I'm using an excel worksheet with many references to element numbers. It
> works just fine but when I open the file it begins to recalculate. This
> process takes a few minutes. Is there a way to speed this process up.
>
you're asking and exactly what you're doing.
You could use other functions. You could not recalculate. You could save
values instead of using formulas.
On Thu, Aug 9, 2012 at 3:50 AM, ufdn16 <ufdn16@yahoo.
> I'm using an excel worksheet with many references to element numbers. It
> works just fine but when I open the file it begins to recalculate. This
> process takes a few minutes. Is there a way to speed this process up.
>
Thu Aug 9, 2012 7:35 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
May I suggest if you are really looking for reasonably price option service checkout Valueline's Option Survey. It is run by my good friend Lawrence D. Cavanagh at vloptions@valueline.com annual fee is $149.
This overview may be of use. http://www.valueline.com/Products/Options_Products/The_Value_Line_Options_Survey.aspx
You can download their daily spreadsheets to aid in your analysis.
Lawrence was a guest speaker at my 2008 Seminars at Sea. He does tend to get into the Greeks.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, August 08, 2012 4:37 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ETF Put Option Prices
I would suspect it was a problem with Yahoo, but without specific examples it would be impossible to tell.
Are you still having problems?
I quite often have issues with Yahoo on the weekly options, since they don't update as they become available.
On Wed, Aug 8, 2012 at 9:42 AM, adam_sommers <adam@sommersfinancial.com > wrote:
I have been using the smfGetYahooOptionQuote function to pull put option prices into my worksheet, but this morning, all of the stock put prices came in, but the ETF put pricing did not. Any ideas? I'm trying to pull put prices for SPY, XLE, XLK, etc. It has worked for years...is it Yahoo, or is it me?
This overview may be of use. http://www.valuelin
You can download their daily spreadsheets to aid in your analysis.
Lawrence was a guest speaker at my 2008 Seminars at Sea. He does tend to get into the Greeks.
Kermit
From: smf_addin@yahoogrou
Sent: Wednesday, August 08, 2012 4:37 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] ETF Put Option Prices
I would suspect it was a problem with Yahoo, but without specific examples it would be impossible to tell.
Are you still having problems?
I quite often have issues with Yahoo on the weekly options, since they don't update as they become available.
On Wed, Aug 8, 2012 at 9:42 AM, adam_sommers <adam@sommersfinanci
I have been using the smfGetYahooOptionQu
Thu Aug 9, 2012 10:06 am (PDT) . Posted by:
"christian.pitt@sbcglobal.net" christian.pitt@sbcglobal.net
Hi Randy--
I've been using your spreadsheet for a couple weeks. It's great. However, I opened it this morning and none of the cells populated. F9 does nothing. I've tried to download the original spreadsheet and it doesn't work either.
I thought I saw something about a limit to the number of data pieces (maybe it was 1000?), but I can't find that comment either.
Any thoughts? i greatly appreciate your help.
Chris
I've been using your spreadsheet for a couple weeks. It's great. However, I opened it this morning and none of the cells populated. F9 does nothing. I've tried to download the original spreadsheet and it doesn't work either.
I thought I saw something about a limit to the number of data pieces (maybe it was 1000?), but I can't find that comment either.
Any thoughts? i greatly appreciate your help.
Chris
Thu Aug 9, 2012 10:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just opened the template from the FILES area of the Yahoo group, and it
worked fine for me.
Hopefully, it was just a temporary Yahoo issue?
Otherwise, did you add some type of firewall that would prevent EXCEL from
being able to access the Internet? Do other functions work? What do you get
with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",943)
=RCHGetElementNumber("MMM",33)
=RCHGetYahooQuotes("MMM","d1")
On Thu, Aug 9, 2012 at 10:00 AM, christian.pitt@sbcglobal.net <
christian.pitt@sbcglobal.net > wrote:
>
> I've been using your spreadsheet for a couple weeks. It's great.
> However, I opened it this morning and none of the cells populated. F9
> does nothing. I've tried to download the original spreadsheet and it
> doesn't work either.
>
> I thought I saw something about a limit to the number of data pieces
> (maybe it was 1000?), but I can't find that comment either.
>
> Any thoughts? i greatly appreciate your help.
>
worked fine for me.
Hopefully, it was just a temporary Yahoo issue?
Otherwise, did you add some type of firewall that would prevent EXCEL from
being able to access the Internet? Do other functions work? What do you get
with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetYahooQuotes(
On Thu, Aug 9, 2012 at 10:00 AM, christian.pitt@
christian.pitt@
>
> I've been using your spreadsheet for a couple weeks. It's great.
> However, I opened it this morning and none of the cells populated. F9
> does nothing. I've tried to download the original spreadsheet and it
> doesn't work either.
>
> I thought I saw something about a limit to the number of data pieces
> (maybe it was 1000?), but I can't find that comment either.
>
> Any thoughts? i greatly appreciate your help.
>
Thu Aug 9, 2012 11:18 am (PDT) . Posted by:
"christian.pitt@sbcglobal.net" christian.pitt@sbcglobal.net
Thanks for your quick reply. When I opened this time everything seemed to be working fine. Must have been a yahoo issue -- i'll give it a little more time next time it happens. Tx. Chris
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just opened the template from the FILES area of the Yahoo group, and it
> worked fine for me.
>
> Hopefully, it was just a temporary Yahoo issue?
>
> Otherwise, did you add some type of firewall that would prevent EXCEL from
> being able to access the Internet? Do other functions work? What do you get
> with:
>
> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("MMM",943)
> =RCHGetElementNumber("MMM",33)
> =RCHGetYahooQuotes("MMM","d1")
>
> On Thu, Aug 9, 2012 at 10:00 AM, christian.pitt@... <
> christian.pitt@...> wrote:
>
> >
> > I've been using your spreadsheet for a couple weeks. It's great.
> > However, I opened it this morning and none of the cells populated. F9
> > does nothing. I've tried to download the original spreadsheet and it
> > doesn't work either.
> >
> > I thought I saw something about a limit to the number of data pieces
> > (maybe it was 1000?), but I can't find that comment either.
> >
> > Any thoughts? i greatly appreciate your help.
> >
>
--- In smf_addin@yahoogrou
>
> I just opened the template from the FILES area of the Yahoo group, and it
> worked fine for me.
>
> Hopefully, it was just a temporary Yahoo issue?
>
> Otherwise, did you add some type of firewall that would prevent EXCEL from
> being able to access the Internet? Do other functions work? What do you get
> with:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetYahooQuotes(
>
> On Thu, Aug 9, 2012 at 10:00 AM, christian.pitt@
> christian.pitt@
>
> >
> > I've been using your spreadsheet for a couple weeks. It's great.
> > However, I opened it this morning and none of the cells populated. F9
> > does nothing. I've tried to download the original spreadsheet and it
> > doesn't work either.
> >
> > I thought I saw something about a limit to the number of data pieces
> > (maybe it was 1000?), but I can't find that comment either.
> >
> > Any thoughts? i greatly appreciate your help.
> >
>
Thu Aug 9, 2012 11:31 pm (PDT) . Posted by:
"rb_luther" rb_luther
I uploaded an excel file in the "upload by member" folder under the files link called Running total calculation.xlsx.
My question is this. I created a pivot table and the "value" column of the pivot table was set to sum as "running total in" under the pivot table tools/show values as/running total in. This basically creates a running total.
I then went to the pivot table tools/field items and sets/calcualted field. In the calculated field I created a custome calculation in the pivot table which is the % column which takes the price column and divides it by the values column to get a percentage.
You can notice that the percentages calculated are not correct based on using the running total numbers in the values column, but rather the percentage calculated uses the base numbers from the values column....NOT the running total numbers.
Is there any way to correct this outside of making a column outside of the pivot table to calculate it and/or doing the running total as the source data for the pivot table? I would really prefer to add a custom calculated field in the pivot table.
Also it seems if you filter data in the pivot table the "values" column blows up and does not show the correct "running total" value. Any fixt to this as well?
Thanks guys.
My question is this. I created a pivot table and the "value" column of the pivot table was set to sum as "running total in" under the pivot table tools/show values as/running total in. This basically creates a running total.
I then went to the pivot table tools/field items and sets/calcualted field. In the calculated field I created a custome calculation in the pivot table which is the % column which takes the price column and divides it by the values column to get a percentage.
You can notice that the percentages calculated are not correct based on using the running total numbers in the values column, but rather the percentage calculated uses the base numbers from the values column....NOT the running total numbers.
Is there any way to correct this outside of making a column outside of the pivot table to calculate it and/or doing the running total as the source data for the pivot table? I would really prefer to add a custom calculated field in the pivot table.
Also it seems if you filter data in the pivot table the "values" column blows up and does not show the correct "running total" value. Any fixt to this as well?
Thanks guys.
Fri Aug 10, 2012 12:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Since in has nothing to do with the add-in, that would be a better question
for an EXCEL support group, such as:
http://tech.groups.yahoo.com/group/ms_excel/
On Thu, Aug 9, 2012 at 11:31 PM, rb_luther <rb_luther@yahoo.com > wrote:
> I uploaded an excel file in the "upload by member" folder under the files
> link called Running total calculation.xlsx.
>
> My question is this. I created a pivot table and the "value" column of the
> pivot table was set to sum as "running total in" under the pivot table
> tools/show values as/running total in. This basically creates a running
> total.
>
> I then went to the pivot table tools/field items and sets/calcualted
> field. In the calculated field I created a custome calculation in the pivot
> table which is the % column which takes the price column and divides it by
> the values column to get a percentage.
>
> You can notice that the percentages calculated are not correct based on
> using the running total numbers in the values column, but rather the
> percentage calculated uses the base numbers from the values column....NOT
> the running total numbers.
>
> Is there any way to correct this outside of making a column outside of the
> pivot table to calculate it and/or doing the running total as the source
> data for the pivot table? I would really prefer to add a custom calculated
> field in the pivot table.
>
> Also it seems if you filter data in the pivot table the "values" column
> blows up and does not show the correct "running total" value. Any fixt to
> this as well?
>
for an EXCEL support group, such as:
http://tech.
On Thu, Aug 9, 2012 at 11:31 PM, rb_luther <rb_luther@yahoo.
> I uploaded an excel file in the "upload by member" folder under the files
> link called Running total calculation.
>
> My question is this. I created a pivot table and the "value" column of the
> pivot table was set to sum as "running total in" under the pivot table
> tools/show values as/running total in. This basically creates a running
> total.
>
> I then went to the pivot table tools/field items and sets/calcualted
> field. In the calculated field I created a custome calculation in the pivot
> table which is the % column which takes the price column and divides it by
> the values column to get a percentage.
>
> You can notice that the percentages calculated are not correct based on
> using the running total numbers in the values column, but rather the
> percentage calculated uses the base numbers from the values column....NOT
> the running total numbers.
>
> Is there any way to correct this outside of making a column outside of the
> pivot table to calculate it and/or doing the running total as the source
> data for the pivot table? I would really prefer to add a custom calculated
> field in the pivot table.
>
> Also it seems if you filter data in the pivot table the "values" column
> blows up and does not show the correct "running total" value. Any fixt to
> this as well?
>
Tidak ada komentar:
Posting Komentar