Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Excel add in development in C++ Aplications in finance - Dalton S.

Dalton S. Excel add in development in C++ Aplications in finance - Wiley publishing , 2005. - 425 p.
ISBN 0-470-02469-0
Download (direct link): exceladdindevelopmentincand2005.pdf
Previous << 1 .. 158 159 160 161 162 163 < 164 > 165 166 167 .. 168 >> Next

stack space 161-2, 173-80, 199-201, 227-33, 294, 305-7, 332-3 static add-in memory 162 xlopers 105-60, 162-8, 199-202, 210-13, 238, 332-3 menus 1-2, 7, 9, 249-66 see also toolbars additions 254-66 Alt key 249-50 bars 249-66 checkmarks 260-1 coding/typographical conventions 1-2 command additions 257-60 command specifiers 249-66 concepts 1-2, 9, 249-66 creation processes 249-66 custom menus 249-50, 254, 260-6 deletions 257-8, 264-6 enabled/disabled custom commands/menus 262-3 examples 253-66 help 255-9
ID numbers 249-52, 254-66 information 252-3 levels 249 line types 250 renamed commands 263 -4 right clicks 250-1, 259-60 short-cut menus 250-1 sub-menus 252-66 types 249-50 xlopers 255-66 Microsoft downloads 2-4, 169-70, 214 Microsoft Excel Add-in (*.xla) 72 MINVERSE 351-3 MMULT 21-2, 351-3 models, calibrations 24, 381-2
396 Index
modifiers, function calling conventions 79-80, 168, 189-90 modifying-in-place techniques, memory management 168, 189-90 Module Definition File 90-1 Monte Carlo simulation (MC) 7, 207, 352, 374-81 C/C++ 379-81 concepts 374-81 examples 352, 374-81 VB 376-8
worksheet functions 381 MonteCarlo.cpp 380 monte_carlo_control 379-81 months_from_date 370-1 m_RowByRowArray 123-6 multi-cell range reference conversions, concepts
14-18, 50-3, 64-71, 234-8 multi-tasking 7, 76-7, 296-7, 316-31 multi-threading 7, 76-7, 296-7, 316-31, 374, 379
background task management 318-31, 374, 379
DLLs 76-7, 296-7, 316-31 MultiByteToWideChar 59-61 m_XLtoFree 123-6 MyCppFunction 1
N 16
name classes, concepts 2, 239, 307-9, 317-20 named ranges 2, 7, 15-18, 37, 239-49, 307-9 see also defined range names concepts 2, 37, 239-49, 307-9 good design/practice 37 name_me 314-16 names
basic operations 199-209, 222-5, 234, 239-49
binary names 157, 209-13, 248, 315-16, 375
cells 309-16 decoration 77-8
DLLs 77-82, 85-94, 157, 191-5, 209-13, 216-17, 233-4, 239-49, 310-16 Excel 2, 7, 15-18, 35-40, 199-209, 222-5, 234, 239-49, 310-16 functions 34, 77-8, 80-2, 310-16 menu command names 263 -4 worksheets 35-40, 204-6, 222-5, 234, 239-49, 310-16, 333 XLLs 157, 209-13, 248, 315-16 Ndist 346-9 NdistInv 347-9 ndist_taylor 345-6 NdistTaylor 345-6
.NET add-ins, resource requirements 3-4 NETGetTime.dll 87-94
new 1 New 83-7 New Project 88-9 new_xlstring 99-104 next_rollover 369-71 normal distributions 344-51 NORMDIST 344-51 norm_dist 346-9 norm_dist_inv 347-9 NORMINV 344-51 NORMSDIST 344-51 NORMSINV 344-51
NOW 19, 25, 26-31, 93-4, 285-94, 330-1 nsample_BM 350-1 nsample_BM_pair 349-51 NsampleBoxMuller 350-1 NsampleBoxMullerPair 349-51 NULL arguments 108-60, 204-6 number-arithmetic binary operators (+-*/), concepts 13
numbers
datatypes 10-12, 13-18, 21-3 worksheet-function argument-type conversions
17-18, 21 NumCalls_l 25-9 NumCalls_4 27-9 numcalls 77
object data types, VB 64 object-oriented features (OO)
C++ 2, 105, 121-2 concepts 2, 5, 105, 121-2 VBE 5 OFFSET 21, 27, 37-40 OLE/COM automation 3-4, 49-72, 122, 182, 283, 295-305 commands 300-2 concepts 295-305 functions 302-5
initialisation/un-initialisation processes 297-9 recalculation logic 299-300 worksheet functions 303-5 OleInitialize 297-305 ON.TIME 317 OO see object-oriented... oper 106, 112-18, 119-20, 133-60, 178-80,
187-99, 323-31 see also xlopers concepts 106, 112-18, 119-20, 160 structure 119-20 operators
concepts 13-18, 52-3 evaluation precedence 18 types 13-18, 52-3 Option Base 66-71 Option Explicit 57-61 Option Private 47-8
Index 397
options
dates 363-71
pricing 344, 363-71, 374
parse 342-4 ParseText 342-4 Pascal 3
password protection 22, 158-9 Paste Function dialog 33-5, 41, 73, 87, 91, 96-7, 182-99, 294-5 bugs 184, 195
concepts 33-5, 41, 73, 87, 91, 96-7, 182-99, 294-5 examples 190, 294-5 function categories 185-6, 294-5 path information, access 208-9 percentage operator (, concepts 13-18 performance issues 7-8, 28, 40, 73, 94, 206-7, 285-94, 364 see also execution speeds C/C++ 285-94, 364
concepts 285-94, 364 conclusions 293 large spreadsheets 40, 332 VB 285-94, 364 permissions, macro-sheet commands/functions
188-9
pExcelDisp IDispatch 300-5 pointers, concepts 48-55, 64, 71, 77-8, 107-60,
172-80, 292-4 polling commands, background task management 330-1
precedents, recalculation logic 24-32, 93-4, 189,
306-7
pricing, financial instruments 344, 363-71, 374
Private 47-64
PRIVATE 81-2
Project 83-7, 91-2
Project/NETGetTimeProperties... 91-2
pseudo-random numbers 27, 374-5
Public 47-64
quasi-random numbers 27, 374-7 QueryInterface 297-305
R1C1 cell references
A1 contrasts 9-10, 221, 227-35, 241-9, 311 concepts 9-10, 221, 227-35, 241-9, 311 radio buttons 275 -7 RAND 27, 350, 377-8
random numbers, quasi-random numbers 27, 374-7
random samples 344-5, 374-6 Random_Sample.xls 376 Range 52, 59, 65-71, 378 range references
arrays 68-71, 103-4, 234-5, 247-8
concepts 14-18, 50-3, 64-71, 103-4, 234-5, 247-8 range_name 308-9 RangeName 308-9 RecalcExample 29-31 RecalcExample 29-31 Recalc_Examples.xls 25,31 recalculation logic 7, 12, 19, 22-3, 24-32, 93-4, 299-300, 306-7, 320-31 concepts 7, 12, 19, 22-3, 24-32, 93-4, 299-300, 306-7, 320-31 cross-worksheet dependencies 27-9 data tables 22-3, 31 dependents/precedents 24-32, 93-4, 189,
Previous << 1 .. 158 159 160 161 162 163 < 164 > 165 166 167 .. 168 >> Next