Jumat, 20 November 2015

[smf_addin] Digest Number 3563[2 Attachments]

6 Messages

Digest #3563

Messages

Thu Nov 19, 2015 12:58 pm (PST) . Posted by:

mcsquanto121212

This question relates to me using a PC with Windows 8.1 with a template provided from a professor. All of my peers are not having any issues. I fear I downloaded the Add In incorrectly (although I do not see how) or I have some Excel settings causing this issue. Using this template, it appears that all of the initial figures are correct. When I enter in a new symbol for the 'ticker' input, I get errors across the board. Please see the attached screen grabs. Below are some sample equations that are used.


=CONCATENATE("$",'C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,941)/1000000," Billion")

='C:\Program Files\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,986)



Please help.


Attachment(s) from
2 of 2 Photo(s)

Thu Nov 19, 2015 1:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The fact that you have path locations in front of the add-in functions
means you have unresolved links. EXCEL should have warned you of this when
you opened the file. You'll get such issues whenever you open up a workbook
that had been saved with the add-in in a different location than yours.

The easiest fix is to run the smfFixLinks macro, which simply does a "Find
and Replace all" on those path locations, changing them to be nothing, so
that EXCEL will find those functions in your activated version of the
add-in.

Once you fix the links, you can save the workbook. It will then hard-code
the location of YOUR activated version of the add-in, so that next time you
open that saved workbook, you shouldn't have unresolved links.

That's just the way EXCEL handles the location of add-in files.

On Thu, Nov 19, 2015 at 11:32 AM, mcsquanto121212@...wrote:

> This question relates to me using a PC with Windows 8.1 with a template
> provided from a professor. All of my peers are not having any issues. I
> fear I downloaded the Add In incorrectly (although I do not see how) or I
> have some Excel settings causing this issue. Using this template, it
> appears that all of the initial figures are correct. When I enter in a new
> symbol for the 'ticker' input, I get errors across the board. Please see
> the attached screen grabs. Below are some sample equations that are used.
>
> =CONCATENATE("$",'C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,941)/1000000,"
> Billion")
>
> ='C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,986)
>
> Please help.
>
>

Thu Nov 19, 2015 9:10 pm (PST) . Posted by:

gbullr

I get #N/A everywhere when I change ticker and hit F9 on both the 2003 and the other one.

Thanks for any help resolving this.




Thu Nov 19, 2015 9:35 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

More details, please...

Which template, specifically? Which ticker? Can you cite a particular
formula? Do you have unresolved links?

F9 should have no affect on recalculation. Just changing the ticker symbol
should trigger everything to update.

On Thu, Nov 19, 2015 at 9:48 PM, gaston.bullrich@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I get #N/A everywhere when I change ticker and hit F9 on both the 2003 and
> the other one.
>
> Thanks for any help resolving this.
>
>

Thu Nov 19, 2015 9:57 pm (PST) . Posted by:

"Gaston Bullrich" gbullr

10 year model all types upon inputting MSFT

[image: Inline image 1]

On Fri, Nov 20, 2015 at 12:35 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> More details, please...
>
> Which template, specifically? Which ticker? Can you cite a particular
> formula? Do you have unresolved links?
>
> F9 should have no affect on recalculation. Just changing the ticker symbol
> should trigger everything to update.
>
> On Thu, Nov 19, 2015 at 9:48 PM, gaston.bullrich@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> I get #N/A everywhere when I change ticker and hit F9 on both the 2003
>> and the other one.
>>
>> Thanks for any help resolving this.
>>
>>
>
>

--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907

Thu Nov 19, 2015 10:05 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Looks to me like it's a result of the web site now carrying 15 years of
data...

On Thu, Nov 19, 2015 at 10:56 PM, Gaston Bullrich gaston.bullrich@... wrote:

>
> 10 year model all types upon inputting MSFT
>
> [image: Inline image 1]
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar