public static OSETradeCompanyInfo GetExchangeName(Worksheet sheet, int row, int col) { OSETradeCompanyInfo tmp = new OSETradeCompanyInfo(); tmp.OriginalName = ExcelUtil.GetRange(row, col, sheet).Text.ToString(); return(tmp); }
private static OSETradeCompanyInfo GetTradingInfo(Worksheet sheet, int row, int col, int offset) { OSETradeCompanyInfo companyInfo = new OSETradeCompanyInfo(); companyInfo.OriginalName = ExcelUtil.GetRange(row, col, sheet).Text.ToString(); companyInfo.OPINT = ExcelUtil.GetRange(row, col + offset, sheet).Text.ToString().Replace(",", ""); return(companyInfo); }
public static void GetOS225OPZData(Workbook book, ref OS225OPZOriginData data) { if (book == null || data == null) { return; } Worksheet sheet = book.Worksheets[1] as Worksheet; if (sheet == null) { return; } string updateDate = ExcelUtil.GetRange("A2", sheet).Text.ToString(); data.updateDate = JapanShared.TransferJpDate(updateDate); string putTradingDate = ExcelUtil.GetRange("B4", sheet).Text; putTradingDate = putTradingDate.Replace("プット", ""); data.putTradingDate = JapanShared.TransferJpDate(putTradingDate); string callTradingDate = ExcelUtil.GetRange("I4", sheet).Text; callTradingDate = callTradingDate.Replace("コール", ""); data.callTradingDate = JapanShared.TransferJpDate(callTradingDate); int offset = 17; for (int i = 0; i < 5; i++) { string exchangeCount = ExcelUtil.GetRange(6 + i * offset, 1, sheet).Text.ToString(); exchangeCount = exchangeCount.Replace("(", "").Replace(")", "").Replace("円", "").Replace(",", "").Trim(); data.putExchangeCount.Add(exchangeCount); exchangeCount = ExcelUtil.GetRange(6 + i * offset, 8, sheet).Text.ToString(); exchangeCount = exchangeCount.Replace("(", "").Replace(")", "").Replace("円", "").Replace(",", "").Trim(); data.callExchangeCount.Add(exchangeCount); for (int j = 0; j < 15; j++) { OSETradeCompanyInfo Info = OS225FUU.GetTradingInfo(sheet, 8 + i * offset + j, 2); data.putInfo.Add(Info); Info = OS225FUU.GetTradingInfo(sheet, 8 + i * offset + j, 4); data.putInfo.Add(Info); Info = OS225FUU.GetTradingInfo(sheet, 8 + i * offset + j, 9); data.callInfo.Add(Info); Info = OS225FUU.GetTradingInfo(sheet, 8 + i * offset + j, 11); data.callInfo.Add(Info); } } }
private static void updateCompanyInfo(OSETradeCompanyInfo companyInfo, Dictionary <string, NameMap> nameDic) { foreach (var item in nameDic) { if (item.Key == companyInfo.OriginalName.Trim()) { companyInfo.JapaneseName = item.Value.JapaneseName; companyInfo.EnglishName = item.Value.EnglistName; break; } } }
public static void GetOSOPT35_46Data(Workbook book, ref OSOPT35_46OriginData data, Dictionary <string, NameMap> nameDic) { if (book == null || data == null) { return; } Worksheet sheet = book.Worksheets[1] as Worksheet; if (sheet == null) { return; } string updateDate = ExcelUtil.GetRange("A2", sheet).Text.ToString(); data.updateDate = JapanShared.TransferJpDate(updateDate); int offset = 19; for (int i = 0; i < 10; i++) { string count = ExcelUtil.GetRange(6 + i * offset, 3, sheet).Text.ToString(); data.code.Add(count); count = ExcelUtil.GetRange(6 + i * offset, 12, sheet).Text.ToString(); data.code.Add(count); count = GetExchangeCount2(sheet, 7 + i * offset, 7); data.exchangeCount2.Add(count); count = GetExchangeCount2(sheet, 7 + i * offset, 16); data.exchangeCount2.Add(count); string tmp = GetPutOrCall(sheet, 6 + i * offset, 7); data.putOrCall.Add(tmp); tmp = GetPutOrCall(sheet, 6 + i * offset, 16); data.putOrCall.Add(tmp); OSETradeCompanyInfo exchangeName = GetExchangeName(sheet, 6 + i * offset, 3); updateCompanyInfo(exchangeName, nameDic); data.exchangeName.Add(exchangeName); exchangeName = GetExchangeName(sheet, 6 + i * offset, 12); updateCompanyInfo(exchangeName, nameDic); data.exchangeName.Add(exchangeName); string exchangDate = ExcelUtil.GetRange(6 + i * offset, 6, sheet).Text.ToString(); data.exchangeDate.Add(JapanShared.TransferJpDate(exchangDate)); exchangDate = ExcelUtil.GetRange(6 + i * offset, 15, sheet).Text.ToString(); data.exchangeDate.Add(JapanShared.TransferJpDate(exchangDate)); for (int j = 9; j <= 23; j++) { OSETradeCompanyInfo info = GetTradingInfo(sheet, j + i * offset, 3, 2); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 6, 1); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 12, 2); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 15, 1); updateCompanyInfo(info, nameDic); data.info.Add(info); } } }
private void GetOS225FUUData(Workbook book, ref OS225FUUOriginData data) { if (book == null || data == null) { return; } try { Worksheet sheet = book.Worksheets[1] as Worksheet; if (sheet == null) { return; } string updateDate = ExcelUtil.GetRange("A2", sheet).Text.ToString(); data.updateDate = JapanShared.TransferJpDate(updateDate); int lastUsedRow = sheet.UsedRange.Row + sheet.UsedRange.Rows.Count - 1; int currentRow = 1; while (currentRow <= lastUsedRow) { if (ExcelUtil.GetRange(currentRow, 1, sheet).Value2 != null && ExcelUtil.GetRange(currentRow, 1, sheet).Value2.ToString() != string.Empty) { string text = ExcelUtil.GetRange(currentRow, 1, sheet).Value2.ToString(); if (text.Contains("日経225先物")) { string date = ExcelUtil.GetRange(currentRow + 1, 2, sheet).Text.ToString(); data.OS225FUU.tradingDate1 = JapanShared.TransferJpDate(date); date = ExcelUtil.GetRange(currentRow + 1, 9, sheet).Text.ToString(); data.OS225FUU.tradingDate2 = JapanShared.TransferJpDate(date); for (int i = 0; i < 15; i++) { OSETradeCompanyInfo companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 2); updateCompanyInfo(companyInfo, nameDic); data.OS225FUU.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 4); updateCompanyInfo(companyInfo, nameDic); data.OS225FUU.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 9); updateCompanyInfo(companyInfo, nameDic); data.OS225FUU.info2.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 11); updateCompanyInfo(companyInfo, nameDic); data.OS225FUU.info2.Add(companyInfo); } currentRow += 20; } else if (text.Contains("日経225mini")) { string date = ExcelUtil.GetRange(currentRow + 1, 2, sheet).Text.ToString(); data.OS225FUX.tradingDate1 = JapanShared.TransferJpDate(date); date = ExcelUtil.GetRange(currentRow + 1, 9, sheet).Text.ToString(); data.OS225FUX.tradingDate2 = JapanShared.TransferJpDate(date); for (int i = 0; i < 15; i++) { OSETradeCompanyInfo companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 2); updateCompanyInfo(companyInfo, nameDic); data.OS225FUX.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 4); updateCompanyInfo(companyInfo, nameDic); data.OS225FUX.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 9); updateCompanyInfo(companyInfo, nameDic); data.OS225FUX.info2.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 11); updateCompanyInfo(companyInfo, nameDic); data.OS225FUX.info2.Add(companyInfo); } currentRow += 20; } else if (text.Contains("TOPIX先物")) { string date = ExcelUtil.GetRange(currentRow + 1, 2, sheet).Text.ToString(); data.OSTRADF.tradingDate1 = JapanShared.TransferJpDate(date); date = ExcelUtil.GetRange(currentRow + 1, 9, sheet).Text.ToString(); data.OSTRADF.tradingDate2 = JapanShared.TransferJpDate(date); for (int i = 0; i < 15; i++) { OSETradeCompanyInfo companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 2); updateCompanyInfo(companyInfo, nameDic); data.OSTRADF.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 4); updateCompanyInfo(companyInfo, nameDic); data.OSTRADF.info1.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 9); updateCompanyInfo(companyInfo, nameDic); data.OSTRADF.info2.Add(companyInfo); companyInfo = OS225FUU.GetTradingInfo(sheet, currentRow + 4 + i, 11); updateCompanyInfo(companyInfo, nameDic); data.OSTRADF.info2.Add(companyInfo); } currentRow += 20; } else { currentRow++; } } else { currentRow++; } } } catch (Exception ex) { Logger.Log("GetOS225FUUData failed" + ex.Message); LogMessage("GetOS225FUUData failed"); } }