2 Messages
Digest #3362
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?
>
>
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@.
>>
>> 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.
>
> 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<
...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:
Posting Komentar