Alıntı Originally Posted by atakanözbaki Yazıyı Oku
Yüzeysel Veri Alanları


Symbol = "Kod";
Description = "Tanım";
Exchange = "Borsa";
MarketCode = "Piyasa";
SubMarket = "Piy.Alt";
Sector = "Sektör";
DecimalPoint = "Ondalık";
IndexType = "Endeks";
Grup = "Grup";
Seri = "Seri";
Yontem = "Yöntem";
Durum = "Durum";
LastPrice = "Son.Fyt";
LastSize = "Son.Lot";
LastSize2 = "Son.LotH";
LastVol = "Son.Hcm";
LastVol2 = "Son.HcmH";
Direction = "Yön";
BidPrice = "Al.Fyt";
BidSize = "Al.Lot";
BidVol = "Al.Hcm";
AskPrice = "Sat.Fyt";
AskSize = "Sat.Lot";
AskVol = "Sat.Hcm";
HighSession = "Yks";
HighSession1 = "Yks.Sea1";
HighDay = "Yks.Gün";
HighWeek = "Yks.Haf";
HighMonth = "Yks.Ay";
HighYear = "Yks.Yıl";
LowSession = "Dşk";
LowSession1 = "Dşk.Sea1";
LowDay = "Dşk.Gün";
LowWeek = "Dşk.Haf";
LowMonth = "Dşk.Ay";
LowYear = "Dşk.Yıl";
PrevCloseSession = "ÖncK";
PrevCloseDay = "ÖncK.Gün";
PrevCloseWeek = "ÖncK.Haf";
PrevCloseMonth = "ÖncK.Ay";
PrevCloseYear = "ÖncK.Yıl";
NetDifSession = "Frk";
NetDifDay = "Frk.Gün";
NetDifWeek = "Frk.Haf";
NetDifMonth = "Frk.Ay";
NetDifYear = "Frk.Yıl";
NetPerSession = "Frk%";
NetPerDay = "Frk%.Gün";
NetPerWeek = "Frk%.Haf";
NetPerMonth = "Frk%.Ay";
NetPerYear = "Frk%.Yıl";
SizeSession = "Lot";
SizeSession1 = "Lot.Sea1";
SizeDay = "Lot.Gün";
VolSession = "Hcm";
VolSession1 = "Hcm.Sea1";
VolDay = "Hcm.Gün";
WavrSession = "Aort";
WavrSession1 = "Aort.Sea1";
WavrDay = "Aort.Gün";
WavrPeriodic = "Aort.Per";
Wavr2Session = "AortH";
Wavr2Session1 = "AortH.Sea1";
Wavr2Day = "AortH.Gün";
LimitUp = "Tavan";
LimitDown = "Taban";
BazPrice = "Baz";
MarketMakerCode = "PY.Kod";
MarketMakerBid = "PY.Al";
MarketMakerAsk = "PY.Sat";
PriceStep = "Adım";
OpenSession = "Açl.Sea";
OpenDay = "Açl.Gün";
WaitingBidWavr = "B.A.Ort";
WaitingAskWavr = "B.S.Ort";
WaitingBidSize = "B.A.Lot";
WaitingAskSize = "B.S.Lot";
WaitingBidRate = "B.A.O";
WaitingAskRate = "B.S.O";
CanceledBidWavr = "I.A.Ort";
CanceledAskWavr = "I.S.Ort";
TickSession = "Tick";
TickDay = "Tick.Gün";
IzafiSession = "Izafi";
IzafiDay = "Izafi.Gün";
Date = "Tarih";
Time = "Saat";
BalanceSheetPeriod = "Dönem";
Capital = "Sermaye";
OzCapital = "OzSermaye";
PiyDegDefDeg = "Piy/Def";
NetProfit = "Kar";
PublicRatio = "Halk";
NumberOfShares = "Snt.Say";
PriceEarningRatio = "FK-S";
PriceEarningValue = "FK";
MarketValue = "Piy.Değ";
BookValue = "Def.Değ";
BorrowBid = "Öd.Al";
BorrowAsk = "Öd.Sat";
BorrowLast = "Öd.Son";
PrevSettlement = "Önc.Stl";
SettlementPrice = "Stl";
FixingPrice = "Sabit";
ExpiryDate = "Son.Trh";
DaysToExpiry = "K.Gün";
OpenInterest = "AçkP";
OpenInterestDif = "AçkP.Frk";
MoneyflowInput = "Para+";
MoneyflowOutput = "Para-";
MoneyflowTotal = "Para.Tpl";
MoneyflowNetDif = "Para";
MoneyflowNetPer = "Para%";
MoneyflowGraph = "Para.Grf";
GraphSession = "Grf";
GraphDay = "Grf.Gün";
GraphWeek = "Grf.Haf";
GraphWeek1 = "Grf.Haf1";
GraphMonth = "Grf.Ay";
GraphMonth1 = "Grf.Ay1";
GraphMonth3 = "Grf.Ay3";
GraphMonth6 = "Grf.Ay6";
GraphYear = "Grf.Yıl";
GraphYear1 = "Grf.Yıl1";
AI = "A.I";
BSP = "ASP";
BidRate = "Al.O";
AskRate = "Sat.O";
ASP = "SSP";
LastRate = "Son.O";
LastTakas = "Son.Tk";
CY = "CY";
DTM = "DTM";
DTC = "DTC";
RYLD = "R.Yld";
PrevRate = "Pr.O";
PrevPrice = "Pr.Fiy";
PrevDate = "Pr.Trh";
AV = "AV";
SY = "SY";
AVSP = "AVSP";
MinRate = "Min.O";
MaxRate = "Max.O";
AvrRate = "Avr.O";
BidTime = "Al.Saat";
AskTime = "Sat.Saat";
Vade = "Vade";
Valor = "Valor";
Day = "Gün";
Isin = "I.Kod";
Risk = "Risk";
Line = "Line";
AVRCY = "AVRCY";
FI182 = "FI182";
FI273 = "FI273";
FI365 = "FI365";
FI456 = "FI456";
FIGENEL = "FIGENEL";
Wavr2Week = "AortH.Haf";
Wavr2Month = "AortH.Ay";
Wavr2Year = "AortH.Yıl";
SizeWeek = "Lot.Haf";
SizeMonth = "Lot.Ay";
SizeYear = "Lot.Yıl";
VolWeek = "Hcm.Haf";
VolMonth = "Hcm.Ay";
VolYear = "Hcm.Yıl";
HighWeek1 = "Yks.Haf1";
LowWeek1 = "Dşk.Haf1";
PrevCloseWeek1 = "ÖncK.Haf1";
NetDifWeek1 = "Frk.Haf1";
NetPerWeek1 = "Frk%.Haf1";
Wavr2Week1 = "AortH.Haf1";
SizeWeek1 = "Lot.Haf1";
VolWeek1 = "Hcm.Haf1";
HighMonth1 = "Yks.Ay1";
LowMonth1 = "Dşk.Ay1";
PrevCloseMonth1 = "ÖncK.Ay1";
NetDifMonth1 = "Frk.Ay1";
NetPerMonth1 = "Frk%.Ay1";
Wavr2Month1 = "AortH.Ay1";
SizeMonth1 = "Lot.Ay1";
VolMonth1 = "Hcm.Ay1";
HighMonth3 = "Yks.Ay3";
LowMonth3 = "Dşk.Ay3";
PrevCloseMonth3 = "ÖncK.Ay3";
NetDifMonth3 = "Frk.Ay3";
NetPerMonth3 = "Frk%.Ay3";
Wavr2Month3 = "AortH.Ay3";
SizeMonth3 = "Lot.Ay3";
VolMonth3 = "Hcm.Ay3";
HighMonth6 = "Yks.Ay6";
LowMonth6 = "Dşk.Ay6";
PrevCloseMonth6 = "ÖncK.Ay6";
NetDifMonth6 = "Frk.Ay6";
NetPerMonth6 = "Frk%.Ay6";
Wavr2Month6 = "AortH.Ay6";
SizeMonth6 = "Lot.Ay6";
VolMonth6 = "Hcm.Ay6";
HighYear1 = "Yks.Yıl1";
LowYear1 = "Dşk.Yıl1";
PrevCloseYear1 = "ÖncK.Yıl1";
NetDifYear1 = "Frk.Yıl1";
NetPerYear1 = "Frk%.Yıl1";
Wavr2Year1 = "AortH.Yıl1";
SizeYear1 = "Lot.Yıl1";
VolYear1 = "Hcm.Yıl1";
Maturity = "Maturity";
Currency = "Currency";
Coupon = "Coupon";
Spread = "Spread";
Duration = "Duration";
ClosePrice = "Kapanis";
OptionPremiumDay = "Ops.Prim";
BaseSymbol = "Dayanak";
OptionType = "Ops.Tip";
OptionKind = "Ops.Tür";
StrikePrice = "Kull.Fyt";
GrupName = "Grup.Ad";
GrupNo = "Grup.No";
StartDate = "Başl.Trh";
Multiplier = "Çarpan";
DeliveryType = "Uzl.Tip";
PrevSymbol = "Önc.Sembol";
Action = "Aksiyon";
SessionName = "Sea.Ad";
Broker = "Kurum";
Barrier = "Bariyer";
TeorikVal = "Teo.Fyt";
TeorikDif = "Teo.Fark";
TeorikPer = "Teo.%";

DengeFiyat = "Dng.Fyt";
DengeMiktar = "Dng.Lot";
DengeBidKalan = "Dng.Al.K";
DengeAskKalan = "Dng.Sat.K";

DengeLastFark = "Dng.Frk";
DengeLastFarkY = "Dng.Frk%";
DengeLotFark = "Dng.Lot.Frk";


-----------------------
Yüzeysel veri setinin içini hep atıyorum. İçinde varmı bakın
Brüt takasta olan hisseleri bulmak için bana da bir fonksiyon gerekiyor ama,Bu konuda herhangi bir fonksiyon bulamadım.Bilen var mı ?