Skip to content

Instantly share code, notes, and snippets.

@igotit-anything
igotit-anything / gettime_rfc822.sql
Created September 5, 2016 17:29
MS SQL. RFC822 date format from SQL
// hope result : Thu, 10 May 2007 02:57:50 GMT
SELECT left( datename( dw, getutcdate() ), 3 ) + ', ' +
       convert( varchar(20), getutcdate(), 113 ) + ' GMT'
-----------------------------
Thu, 10 May 2007 05:05:51 GMT
@igotit-anything
igotit-anything / favicon.html
Created September 6, 2016 14:57
favicon expression on the web browser.
<head>
<link rel="shortcut icon" href="myicon.ico" type="image/x-icon">
<link rel="icon" href="myicon.ico" type="image/x-icon">
</head>
// image file format .ico or .png available. size 16x16 / 32x32 available.
@igotit-anything
igotit-anything / .gitignore
Last active September 12, 2016 10:35
.gitignore file for Keil.
####### file info from http://igotit.tistory.com/955
####### Listing files
*.COD
*.HTM
*.I
*.LST
*.MAP
*.M51
*.M66
*.SCR
@igotit-anything
igotit-anything / .gitignore
Created September 12, 2016 12:50
.gitignore Simplicity Studio EFM8
# .gitignore for EFM8 Simplicity Studio.
*.obj
*__i
*.lst
*.mk
*.lnp
*.m51
*.omf
@igotit-anything
igotit-anything / login.cpp
Created September 21, 2016 14:00
Kiwoom OpwnAPI-W Login
/*
Open API-W 사용가능상태 달성.- 로그인하여 매매/시세수신 가능상태.
*/
int CCyDevice2_UITDlg::InitDevice()
{
m_KFOpenAPI.CommConnect(0); // 이것 실행 되면 API 내장 로그인 창이 뜸. 인자 : 0 OpenAPI-W 버전업시 수동방식.
return 0;
}
@igotit-anything
igotit-anything / connection_event_handler.cpp
Created September 21, 2016 14:05
Kiwoom OpwnAPI-W Connection Event Handler
void CCyDevice2_UITDlg::OnEventConnectKfopenapictrl1(long nErrCode)
{
if (nErrCode == 0) // 로그인 성공.
{
Display_Status(_T("Login Success"));
}
else if (nErrCode < 0) //로그인 실패.
{
switch (nErrCode)
{
@igotit-anything
igotit-anything / CWinThread.cpp
Last active September 23, 2016 07:52
User Interface Thread CWinThread's InitInstance
BOOL CCyDevice2_Market_UIT::InitInstance()
{
/// 시작 - 본 CWinThread 와 연동된 CDialog 생성.
m_pCyDevice2_Market_UITDlg[m_emItemtype] = new CCyDevice2_Market_UITDlg(); // this에 연동할 CDialog 동적생성하고 받아둠.
m_pCyDevice2_Market_UITDlg[m_emItemtype]->m_pUIT = this; // CDialog에서 this에 접근하기 위한 변수에 this저장.아래 Create보다 먼저할것.
m_pCyDevice2_Market_UITDlg[m_emItemtype]->Create(IDD_CYDEVICE2_MARKET_UITDLG); // CDialog Create
m_pCyDevice2_Market_UITDlg[m_emItemtype]->ShowWindow(SW_SHOW); // CDialog Show
m_pCyDevice2_Market_UITDlg[m_emItemtype]->UpdateWindow(); // CDialog WM_PAINT
this->m_pMainWnd = m_pCyDevice2_Market_UITDlg[m_emItemtype]; // this(CWinThread)의 m_pMainWnd를 CDialog 로지정.
/// 끝 - 본 CWinThread 와 연동된 CDialog 생성.
@igotit-anything
igotit-anything / CCyDevice2_Market_UITDlg.cpp
Created September 23, 2016 09:49
Kiwoom OpwnAPI-W Request real time MarketData
/*
실시간 Market Data 수신온오프 함수.
인자
p_cyitem : 데이터 수신 온오프할 아이템개체 포인터.
on_off : true : on, false: off
반환값.
-1 : 본 개체 담당 종목군 아님.
*/
int CCyDevice2_Market_UITDlg::MarketDataReal_RcvOnOff(CCyItem * p_cyitem, bool on_off)
{
@igotit-anything
igotit-anything / CCyDevice2_UITDlg.cpp
Last active September 23, 2016 11:45
Kiwoom OpwnAPI-W EventHandler for real time MarketData
/*
실시간 마켓데이터 수신 이벤트.
- 실제 시세데이터 처리는 this 에서 수행되지 않고, 신규 스레드로 생성한 CyDevice2_Market_UITDlg 에서 이뤄짐.
*/
void CCyDevice2_UITDlg::OnReceiveRealDataKfopenapictrl1(LPCTSTR sJongmokCode, LPCTSTR sRealType, LPCTSTR sRealData)
{
m_pUIT->m_pCyDevice2_Market_UIT[emITFutureG]->m_pCyDevice2_Market_UITDlg[emITFutureG]->OnReceiveRealData(sJongmokCode, sRealType, sRealData);
}
////// CCyDevice2_Market_UITDlg.cpp
@igotit-anything
igotit-anything / CyFinAPI_Global.h
Last active September 25, 2016 11:10
Fill from Seller/Buyer Initiated. enum definition
enum enum_FillQBuySell {emQBS_QBuy, emQBS_QSell}; // emQBS_QBuy = 매수체결(매도1호가 체결), emQBS_QSell = 매도체결(매수1호가체결)