2 replies
by phoenix cyan
-------------------------------------------------------------------
Daily
-------------------------------------------------------------------
- yahoo news
- sholin
- gym
- 100 guard/punch
- jap
- piano
-------------------------------------------------------------------
Tasks
-------------------------------------------------------------------
- excel
- option future
- part 1
- Mann excel
- financial bk - stock , warrant
- excel b data 4-6
- excel formula bk
- next rent 1/11
- prog
c:\winnt\microsoft.net\framework\YOURVERSIONNUM and run the installUtil
ftp
- samppple
- vs lib
- schedule task
- determine file to get
- failure alert
- url format
- param format
-url
-p
-u
-time
-local path
- local dir spec
- exception
- log
- config file
- usage
- deframent
- jap test
-bk
-ebook
-net
- excel bk 100
- excel bk
-
- jap
- get learn source code
- win svr study
- insurance
- stamp ebay
- mpf
-------------------------------------------------------------------
ToDo
-------------------------------------------------------------------
-c#
-excel vb
-source safe
-etf
-inv study
-trinormial
-FIX
-proj
-read Analyzing Business Data with Excel
-jap
--------------
house
--------------
- check
- clean
- move
- water
- elec
- lock
- bed 3000
- table 2000
- chair 1000
- lanucher 3000
- fridge 2000
- sofa 3000
- lamp
- shelf
- little table
- wardrone
- pastic drawer
- 15700
- 14400
---------
- bed
- table
- medicine
- chair
-
- kitchen
- heater
- lock
- fan
- air condi
- ceiling
-------------------------------------------------------------------
Notes
-------------------------------------------------------------------
VPN: vpn.lsplab.com
email: 172.26.54.29/exchange
server: prd-ny-mail-01.lsp.labranche.com
remote desktop: 172.16.54.46
- trading - optimize the price
uwant: eatfhgbz
QHHHX-4FPQQ-R6X28-8BPCV-WWGBB ? office 2k3
GMMB7-TV698-H4G6G-JBQTT-R72VD ? WXP
- IDD: 0091
- NY helpdesk: mike - 201-522-9824
jason callas - 201.921.7466.
6:30am to midnight, NY time
- lock: Ctrl-Alt-F
- hk exchange - susana wong 28403765
- VPN pw: gas0
- aim a/c: k2y2k2y2 gas
key lab (Key:k21gjX06QftM5-ek)
- Bloomberg a/c: PhoenixCyan
pw: pgas
- =INT(MOD(RAND()*100,49))+1
- vss
\\Nastinus-01\Dev\Source
folder path, give it a name (something like ?LSP Source?), specify your username, and leave the password field blank
\\Nastinus-01\Dev\Source\pcheung$
cassi0
- Delivery
- curry: 25259334
book
* Option Pricing and Volatility Strategies, Sheldon Natenberg
* Innumeracy, John Allen Paulos
* Getting the Best of It, David Sklansky
* Decision Traps, J. Edward Russo & Paul J. H. Schoemaker
* Options, Futures, and Other Derivatives, John Hull
* Dynamic Hedging, Nassim Taleb
* Fooled by Randomness, Nassim Taleb
* Random Walk Down Wall Street, Malkiel
- office phone #: 35291940
-------------------------------------------------------------------
Monthly Expence
-------------------------------------------------------------------
- rent 7200
- mpf 950
- home 3000
- fund and insurance 5000
- water and elec 1000
- medicine 800
- fare and meal
- gym
- box
-------------------------------------------------------------------
Financial Notes:
-------------------------------------------------------------------
- correlation & voltalarity
- HSI & SPX - who lead who
- . up
up dn
dn dn
dn .
up up
dn dn
- self pattern
- warrant - call/put warrant
- stock exchange = 2nd hand shock market
- stock market - constant money flow
excel:
- SPX = sum of emerging ETF + basket
excel assignment
-
- month strike call | symbol | quantity | price
- auto hide/show column
future/ option
hsi / hkcei
- month loolkup
- 2007/2006
---------------------
- ETF Ticker
---------------------
SPY DIA QQQQ MDY XLB XLV XLP XLY XLE XLF XLI XLK XLU IVV IVW IVE IJH IJK IJJ IJR IJT IJS IEV IYY IYM IYC IYK IYE IYF IYH IYJ IYW IYZ IDU IYG IYR IWV IWZ IWW IWM IWO IWN IWB IWF IWD HHH RKH UTH PPH BHH IIH IAH BBH BDH SMH TTH EWU EWT EWL EWD EWP EWY EWS EWN EWW EWJ EWI EWH EWG EWQ EWC EWZ EWK EWO EWA EWM EZU ELV ELG DSV DSG DGT MTK TMW OEF IOO ICF IBB IGM RWR VTI IGN IGW IGV IWP IWR IWS EFA IGE EPP ILF ITF IXC IXG IXJ IXN IXP VXF SHY IEF TLT LQD RSP FEZ FEU PWC PWO AGG IYT ONEQ EEM DVY TIP EZA VV VO VB VTV VUG VBK VCR VDC VDE VFH VHT VIS VGT VAW VOX VPU VBR ADRE ADRD ADRU ADRA ISI JKD JKE JKF JKG JKH JKI JKJ JKK JKL NYC NY VNQ FXI OOO GLD PEY PGJ IAU KLD PBW PWT PWJ PWB PWY PWP PWV VGK VPL VWO XLG PJP PBE PBJ PEJ PBS PXQ PSI PSJ EFV EFG IWC PZI PID PFM PHJ PPA PXN PKB PXE PIC PXJ PMR PUI FDM ELR EMM EMV EMG DSC KBE KIE KCE SDY RTH SWH OIH MKH EKH WMH PIV PHO PHW PTE PRF XBI XHB XSD PZJ RPV RPG RFV RFG RZV RZG FXE DBC FDL USO FPX QTEC VIG QQEW SLV IEO IEZ IHE IHF IHI GDX IAI IAK IAT ITA ITB DWM DTH DTN DEW DFE DEB DTD DHS DES DOO DOL DND DNH DIM DON DLS DNL DFJ DXJ DLN XES XOP XPH XRT KRE XME FBT FDN FXB FXC FXA FXF FXS FXM GSG VOE VOT
-------------------------------------------------------------------
C# Notes
-------------------------------------------------------------------
- class
{
static self-instance
}
utilize instance - class.instance - single obj operation
-------------------------------------------------------------------
SQL Notes
-------------------------------------------------------------------
-
insert into thingproperties values(1, 'X', 'COLOR', 'GREEN')
insert into thingproperties values(2, 'X', 'COLOR', 'RED')
insert into thingproperties values(3, 'X', 'SHAPE', 'TRIANGLE')
insert into thingproperties values(4, 'X', 'SIZE', 'MEDIUM')
insert into thingproperties values(5, 'X', 'SIZE', 'SMALL')
insert into thingproperties values(6, 'Y', 'COLOR', 'BLUE')
insert into thingproperties values(7, 'Y', 'COLOR', 'GREEN')
insert into thingproperties values(8, 'Y', 'SHAPE', 'CIRCLE')
insert into thingproperties values(9, 'Y', 'SIZE', 'MEDIUM')
insert into thingproperties values(10, 'Z', 'COLOR', 'BLUE')
insert into thingproperties values(11, 'Z', 'COLOR', 'RED')
insert into thingproperties values(12, 'Z', 'SHAPE', 'TRIANGLE')
insert into thingproperties values(13, 'Z', 'SIZE', 'LARGE')
insert into thingproperties values(14, 'Z', 'SIZE', 'SMALL')
SELECT q0.Thing, q0.Property, q0.Value, q1.Property, q1.Value, q2.Property, q2.Value
FROM ThingProperties AS q2 INNER JOIN (ThingProperties AS q0 INNER JOIN ThingProperties AS q1 ON q0.Thing = q1.Thing) ON q2.Thing = q0.Thing
WHERE (((q0.Property)='COLOR') AND ((q0.Value)='RED') AND
((q1.Property)='SHAPE') AND ((q1.Value)='TRIANGLE') AND
((q2.Property)='SIZE') AND ((q2.Value)='SMALL'));
- self inner join
5x 4y 5z
5*5*5 + 4*4*4 + 5*5*5 = 314 rows
- primary key
CREATE TABLE T1 ( PK int IDENTITY PRIMARY KEY, SomeText varchar(100))
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'T1')
DROP TABLE T1
GO
CREATE TABLE T1 ( PK int IDENTITY, SomeTextvarchar(100))
INSERT T1 VALUES ('Value I entered #1')
INSERT T1 (SomeText) VALUES ('Value I entered #2')
SET IDENTITY_INSERT T1 ON
INSERT INTO T1 (PK,SomeText) VALUES (-999,'Row that I forced in with a specific PK')
GO
SET IDENTITY_INSERT T1 OFF
INSERT T1 VALUES ('Value I entered #4')
- PV sql
CREATE FUNCTION PV_fn (
-- Add the parameters for the function here
@fv float, -- future value desired
@i decimal, -- interest rate
@p int -- number of compounding periods)
RETURNS money
AS
BEGIN
-- Declare the return variable here
DECLARE @Result money
-- Add the T-SQL statements to compute the return value here
SELECT @Result = @fv *(1/Power((1+@i),@p))
-- Return the result of the function
RETURN @Result
END
GO
- GUID - random rows
-------------------------------------------------------------------
Technical Notes
-------------------------------------------------------------------
- floating pt #:
- internal representation - gap
- vary in range
- round - may up/down
-------------------------------------------------------------------
C# batch proj notes
-------------------------------------------------------------------
- ftp account
BGILoad.exe ftp://ftp.barclaysglobal.com/inbound/CPCF250120706A.csv FTPleb_uk 3hc46e1!
ftp://ftp.barclaysglobal.com/inbound/" />
-
London\lfp\lfp\Launch\App.config
>FtpTool.cs
-
London\lfp\lfp\ParseTools
- \PORTWAREEXTENSION
C:\download\PTS\classes\ftp.jar
- Archive\Database\Script\Clearing\ftp
- Archive\Database\Script\Clearing\imports
C:\Documents and Settings\LaBrancheHK\My Documents\k2y2\Labranche\source\Applications\London\lfp\lfp\ParseTools\Args.cs
C:\DOCUME~1\LABRAN~1\LOCALS~1\Temp\5624$log4net.dll$v1.1.4322\log4net.ILog.cs
is] Assume the files are downloaded, samples were included in the original email. There is existing code which will be able to determine which file to down load and which file to run next. This will call the new code which will parse the file and save to the database ready for ETFCalc to run. Please implement an interface like the one above. When the code is integrated it will be wrapped in an adaptor class. The ftp code is in VSS if you wish to see it. It is not very sophisticated but it gets the job done.
C:\Documents and Settings\LaBrancheHK\My Documents\k2y2\Labranche\source\Applications\London\lfp\lfp\gen\EntityBaseClasses\JobRecordEntityBase.cs
---------------------------------
- 3 parts:
- ftp
- parse
- save
- items:
System.Data.DataSet
System.Data.DataTable
target table name
job key
job manager
- parseCSV.cs - csv ->DataSet
C:\Documents and Settings\LaBrancheHK\My Documents\k2y2\Labranche\source\Applications\London\lfp\lfp\gen\StoredProcedureCallerClasses\ActionProcedures.cs
C:\Documents and Settings\LaBrancheHK\My Documents\k2y2\Labranche\source\Applications\London\lfp\lfp\lspe.ToolKit\PerTickerCache.cs
--------
refex:
(?<=Total\s+NAV\s+per\s+share\W*)(\b[\d\.]+\b)(?=,)
------------------------
Background
------------------------
ETFCalc is an established ETF fair value service. We want to use this to price ETFs traded from London.
Outline
Import the ETF descriptions from BGI files (samples attached) into a schema that the ETF calc java program can understand, set
up a production environment across London and NY to import the files every day, start and stop the server etc.
The way things are now
The files are ftp?d from IShares, saved to a windows server and loaded into the LSPE-SQL-02::LSPE database by a C# batch process
that runs every night. The LSPE database contains an updated schema that was intended as an upgrade to the LSP data model.
Things have moved on, a schema designed in New York will fulfill this role. We suggest it will be simpler to load the ishares
files into tables that resemble a copy of the existing schema in a database residing in London and run the ETFCalc on this
database.
The ETFCalc service has only been started successfully in NY. We understand the RFA price feed does not cope with the extra
latency to run in London. Running the service in NY is appealing because it keeps most of the market data bandwidth local to
the US. There is a reference installation in New York. Ian has forgotten the name of this machine but will forward it when the
helpdesk in NY respond with the name of the machine. The installation on this machine includes a test configuration file.
Roosevelt Victor wrote the ETFCalc and can provide you with a limited degree of support. He is very busy though. The code is
available from VSS under $\Applications\ETFCalc. Documentation for the ETFCalc is checked into VSS. A copy is attached to this
email.
The requirement is:
Create an environment that loads iSharesEtf files into a database so the ETFCalc process will run and calculate the list of ETFs
attached.
The deliverable includes the loading batch that must be reliable, comply with best practices as described by the New York
administrators and developers.
Integrate this environment with the LSPE database
SQLServer 2005 should be available and the preferred coding tool is C#. We do not want to change the java code if we can help
it.
An attached mail contains details of the sources of the iShares files please test against these files and set up a daily import
for them
Validate the values produced.
Provide some supporting documentation describing how the import functions, critical configuration parameters and deployment
tools.
Import CAPCO/GEM file (attached) to the same end. (a regular feed of Capco files is not available).
Generate a record of which files were loaded when, write this to the database so an audit of the batch is available.
by phoenix cyan
--OK------------------------------------------------------------
Quick, tiny, concentrate, relax => GO
-------------------------------------------------------------------
soak, swim, surf, get points, idea concept, find shortest path and ignore others
-------------------------------------------------------------------
19 on time, cruel US, HARD WORK
-------------------------------------------------------------------
Read: jump point, group focus
-------------------------------------------------------------------
--Thought-----------------------------------------------------
1. General Principle
2. Specific Case
3. Multiple Instances
4. Ramdom Specific Cases
5. Whole World
-------------------------------------------------------------------
--Class--------------------------------------------------------
1. template -> multiple objects
2. At first, regard template as object
-> single operation ( obj )
-> single system interaction (obj <-> sys)
3. multiple objects
4. whole system interaction
-------------------------------------------------------------------
--Object-------------------------------------------------------
1. object -> member -> object
------------------------------------------------------------------
--Must Do----------------------------------------------------
- on time
- fast do
- no smoke
- 7 up
- water
- fruit
- 3 things
- work
- box
- piano
------------------------------------------------------------------
This discussion is closed to new replies.
Trending After Hours posts
Sort by Trending