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.
CalendarXL - Frequently Asked Questions
This collection of frequently asked questions (FAQ) provides brief answers to many common questions about CalendarXL Add-in. Please check here for answers before posting a question to one of the forums or before sending email to the support e-mail addresses.
Install/Uninstall
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.
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.
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.
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.
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.
Running CalendarXL
Using CalendarXL
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. {}).
Equity option contract expires (stop trading) on 3rd friday of the month.
To compute the expiry date:
- Using DTGetNWkDay function, compute the calendar date of the third (3rd) friday of the contract delivery month.
- Using DTRoll function, adjust the returned date in (1) using CBOE calendar and using "Following" for business day convention.
The primary motivation for introducing those function is to support international market with a weekend days other than Saturday and Sunday.
The secondary motivation is a shortcut for our users; the user can simply pass the Calendar code instead of calling HOLIDAYS function to construct the list of holidays dates.
As a result of industry analysis and interactions with clients, we find ourselves constantly adding new and revising existing functionality.
You can find the up-to-date list ist of functions with brief description on our website and a detailed description of all functions in CalendarXL reference manual
- Traders who seeks an edge using quantitative strategies
- Portfolio managers who wishes to evaluation current position and construct different scenarios.
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.