Jumat, 20 Maret 2015

[smf_addin] Digest Number 3362

2 Messages

Digest #3362
1a
Re: Paste Special Values by "Jason Strauss" g3m1n1980
1b
Re: Paste Special Values by "Randy Harmelink" rharmelink

Messages

Thu Mar 19, 2015 4:23 am (PDT) . Posted by:

"Jason Strauss" g3m1n1980

How do you turn off auto calc?

Yes, I've noticed with cut and paste that certain ratios from certain sources (guru focus is one) don't fully update until you recalculate the add in which technically means double work.

So if pasting a ticker doesn't auto populate and I can click the calculate macro as the only way to start processing, that would allow me to not have to run same set of tickers twice

Just a thought

Sent from my iPhone

> On Mar 18, 2015, at 11:35 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> I'm not sure exactly what your asking.
>
> If you mean auto calculation, you can always turn it off.
>
> The thing that bothers me is your comment, "many sources don't fill properly..."...
>
> On Wed, Mar 18, 2015 at 8:16 PM, Jason Strauss xxjaysonxx@...wrote:
>>
>> Is there a way to paste special values in excel with the add in without having the add in auto populate?
>>
>> I typically have files saved without tickers so the first run is smooth. The problem occurs during the second run after I paste a few different tickers.
>>
>> At this point excel is already linked to the smf so once I paste, it auto populates. The problem I'm finding is many sources don't fill properly until I run the smf again. So I'm actually running it twice to get true accuracy.
>>
>> I can avoid all of this if I could figure out a way to stop the auto populate after pasting. I created a macro to clear cell contents and break the rch link but it removes all the formulas in each cell.
>>
>> Any thoughts?
>
>

Thu Mar 19, 2015 4:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Thu, Mar 19, 2015 at 4:23 AM, Jason Strauss xxjaysonxx@...wrote:

>
> How do you turn off auto calc?
>

http://www.howtogeek.com/162219/how-to-change-the-automatic-calculation-and-multi-threading-features-in-excel-2013/

> Yes, I've noticed with cut and paste that certain ratios from certain
> sources (guru focus is one) don't fully update until you recalculate the
> add in which technically means double work.
>

That doesn't sound right. Are you sure you don't have some type of circular
reference?

> So if pasting a ticker doesn't auto populate and I can click the calculate
> macro as the only way to start processing, that would allow me to not have
> to run same set of tickers twice
>

Another option is to set up a calculation trigger, so that the only
formulas that calculate are those you trigger. For example, something like:

=IF($A$1<>"Y","--",RCHGetElementNumber(....))

...so that the add-in function will only be calculated if cell A1 has "Y"
in it. But you need to save the file when the trigger cell has something
other than "Y" in it, so that when you open the file, no calculations will
be done. I use this technique quite a bit.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar