예스스탁
예스스탁 답변
2014-09-25 08:37:37
안녕하세요? 예스스탁입니다.
내용 확인해 보았는데, 원본 데이터의 날짜와 시간이 데이터매니져에서 사용하는 것과 다르기 때문에 정상적으로 로드하지 못했습니다.
날짜는 8자리로 예를 들어 20140922 또는 2014-09-22 와 같이 작성되어 있어야 합니다.
시간은 6자리로 예를 들어 093000 또는 09:30:00 과 같이 작성되어 있어야 합니다.
위 형식으로 날짜와 시간을 맞춰서 다시 적용해 보시면 될것으로 판단됩니다.
감사합니다.
> 헝글베리핀 님이 쓴 글입니다.
> 제목 : 예스트레이져 데이터 매니져
> csv 파일을 데이타 매니져로 차트에 적용하고 싶은데 도움부탁드립니다.
대이타매니져에 설정을 어떻게 해야하는지 알려주시면 고맙겠습니다.
아스키 불러오기하면 데이타 매니져가 멈춰버립니다.
제가한 설정은
종목편집에
종목코드는 deposit, 데이터명은 데일리FX, 거래소는 KRX, 데이터는 ASC||, 진법은 10, 호가단위는 0, 소수점자리수는 0 입니다.
아스키불러오기에서
주기는 틱으로, 시작행은 0, 타임존은 익스체인지, 종목은 미지정으로, 구분자는 콤마로 하였습니다.
파일올리는것이 TEXT파일은 안되어서 엑셀파일로 변환해서 올립니다.
밑에는 csv파일 원본입니다.
Date,Time,Time Zone,Currency,Event,Importance,Actual,Forecast,Previous
Sun Sep 21,01:15,GMT,usd,"Fed's George Speaks on the Economy in Cheyenne, Wyoming",locale.,,,
Sun Sep 21,22:00,GMT,nzd,NZD Westpac NZ Consumer Confidence (3Q),Low,116.7,,121.2
Mon Sep 22,05:00,GMT,jpy,JPY Supermarket Sales (YoY),Low,,,-2.1%
Mon Sep 22,07:00,GMT,chf,CHF Money Supply M3 (YoY) (AUG),Low,,--,3.50%
Mon Sep 22,07:00,GMT,jpy,JPY Convenience Store Sales (YoY) (AUG),Low,,--,-0.70%
Mon Sep 22,08:00,GMT,eur,EUR Italian Industrial Sales s.a. (MoM) (JUL),Low,,--,--
Mon Sep 22,08:00,GMT,eur,EUR Italian Industrial Sales n.s.a. (YoY) (JUL),Low,,--,--
Mon Sep 22,08:00,GMT,eur,EUR Italian Industrial Orders s.a. (MoM) (JUL),Low,,--,--
Mon Sep 22,08:00,GMT,eur,EUR Italian Industrial Orders n.s.a. (YoY) (JUL),Low,,--,--
Mon Sep 22,09:00,GMT,eur,EUR Istat Releases New GDP Series up to 2013 Based on ESA2010,Low,,,
Mon Sep 22,10:00,GMT,USD,USD Existing Home Sales (AUG),locale.med,,5.20M,5.15M
Mon Sep 22,10:00,GMT,USD,USD Existing Home Sales (MoM) (AUG),locale.med,,1.00%,2.40%
Mon Sep 22,10:05,GMT,USD,USD Fed's William Dudley Speaks on U.S. Economy,locale.med,,,
Mon Sep 22,10:30,GMT,eur,ECB's Praet Discusses Future of Monetary System ,Low,,,
Mon Sep 22,12:30,GMT,usd,USD Chicago Fed National Activity Index (AUG),Low,,0.33,0.39
Mon Sep 22,13:00,GMT,eur,ECB's Draghi Speaks to EU Parliament Committee in Brussels,Low,,,
Mon Sep 22,14:00,GMT,usd,USD Existing Home Sales(MoM),Medium,,1.0%,2.4%
Mon Sep 22,14:00,GMT,usd,USD US Existing Home sales,Medium,,5.20M,5.15M
Mon Sep 22,14:00,GMT,eur,EUR Euro-Zone Consumer Confidence (SEP A),Low,,-10.5,-10.0
Mon Sep 22,14:05,GMT,usd,Feds Dudley Speaks in New York ,Low,,,
Mon Sep 22,19:30,GMT,USD,USD Fed's Narayana Kocherlakota Speaks on Monetary Policy,locale.med,,,
Mon Sep 22,23:30,GMT,aud,AUD ANZ Roy Morgan Consumer Confidence Weekly ,Medium,,,111.3
Mon Sep 22,23:30,GMT,usd,Fed's Kocherlakota Speaks on Monetary Policy in Michigan,Medium,,,
Tue Sep 23,01:15,GMT,usd,Fed's George speaks on the economy in Cheyenne Wymoming ,locale.,,,
Tue Sep 23,01:45,GMT,cny,CNY Westpac-MNI Consumer Sentiment (SEP),Low,,--,113.3
Tue Sep 23,01:45,GMT,cny,CNY HSBC Purchasing Manager Index Manufacturing (SEP P),High,,50.0,50.2
Tue Sep 23,06:45,GMT,eur,EUR French Gross Domestic Product (YoY) (2Q F),locale.med,,0.10%,0.10%
Tue Sep 23,06:45,GMT,eur,EUR French Manufacturing Confidence Indicator (SEP),Low,,96,96
Tue Sep 23,06:45,GMT,eur,EUR French Business Confidence (SEP),Low,,91,91
Tue Sep 23,06:45,GMT,eur,EUR French Gross Domestic Product (QoQ) (2Q F),locale.med,,0.0%,0.00%
Tue Sep 23,06:45,GMT,eur,EUR French Own-Company Production Outlook (SEP),Low,,-5,-7
Tue Sep 23,06:45,GMT,eur,EUR French Production Outlook Indicator (SEP),Low,,-22,-20
Tue Sep 23,07:00,GMT,eur,EUR Markit French Purchasing Manager Index Manufacturing (SEP P),locale.med,,47.0,46.9
Tue Sep 23,07:00,GMT,eur,EUR Markit French Purchasing Manager Index Services (SEP P),locale.med,,50.2,50.3
Tue Sep 23,07:00,GMT,eur,EUR Markit French Purchasing Manager Index Composite (SEP P),locale.med,,49.4,49.5
Tue Sep 23,07:30,GMT,eur,EUR Markit German Purchasing Manager Index Manufacturing (SEP P),High,,51.2,51.4
Tue Sep 23,07:30,GMT,eur,EUR Markit German Purchasing Manager Index Services (SEP P),High,,54.6,54.9
Tue Sep 23,07:30,GMT,eur,EUR Markit German Purchasing Manager Index Composite (SEP P),High,,53.5,53.7
Tue Sep 23,08:00,GMT,eur,EUR Markit Euro-Zone Purchasing Manager Index Services (SEP P),High,,53.0,53.1
Tue Sep 23,08:00,GMT,eur,EUR Markit Euro-Zone Purchasing Manager Index Manufacturing (SEP P),High,,50.6,50.7
Tue Sep 23,08:00,GMT,eur,EUR Markit Euro-Zone Purchasing Manager Index Composite (SEP P),High,,52.5,52.5
Tue Sep 23,08:30,GMT,gbp,GBP Public Sector Net Borrowing ex Interventions (Pounds) (AUG),Low,,11.8B,--
Tue Sep 23,08:30,GMT,gbp,GBP BBA Loans for House Purchase (AUG),Low,,42913,42792
Tue Sep 23,08:30,GMT,gbp,GBP Public Finances (PSNCR) (Pounds) (AUG),Low,,6.0B,-9.7B
Tue Sep 23,08:30,GMT,gbp,GBP Public Sector Net Borrowing- Central Government (NCR) (AUG),Low,,,-2.4B
Tue Sep 23,08:30,GMT,gbp,GBP Public Sector Net Borrowing (Pounds) (AUG),Low,,10.5B,-1.1B
Tue Sep 23,09:00,GMT,USD,USD Fed's James Bullard Speaks on U.S. Economy,locale.med,,,
Tue Sep 23,09:30,GMT,USD,USD Fed's George Speaks on U.S. Economy,locale.med,,,
Tue Sep 23,12:30,GMT,cad,CAD Retail Sales (MoM) (JUL),High,,0.5%,1.10%
Tue Sep 23,12:30,GMT,cad,CAD Retail Sales Less Autos (MoM) (JUL),High,,0.0%,1.50%
Tue Sep 23,13:00,GMT,usd,USD FHFA House Price Index (MoM) (JUL),Low,,0.50%,0.40%
Tue Sep 23,13:20,GMT,usd,Fed's Powel Speaks at Community Banks Conference in St. Louis ,Low,,,
Tue Sep 23,13:30,GMT,usd,Fed's George Speaks at Community Bank Conference in Michigan ,Low,,,
Tue Sep 23,13:45,GMT,usd,USD Markit US Manufacturing PMI,High,,58.0,57.9
Tue Sep 23,14:00,GMT,usd,USD Richmond Fed Manufacturing Index (SEP),Low,,10,12
Tue Sep 23,14:00,GMT,USD,USD Fed's Narayana Kocherlakota Speaks on U.S. Economy,locale.med,,,
Tue Sep 23,18:00,GMT,,Fed's Kocherlakota holds town hall forum ,locale.,,,
Tue Sep 23,18:00,GMT,usd,Fed's Kocherlakota holds Town Hall Forum in Michigan ,Low,,,
Tue Sep 23,18:45,GMT,NZD,NZD Exports (New Zealand dollars) (AUG),locale.med,,--,3.70B
Tue Sep 23,18:45,GMT,NZD,NZD Balance (YTD) (New Zealand dollars) (AUG),locale.med,,--,1287M
Tue Sep 23,18:45,GMT,NZD,NZD Imports (New Zealand dollars) (AUG),locale.med,,--,4.40B
Tue Sep 23,20:00,GMT,AUD,AUD Conference Board Leading Index (JUL),locale.med,,--,0.40%
Tue Sep 23,21:15,GMT,USD,USD Fed's Esther George Speaks on U.S. Economy,locale.med,,,
Tue Sep 23,21:35,GMT,JPY,JPY Markit/JMMA Purchasing Manager Index Manufacturing (SEP P),locale.med,,--,52.2
Tue Sep 23,22:45,GMT,nzd,NZD Exports ,Low,,3.20B,3.70B
Tue Sep 23,22:45,GMT,nzd,NZD Trade Balance ,Low,,-1125M,-692M
Tue Sep 23,23:45,GMT,nzd,NZD Imports ,Low,,4.45B,4.40B
Wed Sep 24,00:00,GMT,aud,AUD Confidence Board Leading Index ,Low,,,0.4%
Wed Sep 24,01:00,GMT,aud,AUD Skilled Vacancies (MoM) (AUG),Low,,--,0.90%
Wed Sep 24,01:15,GMT,usd,"Fed's George Speaks on the Economy in Cheyenne, Wymoming ",locale.,,,
Wed Sep 24,01:30,GMT,aud,RBA Stability Review ,Low,,,
Wed Sep 24,01:30,GMT,aud,RBA Financial Stability Review,locale.,,,
Wed Sep 24,01:35,GMT,jpy,JPY Markt/JMMA Japan Manufacturing ,High,,,52.2
Wed Sep 24,06:00,GMT,chf,CHF UBS Consumption Indicator (AUG),Low,,--,1.66
Wed Sep 24,08:00,GMT,eur,EUR German IFO - Expectations (SEP),High,,101.2,101.7
Wed Sep 24,08:00,GMT,eur,EUR German IFO - Business Climate (SEP),High,,105.8,106.3
Wed Sep 24,08:00,GMT,eur,EUR German IFO - Current Assessment (SEP),High,,110.2,111.1
Wed Sep 24,08:00,GMT,eur,EUR Italian Consumer Confidence Index s.a. (SEP),Low,,101.0,101.9
Wed Sep 24,11:00,GMT,usd,USD MBA Mortgage Applications (SEP 19),Low,,--,7.90%
Wed Sep 24,12:05,GMT,USD,USD Fed's Mester Speaks on Monetary Policy,locale.med,,,
Wed Sep 24,13:00,GMT,USD,USD Fed's Charles Evans Speaks on U.S. Economy,locale.med,,,
Wed Sep 24,14:00,GMT,usd,USD New Home Sales (MoM) (AUG),High,,4.40%,-2.40%
Wed Sep 24,14:00,GMT,usd,USD New Home Sales (AUG),High,,430K,412K
Wed Sep 24,14:30,GMT,usd,USD DOE U.S. Crude Oil Inventories (SEP 19),Low,,--,3673K
Wed Sep 24,14:30,GMT,usd,USD DOE U.S. Distillate Inventory (SEP 19),Low,,--,279K
Wed Sep 24,14:30,GMT,usd,USD DOE U.S. Gasoline Inventories (SEP 19),Low,,--,-1635K
Wed Sep 24,16:00,GMT,eur,EUR French Total Jobseekers (AUG),Low,,--,3424.4k
Wed Sep 24,16:00,GMT,eur,EUR French Total Jobseekers Change (AUG),Low,,--,26.1
Wed Sep 24,16:05,GMT,usd,Fed's Mester Speaks on Monetary Policy in Cleveland ,Medium,,,
Wed Sep 24,17:00,GMT,usd,Fed's Evan Speaks at Labor Conference Washington ,Low,,,
Wed Sep 24,21:30,GMT,AUD,AUD Job Vacancies (AUG),locale.med,,--,2.50%
Wed Sep 24,23:50,GMT,jpy,JPY PPI Service Price (YoY) (AUG),Low,,3.70%,3.70%
Thu Sep 25,00:00,GMT,GBP,GBP Nationwide House Prices s.a. (MoM) (SEP),Low,,--,0.80%
Thu Sep 25,00:00,GMT,GBP,GBP Nationwide House Prices n.s.a. (YoY) (SEP),Low,,--,11.00%
Thu Sep 25,01:30,GMT,aud,AUD Job Vacancies,Low,,,2.5%
Thu Sep 25,02:30,GMT,aud,RBA's Stevens Remarks at Melbourne Economic Forum ,Low,,,
Thu Sep 25,04:00,GMT,EUR,EUR Italian Hourly Wages (MoM) (AUG),Low,,--,0.00%
Thu Sep 25,04:00,GMT,EUR,EUR Italian Hourly Wages (YoY) (AUG),Low,,--,1.10%
Thu Sep 25,05:00,GMT,EUR,EUR Italian Retail Sales (YoY) (JUL),Low,,--,-2.60%
Thu Sep 25,05:00,GMT,EUR,EUR Italian Retail Sales s.a. (MoM) (JUL),Low,,--,0.00%
Thu Sep 25,08:00,GMT,eur,M3 3-month average ,Low,,1.8%,1.5%
Thu Sep 25,08:00,GMT,eur,EUR Euro-Zone M3 s.a. (3M) (AUG),Low,,1.80%,1.50%
Thu Sep 25,08:00,GMT,eur,ECB President Draghi speaks in Vilnius,Low,,,
Thu Sep 25,08:00,GMT,eur,EUR Euro-Zone M3 s.a. (YoY) (AUG),Low,,1.90%,1.80%
Thu Sep 25,08:00,GMT,eur,M3 Money Supply YoY,Low,,1.9%,1.8%
Thu Sep 25,08:30,GMT,USD,USD Initial Jobless Claims (SEP 20),locale.med,,--,280K
Thu Sep 25,08:30,GMT,USD,USD Continuing Claims (SEP 13),locale.med,,--,2429K
Thu Sep 25,09:45,GMT,USD,USD Markit Purchasing Manager Index Services (SEP P),locale.med,,--,59.5
Thu Sep 25,09:45,GMT,USD,USD Markit Purchasing Manager Index Composite (SEP P),locale.med,,--,59.7
Thu Sep 25,10:00,GMT,gbp,GBP CBI Reported Sales (SEP),Low,,33,37
Thu Sep 25,12:30,GMT,usd,USD Durable Goods Orders ,High,,-18.00%,22.60%
Thu Sep 25,12:30,GMT,usd,USD Durables ex Transportation (AUG),High,,0.70%,-0.70%
Thu Sep 25,12:30,GMT,usd,USD Non-Defense Capital Goods Shipments ex Aircrafts (AUG),Low,,0.8%,1.40%
Thu Sep 25,12:30,GMT,usd,USD Non-Defense Capital Goods Orders ex Aircrafts (AUG),Low,,0.40%,-0.70%
Thu Sep 25,12:30,GMT,cad,CAD Average Weekly Earnings (YoY) (JUL),Low,,--,3.30%
Thu Sep 25,12:40,GMT,gbp,BOE's Carney Delivers Speech in Wales ,Medium,,,
Thu Sep 25,13:20,GMT,USD,USD Fed's Dennis Lockhart Speaks on U.S. Economy,locale.med,,,
Thu Sep 25,13:45,GMT,usd,USD Markit US Composite PMI,High,,,59.7
Thu Sep 25,13:45,GMT,usd,USD Markit Services PMI,High,,59.2,59.5
Thu Sep 25,15:00,GMT,usd,USD Kansas City Fed Manufacturing Activity (SEP),Low,,6,3
Thu Sep 25,17:20,GMT,usd,"Fed's Lockhart Speaks On Economy In Jackson, Mississippi ",Low,,,
Thu Sep 25,19:30,GMT,JPY,JPY Tokyo Consumer Price Index (YoY) (SEP),locale.med,,2.70%,2.80%
Thu Sep 25,23:01,GMT,gbp,GBP Hometrack Housing Survey (YoY) ,Low,,--,5.50%
Thu Sep 25,23:01,GMT,gbp,GBP Hometrack Housing Survey (MoM) ,Low,,--,0.10%
Thu Sep 25,23:30,GMT,jpy,JPY National Consumer Price Index Ex-Fresh Food (YoY) ,High,,3.20%,3.30%
Thu Sep 25,23:30,GMT,jpy,"JPY National Consumer Price Index Ex Food, Energy (YoY) ",High,,2.30%,2.30%
Thu Sep 25,23:30,GMT,jpy,JPY Tokyo Consumer Price Index Ex-Fresh Food (YoY) (SEP),locale.med,,2.60%,2.70%
Thu Sep 25,23:30,GMT,jpy,"JPY Tokyo Consumer Price Index Ex Food, Energy (YoY)",locale.med,,2.10%,2.10%
Thu Sep 25,23:30,GMT,jpy,JPY National Consumer Price Index (YoY) (AUG),High,,3.30%,3.40%
Thu Sep 25,23:50,GMT,jpy,JPY Foreign Buying Japan Bonds (Yen) (SEP 19),Low,,, ¥839.0B
Thu Sep 25,23:50,GMT,jpy,JPY Japan Buying Foreign Bonds (Yen) (SEP 19),Low,,--,-¥401.4B
Thu Sep 25,23:50,GMT,jpy,JPY Japan Buying Foreign Stocks (Yen) (SEP 19),Low,,--, ¥248.3B
Thu Sep 25,23:50,GMT,jpy,Foreign Buying Japan Stocks ,Low,,, ¥136.8B
Fri Sep 26,02:00,GMT,cny,CNY Conference Board Leading Economic Index (AUG),Low,,,
Fri Sep 26,06:00,GMT,eur,EUR German GfK Consumer Confidence Survey (OCT),Low,,8.5,8.6
Fri Sep 26,06:00,GMT,eur,EUR German Import Price Index (YoY) (AUG),Low,,-2.0%,-1.70%
Fri Sep 26,06:00,GMT,eur,EUR German Import Price Index (MoM) (AUG),Low,,-0.2%,-0.40%
Fri Sep 26,06:45,GMT,eur,EUR French Consumer Confidence (SEP),Low,,86,86
Fri Sep 26,08:00,GMT,eur,EUR Italian Economic Sentiment (SEP),Low,,--,88.2
Fri Sep 26,08:00,GMT,eur,EUR Italian Business Confidence (SEP),Low,,95.3,95.7
Fri Sep 26,10:00,GMT,eur,ECB's Coene Speaks at Lunch Conference in Brussels,Low,,,
Fri Sep 26,10:00,GMT,eur,ECB announces 3 year LTRO Repayment ,Medium,,,
Fri Sep 26,12:30,GMT,usd,USD Gross Domestic Product (Annualized) (2Q T),High,,4.60%,4.20%
Fri Sep 26,12:30,GMT,usd,USD Core Personal Consumption Expenditure (QoQ) ,Medium,,2.00%,2.00%
Fri Sep 26,12:30,GMT,usd,Core PCE (QoQ),High,,2.0%,2.0%
Fri Sep 26,12:30,GMT,usd,USD Personal Consumption (2Q T),Medium,,2.90%,2.50%
Fri Sep 26,13:30,GMT,aud,RBA's Richards Speech in Chicago ,Low,,,
Fri Sep 26,13:55,GMT,usd,USD U. of Michigan Confidence (SEP F),High,,84.7,84.6
Fri Sep 26,21:30,GMT,CNY,CNY Industrial Profits (YoY) (AUG),locale.med,,--,13.50%