5 Messages
Digest #3042
Messages
Sat Apr 12, 2014 6:34 am (PDT) . Posted by:
"Darryl Bonfessuto"
Randy does it matter if you are using excel 2013 I am getting a ghost file(another excel copy opens with grey area) with every excel file I open ie 2 files open together.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, April 10, 2014 12:53 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Wildly wrong option quotes?
You could add a call to smfForceRecalculation to your VBA...
On Wed, Apr 9, 2014 at 9:35 PM, <dave@fiel.us <mailto:dave@fiel.us> > wrote:
Yes, I use an array for stock quotes. But for options, I use VBA to run a series of tickers to get the quotes for various strikes and expiration dates. So recalculating doesn't accomplish much, but the cache clearing makes the VBA work properly on the next run. Not ideal, but it works, and a far sight better than staring at options chains manually.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, April 10, 2014 12:53 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Wildly wrong option quotes?
You could add a call to smfForceRecalculation to your VBA...
On Wed, Apr 9, 2014 at 9:35 PM, <dave@fiel.us <mailto:dave@fiel.us> > wrote:
Yes, I use an array for stock quotes. But for options, I use VBA to run a series of tickers to get the quotes for various strikes and expiration dates. So recalculating doesn't accomplish much, but the cache clearing makes the VBA work properly on the next run. Not ideal, but it works, and a far sight better than staring at options chains manually.
Sat Apr 12, 2014 8:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Doesn't sound normal to me, but I've never used EXCEL 2013...
In EXCEL 2007, I sometimes have an additional instance of EXCEL on my task
bar when it's recalculating. But if I select it, it takes me to the
worksheet I have that is calculating. And if the calculation is done, that
additional instance disappears. Is that the kind of thing you might be
talking about?
On Sat, Apr 12, 2014 at 6:34 AM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> Randy does it matter if you are using excel 2013 I am getting a ghost
> file(another excel copy opens with grey area) with every excel file I
> open ie 2 files open together.
>
In EXCEL 2007, I sometimes have an additional instance of EXCEL on my task
bar when it's recalculating. But if I select it, it takes me to the
worksheet I have that is calculating. And if the calculation is done, that
additional instance disappears. Is that the kind of thing you might be
talking about?
On Sat, Apr 12, 2014 at 6:34 AM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> Randy does it matter if you are using excel 2013 I am getting a ghost
> file(another excel copy opens with grey area) with every excel file I
> open ie 2 files open together.
>
Sat Apr 12, 2014 4:16 pm (PDT) . Posted by:
"Darryl Bonfessuto"
I installed RiskAMP Monte Carlo. Its seems its not liking one of the addins. Everytime I open a saved or download an excel file a second instance file opens with the selected file. This second file is a grey /ghost file. I have enclose a picture. Any thoughts?
Thanks
darryl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, April 12, 2014 11:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Wildly wrong option quotes?
Doesn't sound normal to me, but I've never used EXCEL 2013...
In EXCEL 2007, I sometimes have an additional instance of EXCEL on my task bar when it's recalculating. But if I select it, it takes me to the worksheet I have that is calculating. And if the calculation is done, that additional instance disappears. Is that the kind of thing you might be talking about?
On Sat, Apr 12, 2014 at 6:34 AM, Darryl Bonfessuto <dmb7111@gmail.com <mailto:dmb7111@gmail.com> > wrote:
Randy does it matter if you are using excel 2013 I am getting a ghost file(another excel copy opens with grey area) with every excel file I open ie 2 files open together.
Thanks
darryl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, April 12, 2014 11:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Wildly wrong option quotes?
Doesn't sound normal to me, but I've never used EXCEL 2013...
In EXCEL 2007, I sometimes have an additional instance of EXCEL on my task bar when it's recalculating. But if I select it, it takes me to the worksheet I have that is calculating. And if the calculation is done, that additional instance disappears. Is that the kind of thing you might be talking about?
On Sat, Apr 12, 2014 at 6:34 AM, Darryl Bonfessuto <dmb7111@gmail.com <mailto:dmb7111@gmail.com> > wrote:
Randy does it matter if you are using excel 2013 I am getting a ghost file(another excel copy opens with grey area) with every excel file I open ie 2 files open together.
Attachment(s) from Darryl Bonfessuto
1 of 1 Photo(s)
Sat Apr 12, 2014 4:24 pm (PDT) . Posted by:
"Darryl Bonfessuto"
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Darryl Bonfessuto
Sent: Saturday, April 12, 2014 7:17 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Re: Wildly wrong option quotes? [1 Attachment]
[Attachment(s) from Darryl Bonfessuto included below]
I installed RiskAMP Monte Carlo. Its seems its not liking one of the addins. Everytime I open a saved or download an excel file a second instance file opens with the selected file. This second file is a grey /ghost file. I have enclose a picture. Any thoughts?
Thanks
darryl
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, April 12, 2014 11:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Wildly wrong option quotes?
Doesn't sound normal to me, but I've never used EXCEL 2013...
In EXCEL 2007, I sometimes have an additional instance of EXCEL on my task bar when it's recalculating. But if I select it, it takes me to the worksheet I have that is calculating. And if the calculation is done, that additional instance disappears. Is that the kind of thing you might be talking about?
On Sat, Apr 12, 2014 at 6:34 AM, Darryl Bonfessuto <dmb7111@gmail.com <mailto:dmb7111@gmail.com> > wrote:
Randy does it matter if you are using excel 2013 I am getting a ghost file(another excel copy opens with grey area) with every excel file I open ie 2 files open together.
Sat Apr 12, 2014 10:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a clue. Sorry.
On Sat, Apr 12, 2014 at 4:16 PM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> I installed RiskAMP Monte Carlo. Its seems its not liking one of the
> addins. Everytime I open a saved or download an excel file a second
> instance file opens with the selected file. This second file is a grey
> /ghost file. I have enclose a picture. Any thoughts?
>
>
On Sat, Apr 12, 2014 at 4:16 PM, Darryl Bonfessuto <dmb7111@gmail.com>wrote:
>
> I installed RiskAMP Monte Carlo. Its seems its not liking one of the
> addins. Everytime I open a saved or download an excel file a second
> instance file opens with the selected file. This second file is a grey
> /ghost file. I have enclose a picture. Any thoughts?
>
>
Tidak ada komentar:
Posting Komentar