안녕하세요 예스스탁입니다. 옵션만기라는 이름으로 사용자함수로 만들어서 사용하시면 됩니다. 파일로도 사용자함수 첨부해 드립니다. 옵션만기일이면 1아니면 0을 리턴합니다. if sdate == 19970710 or sdate == 19970814 or sdate == 19970911 or sdate == 19971009 or sdate == 19971113 or sdate == 19971211 or sdate == 19980108 or sdate == 19980212 or sdate == 19980312 or sdate == 19980409 or sdate == 19980514 or sdate == 19980611 or sdate == 19980709 or sdate == 19980813 or sdate == 19980910 or sdate == 19981008 or sdate == 19981112 or sdate == 19981210 or sdate == 19990114 or sdate == 19990211 or sdate == 19990311 or sdate == 19990408 or sdate == 19990513 or sdate == 19990610 or sdate == 19990708 or sdate == 19990812 or sdate == 19990909 or sdate == 19991014 or sdate == 19991111 or sdate == 19991209 or sdate == 20000113 or sdate == 20000210 or sdate == 20000309 or sdate == 20000412 // 2000년 국회의원 선거(-1) or sdate == 20000510 // 석가탄신일(-1) or sdate == 20000608 or sdate == 20000713 or sdate == 20000810 or sdate == 20000914 or sdate == 20001012 or sdate == 20001109 or sdate == 20001214 or sdate == 20010111 or sdate == 20010208 or sdate == 20010308 or sdate == 20010412 or sdate == 20010510 or sdate == 20010614 or sdate == 20010712 or sdate == 20010809 or sdate == 20010913 or sdate == 20011011 or sdate == 20011108 or sdate == 20011213 or sdate == 20020110 or sdate == 20020214 or sdate == 20020314 or sdate == 20020411 or sdate == 20020509 or sdate == 20020612 // 2002년 지방선거(-1) or sdate == 20020711 or sdate == 20020808 or sdate == 20020912 or sdate == 20021010 or sdate == 20021114 or sdate == 20021212 or sdate == 20030109 or sdate == 20030213 or sdate == 20030313 or sdate == 20030410 or sdate == 20030507 // 석가탄신일(-1) or sdate == 20030612 or sdate == 20030710 or sdate == 20030814 or sdate == 20030909 // 추석(-2) or sdate == 20031009 or sdate == 20031113 or sdate == 20031211 or sdate == 20040108 or sdate == 20040212 or sdate == 20040311 or sdate == 20040408 or sdate == 20040513 or sdate == 20040610 or sdate == 20040708 or sdate == 20040812 or sdate == 20040909 or sdate == 20041014 or sdate == 20041111 or sdate == 20041209 or sdate == 20050113 or sdate == 20050207 // 설날+1일(-3) or sdate == 20050310 or sdate == 20050414 or sdate == 20050512 or sdate == 20050609 or sdate == 20050714 or sdate == 20050811 or sdate == 20050908 or sdate == 20051013 or sdate == 20051110 or sdate == 20051208 or sdate == 20060112 or sdate == 20060209 or sdate == 20060309 or sdate == 20060413 or sdate == 20060511 or sdate == 20060608 or sdate == 20060713 or sdate == 20060810 or sdate == 20060914 or sdate == 20061012 or sdate == 20061109 or sdate == 20061214 or sdate == 20070111 or sdate == 20070208 or sdate == 20070308 or sdate == 20070412 or sdate == 20070510 or sdate == 20070614 or sdate == 20070712 or sdate == 20070809 or sdate == 20070913 or sdate == 20071011 or sdate == 20071108 or sdate == 20071213 or sdate == 20080110 or sdate == 20080214 or sdate == 20080313 or sdate == 20080410 or sdate == 20080508 or sdate == 20080612 or sdate == 20080710 or sdate == 20080814 or sdate == 20080911 or sdate == 20081009 or sdate == 20081113 or sdate == 20081211 or sdate == 20090108 or sdate == 20090212 or sdate == 20090312 or sdate == 20090409 or sdate == 20090514 or sdate == 20090611 or sdate == 20090709 or sdate == 20090813 or sdate == 20090910 or sdate == 20091008 or sdate == 20091112 or sdate == 20091210 or sdate == 20100114 or sdate == 20100211 or sdate == 20100311 or sdate == 20100408 or sdate == 20100513 or sdate == 20100610 or sdate == 20100708 or sdate == 20100812 or sdate == 20100909 or sdate == 20101014 or sdate == 20101111 or sdate == 20101209 or sdate == 20110113 or sdate == 20110210 or sdate == 20110310 or sdate == 20110414 or sdate == 20110512 or sdate == 20110609 or sdate == 20110714 or sdate == 20110811 or sdate == 20110908 or sdate == 20111013 or sdate == 20111110 or sdate == 20111208 or sdate == 20120112 or sdate == 20120209 or sdate == 20120308 or sdate == 20120412 or sdate == 20120510 or sdate == 20120614 or sdate == 20120712 or sdate == 20120809 or sdate == 20120913 or sdate == 20121011 or sdate == 20121108 or sdate == 20121213 or sdate == 20130110 or sdate == 20130214 or sdate == 20130314 or sdate == 20130411 or sdate == 20130509 or sdate == 20130613 or sdate == 20130711 or sdate == 20130808 or sdate == 20130912 or sdate == 20131010 or sdate == 20131114 or sdate == 20131212 or sdate == 20140109 or sdate == 20140213 or sdate == 20140313 or sdate == 20140410 or sdate == 20140508 or sdate == 20140612 or sdate == 20140710 or sdate == 20140814 or sdate == 20140911 or sdate == 20141009 or sdate == 20141113 or sdate == 20141211 or sdate == 20150108 or sdate == 20150212 or sdate == 20150312 or sdate == 20150409 or sdate == 20150514 or sdate == 20150611 or sdate == 20150709 or sdate == 20150813 or sdate == 20150910 or sdate == 20151008 or sdate == 20151112 or sdate == 20151210 Then 옵션만기 = 1; Else 옵션만기 = 0; 즐거운 하루되세요 > HI_dllee 님이 쓴 글입니다. > 제목 : 옵션만기일 문의 > var12 = date - int(date/100)*100; //일 var13 = DayOfWeek(date); //요일 if var12 >= 8 and var12 <= 14 and // 8일에서 14일 사이이고 var13 == 4 then 옵션만기일 이렇게 새용하고 있었는데요... 2번째 목요일이 공휴일인경우 그전날로 바뀐다고 알고 있습니다. 수식으로는 힘들것 같고... 옵션 시뮬레이터 만드셨으니.. 옵션 만기일 리스트가 있으실듯 한데.. 과거 옵션 만기일 리스트를 알수 있을까요?