from pandas.core.frame import DataFrame
import win32com.client
import pandas as pd
from pandas import DataFrame

cpnews = win32com.client.Dispatch("CpSysDib.CpMarketWatch")

def get_news_new():
cpnews.SetInputValue(0, "*") #종목코드 입력
cpnews.SetInputValue(1, "2") #1:종목뉴스 2:공시정보
cpnews.SetInputValue(2, "0") #0:처음부터
cpnews.BlockRequest()
count = cpnews.GetHeaderValue(2) #0:수신항목구분목록, 1:시작시간, 2:수신개수
print(cpnews.GetHeaderValue(0)) #수신항목구분목록
print(cpnews.GetHeaderValue(1)) #시작시간
print(cpnews.GetHeaderValue(2)) #수신개수

rows = []
columns = ['시간', '종목코드', '종목명', '항목구분', '내용']
for i in range(count):
time = cpnews.GetDataValue(0, i)
h, m = divmod(time, 100)
rows.append(['%02d:%02d' %(h,m),
cpnews.GetDataValue(1, i),
cpnews.GetDataValue(2, i),
cpnews.GetDataValue(3, i),
cpnews.GetDataValue(4, i)])
df = pd.DataFrame(rows, columns = columns)
return df

get_news_new()