Yo may want to upgrade you're browser.
You're using an old version of Internet Explorer to browse SpiderXL right now. SpiderXL will work better for you if you upgrade or switch to another browser.
Frequently Asked Questions
This collection of frequently asked questions (FAQ) provides brief answers to many common questions about the Spider Financial and SpiderXL Add-ins Platform. It also provides links to more detailed information available from this web site. Please check here for answers before posting a question to one of the forums or before sending email to the support e-mail addresses.
General
Sure. Send an email to support@spiderfinancial.com and we'll set up a time to do a live demo with you over the internet (or in person if you are in Chicago,IL).
We offer a variety of resources to assist with installation problem. Please, check out the following:
- Documentation - Getting Started, Installation guide
- Request support at our Self-service center
- Frequently-asked questions (FAQ)
- Live Support
- Online Live Support to discuss the issue with our support personnel through our website.
- On demand remote desktop support - remote desktop is a remote support tool that enables instant, secure, and trouble-free
connections between remote computers over the web and to any point on
the globe. - Phone.
Periodically, SPIDER updates the add-ins with new features or fixes to minor problems. The Automatic Notification and Update feature allows SPIDER to automatically notify you when an updated version of our software is available so that you can install it right away.
Updates to our add-ins help ensure that the Add-ins work properly and may contain important security changes. SPIDER recommends that you update to the latest version of the software whenever a new version is available, especially when a security update is mentioned. Although you may choose whether to receive automatic notification of updates and how frequently to receive them, SPIDER is not responsible for errors or security problems that occur because the version of the add-in on your computer is not the most current one available.
We value all feedback we receive from our customers and do all we can to address them immediately. You can submit your suggestions and claims 24x7 by phone or email.
For defect, please file your bug in the SPIDER's public bugbase and the our support team can investigate accordingly.
You can file a bug report by using the self-service support center or simply emailing us at support@spiderxl.com. In either case, a new issue will be created in our self-service support center, and you can track it from your account with us.
In any case please report as much details as possible, for instance:
- operating system;
- Excel version (i.e. 2007, XP, 2003, etc.)
- Attach the Excel file;
We highly-recommend that you review outstanding open issues, frequently asked questions and forums before you open a new issue. This help both of us to get faster response and resolution.
We love to hear from our customers. Customers can use the web contact page to send us your thoughts, suggestions, concerns, etc.
Please, visit the self-service online support center or send us your questions regarding the functionality of our products, problems with installation, registration or performance and other related stuff at support@spiderfinancial.com
Product updates
To Allow Remote Desktop Access you need to do the following: 
- Follow the link: http://www.techinline.com?eid=13d29dcb-fffa-4010-8db2-67d8c61e52e4
- Click the green "Install the Plugin" link button to install the TechInLine plugin (you will have to restart your browser to activate the plugin).
- Then click the "Send Client ID by Email" hyperlink (circled in red in the image below) or manually send your client ID to Support@spiderfinancial.com or call us with it at the following number: (312) 324-0367/(888)-427-9486
- All you need to do now is to give permission to grant our support staff to access your desktop.
Remote Desktop™ is a remote support tool that enables instant, secure, and trouble-free connections between remote computers over the web and to any point on the globe.
Using state of art remote desktop software from techinline, our support team can quickly view, diagnose, and fix remote desktops without pre-installing software.
- Remotely control any desktop anywhere in the world
- Send and receive text chat messages
To get started, do the following:
- Get a client ID: follow this link
- A new broweser will open, Copy the Client ID into clipboard (Ctrl+C), and leave the browser window open.
- Contact our support line through email (support@spiderxl.com) or Online Live Support, and send the Client ID
- The representative will initiate a remote desktop session to your computer.
After installing NumXL, few users reported this error poping up when they open Excel.
The problem is directly related to the initialization of the user-interface portion of the Add-in and the virus scanner software on the user's machine. Nevertheless, the actual functions (e.g. ACFi, WNTest, etc.) should be available are ready for use.
The problem occurs when the virus scanner on the client machine is interferring with the add-in startup code; We have seen this problem with Trend Micro Virus Scanner, AVG, but others may have similar issues.
To get around this problem, update your virus scanner software, and/or add an exception to allow Excel (and, NumXL) to access system registry.
If you continue to experience this error, please contact our support line.
The common behavior starts like a successful download, but when the download process reaches 99% an error pop-up window appears saying "it cannot copy the file: unable to read the original file or disk".
Although, the download setup program is securely digitally signed, we have experienced this issue with users who sits behind a restrictive firewall or proxy. The problem does not occur when we used a direct link. As a workaround, please email support@spiderfinancial.com, and we'll send you a direct link of the up-to date product.
We usually release a new major version approximately every 3 months. Nevertheless, maintenance updates, such as adding a feature in response to a specific demand or fixing outstanding issues are released more often.
We ship a new version approximately every 3 months. Simple updates adding a single feature in response to a specific demand are released as required.
Spider Financial will continue to support earlier releases of NumXL for the following 12 months, after which users are kindly required to update to latest version.
License Agreement
No, you do not need to buy NumXL again. Just uninstall NumXL from the old computer and deactivate the licensen key. After that, install NumXL on your new computer using the same product key you received with your original purchase.
If you experience any issue while deactivating the license key, contact us.
NO, the license key can be only activated on one computer. For trial and Lite version users, please download a new copy of our website and use the new key included in the email body.
For registered users of the professional version, please contact our support representative to issue a new key.
The message occurs during the manual license key activation. The program determines that the activation code is not valid. This can be a result of a number of reasons:
- License key is mistyped. please, check the license key carefully and try again.
- The activation code is mistyped. please, check the letters and digits sequence carefully, and try again.
- The computer used to generate the activation code is different than the one we are trying to activate the key on. If this the case, please deactivate the license key or obtain a new key.
The license key activation is basically a method to unlock the add-in on one computer. The license key can be activated only on one computer.
When you download the add-in, we send you an email with personal trial license key along with instruction to finish the download process. During the trial period, the add-in is fully functional. After the trial period, the license key remains valid, but the software runs now in the restricted functionality mode (i.e. freeware).
For registered users, a permanent license key is sent as part of the purchase process. This key has no expiry, and upon successful activation, the add-in remains fully functional all the time.
If you need any assistance locating you license key, contact us.
The license key activation is not mandatory, and our add-in will continue to work with two main exceptions; (1) it will run in restricted functionality (i.e. freeware mode), and (2) a message box will pop up to remind you to register your license key everytime Excel starts.
Whether you are a registered user for the professional version or not, please activate your license key.
Early on, NumXL started as a freeware to entice early adopters (i.e. users) to use our product(s) and help us gain visibility, gather information and feedback from our users to further improve the product, and position our product competitively from other providers.
As the product grew in coverage, we opted to introduce the commercial version of NumXL. Nevertheless, we continue to offer our users a several core functionality for free as part of the NumXL Light version.
Yes. All we need to know the purpose of your application and the scale (how many users) so that we can determine the proper licensing agreement and pricing (if any).
YES, You may distribute the setup executable electronically for download, on optical media, magnetic media, or any other form of distribution as long as it complies with the End User License agreement.
Customer Service
Yes, premium product support is offered to customers at no additional charge for 1 year post their purchase date. After that, customers may purchase premium support separately.
Emails from customers are given priority, and a section of the website is reserved for registered clients.
Yes, contact us for pricing and plan details.
Microsoft Excel
In Excel, you can manage the add-ins using Add-ins Available Box". To access the Add-in Box, do the following:
- Excel 2000-2003: Use the tools menu, then Add-ins
- Excel 2007:
- Click the Microsoft Office Button, and then click Excel Options.
- On the left bar, click on Add-ins
- On the right pan, Find the Manage Box, Select Excel Add-ins.
- Click GO.
To load an add-in
- If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.
- In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
To unload an add-in
- In the Add-Ins available box, clear the check box next to the add-in you want to unload, and then click OK.
- To remove the add-in from the menu, restart Excel
Note Unloading or removing an add-in from the menu does not remove it from your computer. To remove the add-in from your computer, you must uninstall it.
Our Add-ins (e.g. NumXL, CalendarXL, etc.) for windows are constantly being tested with all existing Excel versions starting from version 97.
Note: we currently don't have a Mac version of our Add-in, and, as a result, our add-ins are not compatible with the all versions of Excel for Mac.
Using Excel built-in function "TRANSPOSE", a column result array can be transformed to a one row.
Example:
The function EWMAi returns an array of values ordered in one column. To re-order the column into a row,pass the EWMA function formula to TRANSPOSE.
=EWMA(
4:
13)
becomes
=TRANSPOSE(EWMA(
4:
13))
Now, select the range in cells in one row, hit F2 to enter editing mode, and hit CTRL+ALT+ENTER.
An array function is a function that returns multiple values (i.e. arry of value). For instance, EWMAi function returns the whole time series of the exponential weighted volatility time series.
An array function returns the value of the first element by default. To expand the values, please select all cells column-wise (starting from the cell with formula), hit F2 to view the formula and hit CTRL+ALT+ENTER together. If successfull, you will see the formula enclosed between italic braces (i.e. {}).
Spider Financial signs the executable binaries (i.e. programs) with its own digital-certificate issued by trusted certificate publisher.
If you see the security warning, this indicates you have the security settings for add-ins to be high; requiring all add-in to be signed by trusted publisher. Furthermore, the security warning also shows that Microsoft Excel recognizes our certificate as valid, but since this is your first add-in from Spider (i.e publisher (i.e. Spider Financial), you have not chosen to trust. Microsoft Excel program requires users to explicity accept the publisher's certificate before it can load the add-in.
To accept the certificate and permits Excel to load the add-in, see the instructions below:
Excel 2007
-
click on the "Options" button on the toolbar
-
Microsoft Office security dialog box pops up on screen. Scroll down to locate the add-in you have just installed. Examine the certificate, and select "Enable all code published by this publisher". Click OK.
- You are done! MS Excel loads the add-in now, and removes the security warning from the toolbar. Please, close all open excel workbooks, and restart MS Excel.
Excel XP/2002
-
Microsoft Excel program pops up a security warning dialog when it tries to load the add-in.
-
Check the "trust this publisher" checkbox, and click Next.
- You are done! MS Excel loads the add-in now, and removes the security warning from the toolbar. Please, close all open excel workbooks, and restart MS Excel.
You can determine the version of Microsoft Office 2007 as follow:
- Find the Office Button in Excel and then click Excel Options.
- In the Microsoft Excel Options dialog, select Resources, and click on the About buttom.
- The About Microsoft Excel dialog box reports that a service pack has been installed. The letters SP with a number after the version number are displayed, for example SP3.
Extend analytic capability of spreadsheets
The primary benefit of using additional functions is easy access to a powerful set of analytics. Each library function performs a calculation within a single worksheet cell, which can be used as part of a bigger calculation, e.g., Time series analysis. In this way, each function can serve as a powerful building block, or subroutine, for assembling sophisticated spreadsheet models.
Save valuable time
Deriving formulas and constructing macros from scratch are error prone processes. For complex calculations, they can demand a good deal of debugging and testing time. And even after a formula or macro has been assembled correctly, copying it to another spreadsheet location or to another spreadsheet can introduce errors. Calling a function within a spreadsheet cell is inherently simpler than solving equations and typing in long, often cryptic, formulas.
Improve spreadsheet accuracy
Library functions guarantee consistent calculation across different spreadsheet locations and different spreadsheets. Each function is carefully designed and tested. The same calculation procedure is invoked each time the function is called, regardless of where it is called from.
Improve spreadsheet performance
Because each function is implemented as a set of machine instructions, it executes much faster than a corresponding formula or macro.
Yes, you can!
You can apply the naming concept for frequently used formulas; the formula doesn't physically have to appear in a cell, and this not only saves memory, but it often makes your worksheets easier to read as well.
Follow these steps to name a formula:
- Choose Insert, Name, Define to display the Define Name dialog box.
- Enter the name you want to use for the formula in the Names in Workbook edit box.
- In the Refers To box, enter the formula exactly as you would if you were entering it in a worksheet.
- Click OK.
NumXL allows you to directly use its functions within your Excel sheet in the same way you would with built-in Excel functions.
In order to illustrate the use of a NumXL function within an Excel sheet, consider the following example:
- Open MS Excel, and create a series of 20 numbers.
- Using Excel toolbar, locate the "Insert function" field (i.e. labeled "fx") and click it with your mouse.
- An "Insert Function" Dialog pops up on the screen (see below)
- Using the dialog fields, fills in the function input by selecting cells from your worksheet (see below)
- For more information about this particular function, click on "Help on this function" hyperlink to bring up the helpfile.
- Once done, click on OK.
Whatever your Excel or NumXL version, it is necessary that the Macros security level is set to High or Medium so that NumXL can run.
To examine the current security setting, use excel menu and find tools, then select Macros and click on Security..
An add-in is an software that add functionalities to Microsoft Excel. Excel Add-in are writtin in Visual basic for Application (VBAi) or in complied language (C/C++). For performance and scalability purposes, we implemented our add-ins (e.g. NumXL, CalendarXL, etc.) using C++.
Web site
All registered users have a password which works like any login password. Passwords help ensure that someone does not masquerade as another editor. Editors should use a strong password to avoid being blocked for bad edits by someone who guesses or "cracks" other users' passwords.
As a rule of thumb a password that is reasonably long, with a mix of upper and lowercase letters and numbers, and not mostly made up of dictionary words or names or personal information (date of birth, cat's name, etc), is likely to be reasonably strong for everyday use. However it is left up to users to decide how strong a password they wish to use beyond this.
Although the definition of "strong password" is deliberately left unspecified, all users are required to use strong passwords and are informed that the developers will occasionally try to crack their passwords and disable those that can be cracked.
You do not have to log in to read the online material our website. Nevertheless, creating an account is quick, free, and non-intrusive, and it is generally considered a good idea to do so for a variety of reasons.
Summary of benefits
- Download products updates.
- View and download use cases and documentation.
- View and participate in SpiderXL user's Forums.
- View and report Bugs and track issues.
- Receive SpiderXL technical newsletter.
Other benefits
- The ability to send and receive e-mails from other users (optional).
- The ability to set personal preferences on your account.
- The ability to keep a watchlist to track changes made to articles that interest you.
The form request button below should be used only to request a reciprocal link. Please note, we are only interested in websites that relate to the products or topics you see on this website.
Please choose one or more of the alternatives, and include the code on an appropriate page in your website. This must be done prior to submitting this link request. If we do not find a link to one of the sites below on the exact page (URL) you specify in this form, we will ignore your request.
Or Email us at: webmaster@spiderfinancial.com



