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.
=CONCATENATE(
='C:\
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.
>
>
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'
That's just the way EXCEL handles the location of add-in files.
On Thu, Nov 19, 2015 at 11:32 AM, 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&#
> the attached screen grabs. Below are some sample equations that are used.
>
> =CONCATENATE(
> Add-in\RCH_
> Billion"
>
> ='C:\
> Add-in\RCH_
>
> 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.
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.
>
>
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
[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]
>
>
data...
On Thu, Nov 19, 2015 at 10:56 PM, Gaston Bullrich gaston.bullrich@
>
> 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:
Posting Komentar