Sheet: (0, 0) CA-Simply Money (0, 1) SECURITY MACROS (0, 2) NOTE: This macro uses the sequence `| (reverse quote followed with vertical bar) instead of , (comma) to separate the parameters passed to function EXECUTE. This way we allow the use of commas as part of a parameter. (0, 4) CA-Simply Money (0, 5) TRANSACTION MACROS (0, 6) (0, 8) CA-Simply Money (0, 9) CATEGORY MACROS (0, 10) (0, 12) CA-Simply Money (0, 13) GENERAL USE (0, 14) (1, 0) (1, 1) (1, 2) (1, 4) (1, 5) (1, 6) (1, 8) (1, 9) (1, 10) (1, 12) (1, 13) (1, 14) (2, 0) (2, 1) (2, 2) (2, 4) (2, 5) (2, 6) (2, 8) (2, 9) (2, 10) (2, 12) (2, 13) (2, 14) (3, 0) Variables (3, 1) Topics (3, 2) Comments (3, 4) Variables (3, 5) Topics (3, 6) Comments (3, 8) Variables (3, 9) Topics (3, 10) Comments (3, 12) Variables (3, 13) Topics (3, 14) Comments (4, 0) Macro (4, 1) (4, 2) (4, 4) Macro (4, 5) (4, 6) (4, 8) Macro (4, 9) (4, 10) (4, 12) AppName (4, 13) Dollars (4, 14) dde app name (5, 0) Securities Report (5, 1) Securities (5, 2) (5, 4) Transaction Report (5, 5) TransactionsReport (5, 6) (5, 8) Category Report (5, 9) CategoriesReport (5, 10) (5, 12) ExeName (5, 13) CASMMAIN.EXE (5, 14) executable name (6, 0) (6, 1) FALSE (6, 2) open a channel to CASM (6, 4) (6, 5) TRUE (6, 6) (6, 8) (6, 9) TRUE (6, 10) (6, 12) Channel (6, 13) -1 (6, 14) (7, 0) (7, 1) TRUE (7, 2) request Security Name (7, 4) (7, 5) TRUE (7, 6) (7, 8) (7, 9) TRUE (7, 10) (7, 12) (7, 13) (7, 14) (8, 0) names (8, 1) TRUE (8, 2) close channel (8, 4) (8, 5) TRUE (8, 6) (8, 8) (8, 9) TRUE (8, 10) (8, 12) Function (8, 13) (8, 14) (9, 0) symbols (9, 1) TRUE (9, 2) (9, 4) (9, 5) TRUE (9, 6) (9, 8) (9, 9) TRUE (9, 10) (9, 12) InitDollars (9, 13) InitDollars (9, 14) (10, 0) shares (10, 1) TRUE (10, 2) (10, 4) (10, 5) #N/A! (10, 6) (10, 8) (10, 9) TRUE (10, 10) (10, 12) (10, 13) TRUE (10, 14) (11, 0) prices (11, 1) TRUE (11, 2) (11, 4) (11, 5) TRUE (11, 6) (11, 8) SuppressZeros (11, 9) TRUE (11, 10) (11, 12) (11, 13) TRUE (11, 14) (12, 0) (12, 1) TRUE (12, 2) (12, 4) (12, 6) (12, 8) (12, 9) FALSE (12, 10) open a channel to CASM (12, 12) (12, 13) TRUE (12, 14) turn off excel errors (13, 0) name (13, 1) S&P 500 Averag (13, 2) (13, 4) Macro (13, 5) (13, 6) (13, 8) (13, 9) TRUE (13, 10) (13, 12) InitRet (13, 13) TRUE (13, 14) (14, 0) (14, 1) TRUE (14, 2) (14, 4) Transaction Summary (14, 5) TransactionSummary (14, 6) (14, 8) RetCat (14, 9) TRUE (14, 10) request all transactions (14, 12) (14, 13) TRUE (14, 14) (15, 0) (15, 1) TRUE (15, 2) (15, 4) (15, 5) TRUE (15, 6) (15, 8) categories (15, 9) TRUE (15, 10) comes in as 2-dimensional array (15, 12) (15, 13) TRUE (15, 14) (16, 0) symbol (16, 1) SP 50 (16, 2) (16, 4) (16, 5) TRUE (16, 6) (16, 8) (16, 9) TRUE (16, 10) (16, 12) (16, 13) TRUE (16, 14) (17, 0) (17, 1) TRUE (17, 2) (17, 4) (17, 5) TRUE (17, 6) (17, 8) (17, 9) TRUE (17, 10) (17, 12) (17, 13) TRUE (17, 14) (18, 0) (18, 1) TRUE (18, 2) (18, 4) (18, 5) TRUE (18, 6) (18, 8) (18, 9) #N/A! (18, 10) (18, 12) (18, 13) TRUE (18, 14) (19, 0) number (19, 1) 0 (19, 2) (19, 4) (19, 5) #N/A! (19, 6) (19, 8) (19, 9) TRUE (19, 10) next index (19, 12) ExecRet (19, 13) 11758 (19, 14) (20, 0) (20, 1) TRUE (20, 2) (20, 4) (20, 5) TRUE (20, 6) (20, 8) categories (20, 9) TRUE (20, 10) (20, 12) (20, 13) TRUE (20, 14) (21, 1) TRUE (21, 2) (21, 4) (21, 6) (21, 8) (21, 9) TRUE (21, 10) (21, 12) InitRet (21, 13) TRUE (21, 14) (22, 0) (22, 1) TRUE (22, 2) (22, 4) (22, 5) (22, 6) (22, 8) (22, 9) 1 (22, 10) (22, 12) (22, 13) TRUE (22, 14) (23, 0) price (23, 1) 445.049 (23, 2) (23, 4) (23, 5) (23, 6) (23, 8) (23, 9) TRUE (23, 10) (23, 12) (23, 13) TRUE (23, 14) (24, 0) (24, 1) TRUE (24, 2) (24, 4) Function (24, 5) (24, 6) (24, 8) (24, 9) (24, 10) (24, 12) (24, 13) TRUE (24, 14) (25, 0) (25, 1) TRUE (25, 2) (25, 4) GetTransactions (25, 5) GetTransactions (25, 6) (25, 8) (25, 9) (25, 10) (25, 12) (25, 13) TRUE (25, 14) (26, 0) (26, 1) TRUE (26, 2) (26, 4) (26, 5) TRUE (26, 6) (26, 8) Function (26, 9) (26, 10) (26, 12) (26, 13) FALSE (26, 14) (27, 0) (27, 1) TRUE (27, 2) (27, 4) (27, 5) TRUE (27, 6) (27, 8) FillCat (27, 9) FillCat (27, 10) (27, 12) (27, 13) TRUE (27, 14) (28, 0) (28, 1) 1 (28, 2) (28, 4) (28, 5) TRUE (28, 6) (28, 8) (28, 9) TRUE (28, 10) (28, 12) (28, 13) TRUE (28, 14) (29, 1) TRUE (29, 4) (29, 5) TRUE (29, 6) (29, 8) (29, 9) TRUE (29, 10) (29, 12) (29, 13) FALSE (29, 14) (30, 4) (30, 5) FALSE (30, 6) open a channel to CASM (30, 8) category (30, 9) 12754.93 (30, 10) by date, payee, payor, (30, 12) (30, 13) TRUE (30, 14) (31, 0) Macro (31, 1) (31, 2) (31, 4) (31, 5) TRUE (31, 6) (31, 8) (31, 9) TRUE (31, 10) category, and amount (31, 12) (31, 13) (31, 14) (32, 0) Update Prices (32, 1) GetPrice (32, 2) Comments (32, 4) (32, 5) TRUE (32, 6) (32, 8) (32, 9) TRUE (32, 10) (32, 12) (32, 13) (32, 14) (33, 0) (33, 1) FALSE (33, 2) open a channel to CASM (33, 4) RetTran (33, 5) TRUE (33, 6) request all transactions (33, 8) (33, 9) TRUE (33, 10) if we're on the amount column (33, 12) Function (33, 13) (33, 14) (34, 0) (34, 1) TRUE (34, 2) request Security Name (34, 4) transactions (34, 5) TRUE (34, 6) comes in as 2-dimensional array (34, 8) (34, 9) TRUE (34, 10) (34, 12) UnInitDollars (34, 13) UnInitDollars (34, 14) (35, 0) (35, 1) TRUE (35, 2) close channel (35, 4) (35, 5) TRUE (35, 6) (35, 8) (35, 9) TRUE (35, 10) format amount (35, 12) (35, 13) TRUE (35, 14) (36, 0) (36, 1) TRUE (36, 2) (36, 4) (36, 5) TRUE (36, 6) (36, 8) catamt (36, 9) -46037.32 (36, 10) move to next row at date column (36, 13) TRUE (36, 14) return control to Excel (37, 0) Temp (37, 1) TRUE (37, 2) (37, 4) transaction (37, 5) Home Fed Checkin (37, 6) by date, payee, payor, (37, 8) (37, 9) =COLUMN.WIDTH(,,,3) (37, 10) else (37, 12) (37, 13) FALSE (37, 14) (38, 0) (38, 1) TRUE (38, 2) (38, 4) (38, 5) TRUE (38, 6) category, and amount (38, 8) (38, 9) TRUE (38, 10) (38, 12) (38, 13) TRUE (38, 14) (39, 0) (39, 1) TRUE (39, 2) (39, 4) (39, 5) TRUE (39, 6) if we're on the amount column (39, 8) (39, 9) TRUE (39, 10) select next column (39, 12) TermRet (39, 13) TRUE (39, 14) (40, 0) (40, 1) TRUE (40, 2) (40, 4) (40, 5) TRUE (40, 6) format amount (40, 8) (40, 9) TRUE (40, 10) (40, 12) (40, 13) TRUE (40, 14) (41, 0) (41, 1) TRUE (41, 2) (41, 4) (41, 5) TRUE (41, 6) (41, 8) (41, 9) TRUE (41, 10) (41, 12) (41, 13) TRUE (41, 14) (42, 0) (42, 1) TRUE (42, 2) (42, 4) (42, 5) TRUE (42, 6) (42, 8) (42, 9) TRUE (42, 10) (42, 12) (42, 13) TRUE (42, 14) (43, 0) (43, 1) 1 (43, 2) (43, 4) tramt (43, 5) 1430.78 (43, 6) (43, 8) (43, 9) (43, 10) (43, 12) (43, 13) FALSE (43, 14) (44, 0) (44, 1) TRUE (44, 2) (44, 4) (44, 5) =COLUMN.WIDTH(,,,3) (44, 6) (44, 8) Macro (44, 9) (44, 10) (44, 12) (44, 13) TRUE (44, 14) (45, 2) (45, 4) (45, 5) TRUE (45, 6) (45, 8) Balances (45, 9) GetCategorySummary (45, 10) Comments (45, 12) (45, 13) TRUE (46, 0) Function (46, 1) (46, 2) (46, 4) (46, 5) TRUE (46, 6) (46, 8) (46, 9) TRUE (46, 10) (47, 0) GetPriceFromDS (47, 1) GetPriceFromDS (47, 2) (47, 4) (47, 5) TRUE (47, 6) move to next row at date column (47, 8) (47, 9) TRUE (47, 10) (48, 0) (48, 1) TRUE (48, 2) (48, 4) (48, 5) TRUE (48, 6) format date (48, 8) (48, 9) TRUE (48, 10) (49, 0) (49, 1) TRUE (49, 2) (49, 4) (49, 5) TRUE (49, 6) (49, 8) (49, 9) TRUE (49, 10) (50, 0) ExecAck (50, 1) TRUE (50, 2) (50, 4) (50, 5) TRUE (50, 6) (50, 8) (50, 9) FALSE (50, 10) open a channel to CASM (51, 0) RetPrice (51, 1) TRUE (51, 2) (51, 4) (51, 5) TRUE (51, 6) (51, 8) (51, 9) TRUE (51, 10) (52, 0) (52, 1) TRUE (52, 2) (52, 4) (52, 5) TRUE (52, 6) else (52, 8) (52, 9) TRUE (52, 10) (53, 0) (53, 1) (53, 2) (53, 4) (53, 5) TRUE (53, 6) select next column (53, 8) (53, 9) TRUE (53, 10) (54, 0) Macro (54, 1) (54, 2) (54, 4) (54, 5) TRUE (54, 6) end if (54, 8) (54, 9) TRUE (54, 10) (55, 0) Security Transaction Report (55, 1) SecurityTransactionReport (55, 2) (55, 4) (55, 5) TRUE (55, 6) next index (55, 8) (55, 9) TRUE (55, 10) (56, 0) (56, 1) TRUE (56, 2) (56, 4) transactions (56, 5) TRUE (56, 6) (56, 8) CatResult (56, 9) TRUE (56, 10) execute GetTran (57, 0) (57, 1) TRUE (57, 2) (57, 4) (57, 5) TRUE (57, 6) (57, 8) RetCatAmt (57, 9) TRUE (57, 10) (58, 0) (58, 1) TRUE (58, 2) (58, 4) (58, 5) 1 (58, 6) close channel (58, 8) (58, 9) TRUE (58, 10) skip over tax flag (59, 0) (59, 1) TRUE (59, 2) (59, 4) (59, 5) TRUE (59, 6) (59, 8) (59, 9) TRUE (59, 10) (60, 0) (60, 1) FALSE (60, 2) open a channel to CASM (60, 4) (60, 5) (60, 6) (60, 8) (60, 9) TRUE (60, 10) (61, 0) (61, 1) TRUE (61, 2) (61, 4) Macro (61, 5) (61, 6) (61, 8) (61, 9) TRUE (61, 10) (62, 0) (62, 1) TRUE (62, 2) (62, 4) Balances (62, 5) GetTransactionSummary (62, 6) Comments (62, 8) (62, 9) TRUE (62, 10) (63, 0) SRTran (63, 1) TRUE (63, 2) request all transactions (63, 4) (63, 5) FALSE (63, 6) open a channel to CASM (63, 8) camt (63, 9) -46037.32 (63, 10) (64, 0) sectrans (64, 1) TRUE (64, 2) comes in as 2-dimensional array (64, 4) (64, 5) TRUE (64, 6) (64, 8) (64, 9) =COLUMN.WIDTH(,,,3) (64, 10) (65, 0) (65, 1) TRUE (65, 2) (65, 4) (65, 5) TRUE (65, 6) (65, 8) (65, 9) TRUE (65, 10) (66, 0) (66, 1) TRUE (66, 2) (66, 4) (66, 5) TRUE (66, 6) (66, 8) (66, 9) TRUE (66, 10) (67, 0) (67, 1) TRUE (67, 2) (67, 4) (67, 5) TRUE (67, 6) (67, 8) (67, 9) TRUE (67, 10) (68, 0) sectran (68, 1) 3350 (68, 2) (68, 4) (68, 5) TRUE (68, 6) (68, 8) (68, 9) TRUE (68, 10) (69, 0) (69, 1) TRUE (69, 2) (69, 4) (69, 5) TRUE (69, 6) (69, 8) (69, 9) 1 (69, 10) close channel (70, 0) (70, 1) TRUE (70, 2) (70, 4) (70, 5) TRUE (70, 6) (70, 8) (70, 9) TRUE (70, 10) (71, 0) (71, 1) TRUE (71, 2) if we're on the amount column (71, 4) (71, 5) TRUE (71, 6) (72, 0) (72, 1) TRUE (72, 2) format amount (72, 4) (72, 5) TRUE (72, 6) (73, 0) (73, 1) TRUE (73, 2) (73, 4) Temp (73, 5) TRUE (73, 6) execute GetTran (74, 0) noshrs (74, 1) 2083.33 (74, 2) (74, 4) (74, 5) TRUE (74, 6) (75, 0) (75, 1) =COLUMN.WIDTH(,,,3) (75, 2) (75, 4) (75, 5) TRUE (75, 6) (76, 0) (76, 1) TRUE (76, 2) (76, 4) (76, 5) TRUE (76, 6) (77, 0) (77, 1) TRUE (77, 2) (77, 4) (77, 5) TRUE (77, 6) (78, 0) (78, 1) TRUE (78, 2) (78, 4) (78, 5) TRUE (78, 6) (79, 0) (79, 1) TRUE (79, 2) (79, 4) tamt (79, 5) 10077.87 (79, 6) (80, 0) stramt (80, 1) 2768.75 (80, 2) (80, 4) (80, 5) =COLUMN.WIDTH(,,,3) (80, 6) (81, 0) (81, 1) =COLUMN.WIDTH(,,,3) (81, 2) (81, 4) (81, 5) TRUE (81, 6) (82, 0) (82, 1) TRUE (82, 2) (82, 4) (82, 5) TRUE (82, 6) (83, 0) (83, 1) TRUE (83, 2) (83, 4) (83, 5) TRUE (83, 6) (84, 0) (84, 1) TRUE (84, 2) (84, 4) (84, 5) TRUE (84, 6) (85, 0) (85, 1) TRUE (85, 2) (85, 4) (85, 5) 1 (85, 6) close channel (86, 0) comm (86, 1) 120 (86, 2) (86, 4) (86, 5) TRUE (86, 6) (87, 0) (87, 1) =COLUMN.WIDTH(,,,3) (87, 2) (87, 4) (87, 5) (87, 6) (88, 0) (88, 1) TRUE (88, 2) (88, 4) Function (88, 5) (88, 6) (89, 0) (89, 1) TRUE (89, 2) if we're on the amount column (89, 4) GetTranFromDS (89, 5) GetTranFromDS (89, 6) (90, 0) (90, 1) TRUE (90, 2) (90, 4) (90, 5) TRUE (90, 6) (91, 0) (91, 1) TRUE (91, 2) format amount (91, 4) (91, 5) TRUE (91, 6) (92, 0) (92, 1) TRUE (92, 2) (92, 4) (92, 5) TRUE (92, 6) (93, 0) curval (93, 1) 1662.5 (93, 2) (93, 4) (93, 5) TRUE (93, 6) (94, 0) (94, 1) =COLUMN.WIDTH(,,,3) (94, 2) (94, 4) (94, 5) TRUE (94, 6) (95, 0) (95, 1) TRUE (95, 2) (95, 4) TranResult (95, 5) TRUE (95, 6) (96, 0) (96, 1) TRUE (96, 2) (96, 4) RetAmt (96, 5) TRUE (96, 6) (97, 0) (97, 1) TRUE (97, 2) (97, 4) (97, 5) TRUE (97, 6) (98, 0) (98, 1) TRUE (98, 2) (99, 0) (99, 1) TRUE (99, 2) (100, 0) (100, 1) TRUE (100, 2) (101, 0) (101, 1) TRUE (101, 2) else (102, 0) (102, 1) TRUE (102, 2) select next column (103, 0) (103, 1) TRUE (103, 2) end if (104, 0) (104, 1) TRUE (104, 2) next index (105, 0) sectrans (105, 1) TRUE (105, 2) (106, 0) (106, 1) TRUE (106, 2) (107, 0) (107, 1) 1 (107, 2) (108, 0) (108, 1) TRUE (108, 2) (109, 0) (109, 1) TRUE (109, 2) (110, 0) (110, 1) TRUE (110, 2) (111, 0) (111, 1) 1 (111, 2) close channel (112, 0) (112, 1) TRUE (112, 2) (113, 0) (114, 0) (115, 0) Macro (115, 1) (115, 2) (116, 0) Price History Report (116, 1) PriceHistoryReport (116, 2) (117, 0) (117, 1) TRUE (117, 2) (118, 0) (118, 1) TRUE (118, 2) (119, 0) (119, 1) TRUE (119, 2) (120, 0) (120, 1) TRUE (120, 2) (121, 0) (121, 1) FALSE (121, 2) open a channel to CASM (122, 0) (122, 1) TRUE (122, 2) (123, 0) (123, 1) TRUE (123, 2) (124, 0) HTran (124, 1) TRUE (124, 2) request all transactions (125, 0) htrans (125, 1) TRUE (125, 2) comes in as 2-dimensional array (126, 0) (126, 1) TRUE (126, 2) (127, 0) (127, 1) TRUE (127, 2) (128, 0) (128, 1) TRUE (128, 2) (129, 0) histtran (129, 1) 2500 (129, 2) (130, 0) (130, 1) TRUE (130, 2) (131, 0) (131, 1) TRUE (131, 2) if we're on the amount column (132, 0) (132, 1) TRUE (132, 2) (133, 0) (133, 1) TRUE (133, 2) format amount (134, 0) (134, 1) TRUE (134, 2) (135, 0) hamt (135, 1) 343718.9 (135, 2) (136, 0) (136, 1) =COLUMN.WIDTH(,,,3) (136, 2) (137, 0) (137, 1) TRUE (137, 2) (138, 0) (138, 1) TRUE (138, 2) (139, 0) (139, 1) TRUE (139, 2) (140, 0) (140, 1) TRUE (140, 2) else (141, 0) (141, 1) TRUE (141, 2) select next column (142, 0) (142, 1) TRUE (142, 2) end if (143, 0) (143, 1) TRUE (143, 2) next index (144, 0) htrans (144, 1) TRUE (144, 2) (145, 0) (145, 1) TRUE (145, 2) (146, 0) (146, 1) 1 (146, 2) close channel (147, 0) (147, 1) TRUE (147, 2) (148, 0) (148, 1) TRUE (148, 2) (149, 0) (149, 1) TRUE (149, 2) (150, 0) (150, 1) 1 (150, 2) (151, 0) (151, 1) TRUE (151, 2)