Jump to content

Recommended Posts

Posted

Hi , i have a script for create a link of binance  data collaction , my script works so it takes all the tickers from a txt sheet puts them in an array and then cycles them to build the zip address to download, but it stops after a few tickers and I can't understand why anyone can help me ?? thank you all

my script

#include <Array.au3>
#include <Color.au3>
#include <GuiRichEdit.au3>
#include <GUIConstantsEx.au3>
#include <GUIListBox.au3>
#include <WindowsConstants.au3>
#include <GuiListView.au3>
#include <MsgBoxConstants.au3>
#include <GuiStatusBar.au3>
#include <MsgBoxConstants.au3>
#include <WinAPIFiles.au3>
#include <Date.au3>
#include <File.au3>

$CDateInv = (@YEAR & "-" & @MON & "-" & (@MDAY - 1))

Global $aTimeFrame[12] = ["12h", "15m", "1d", "1h", "1m", "2h", "30m", "3m", "4h", "5m", "6h", "8h"]
; list spot
Global $aTypeTime[2] = ["daily", "monthly"]
Global $aType[3] = ["aggTrades", "klines", "trades"]
Global $aTypeTrade[2] = ["spot", "futures"]
; list futures
Global $aTypeTimeFu[2] = ["daily", "monthly"]
Global $aTypeFu[2] = ["cm", "um"]
Global $aTypeTimeFu[2] = ["daily", "monthly"]
Global $aType[6] = ["aggTrades", "indexPriceKlines", "klines", "markPriceKlines", "premiumIndexKlines", "trades"]

Global $aAllSynbol = FileReadToArray("C:\Users\pc\Desktop\dacancellare\tickerbinance.txt")

Global $sBinSPOTaddres = "https://data.binance.vision/data/spot/"
Global $sBinFUTURESaddres = "https://data.binance.vision/data/futures/"

Global $CDateInv = (@YEAR & "-" & @MON & "-" & (@MDAY - 1))
Global $aGFile[30000], $a = 1
For $i = 0 To UBound($aTypeTime) - 1 ;daily
    For $j = 0 To UBound($aType) - 1  ;klines
        For $h = 0 To UBound($aAllSynbol) - 1   ; simboli

            If $aType[$j] = "aggTrades" Or $aType[$j] = "trades" Then

            EndIf
            If $aType[$j] = "klines" Then
                For $k = 0 To UBound($aTimeFrame) - 1   ;timeframe
                    ; for $l=1 to 381  ;

                    If $CDateInv >= "2021-03-01" Then
                        If $aAllSynbol[$h] <> "" Then
                            $sFilePath = ("C:\Users\pc\Desktop\binancehistory\" & $aAllSynbol[$h] & "-" & $aTimeFrame[$k] & "-" & $CDateInv & ".zip ")
                            $urlDW = ($sBinSPOTaddres & $aTypeTime[$i] & "/" & $aType[$j] & "/" & $aAllSynbol[$h] & "/" & $aTimeFrame[$k] & "/" & $aAllSynbol[$h] & "-" & $aTimeFrame[$k] & "-" & $CDateInv & ".zip ")
                            ; Run ( "C:\Users\pc\Desktop\dacancellare\wget\bin\wget.exe "&$urlDW)
                            ; Run(@ComSpec & " /c " & 'C:\Users\pc\Desktop\dacancellare\wget\bin\wget.exe '&$urlDW, "")
                            ;Local $hDownload = InetGet($urlDW, $sFilePath, 2, 0)
                            ;ConsoleWrite($hDownload& @CRLF)

                            ConsoleWrite($urlDW & @CRLF)
                            ;sleep(5000)

                            Local $sNewDate = _DateAdd('d', "-" & $h, $CDateInv)
                            $aFDate = StringSplit($sNewDate, "/")
                            $CDateInv = $aFDate[1] & "-" & $aFDate[2] & "-" & $aFDate[3]
                            ;ConsoleWrite($CDateInv& @CRLF)

                        EndIf

                    EndIf
                    ; next
                Next
            EndIf

        Next
    Next
Next

#cs

; Create a file in the users %TEMP% directory.
Local $sFilePath = "C:\Users\pc\Desktop\binancehistory\link.txt"

; Write array to a file by passing the file name.
_FileWriteFromArray($sFilePath, $aGFile, 1)

#ce

my txt for tiker

Quote
ETHBTC
LTCBTC
BNBBTC
NEOBTC
QTUMETH
EOSETH
SNTETH
BNTETH
BCCBTC
GASBTC
BNBETH
BTCUSDT
ETHUSDT
HSRBTC
OAXETH
DNTETH
MCOETH
ICNETH
MCOBTC
WTCBTC
WTCETH
LRCBTC
LRCETH
QTUMBTC
YOYOBTC
OMGBTC
OMGETH
ZRXBTC
ZRXETH
STRATBTC
STRATETH
SNGLSBTC
SNGLSETH
BQXBTC
BQXETH
KNCBTC
KNCETH
FUNBTC
FUNETH
SNMBTC
SNMETH
NEOETH
IOTABTC
IOTAETH
LINKBTC
LINKETH
XVGBTC
XVGETH
SALTBTC
SALTETH
MDABTC
MDAETH
MTLBTC
MTLETH
SUBBTC
SUBETH
EOSBTC
SNTBTC
ETCETH
ETCBTC
MTHBTC
MTHETH
ENGBTC
ENGETH
DNTBTC
ZECBTC
ZECETH
BNTBTC
ASTBTC
ASTETH
DASHBTC
DASHETH
OAXBTC
ICNBTC
BTGBTC
BTGETH
EVXBTC
EVXETH
REQBTC
REQETH
VIBBTC
VIBETH
HSRETH
TRXBTC
TRXETH
POWRBTC
POWRETH
ARKBTC
ARKETH
YOYOETH
XRPBTC
XRPETH
MODBTC
MODETH
ENJBTC
ENJETH
STORJBTC
STORJETH
BNBUSDT
VENBNB
YOYOBNB
POWRBNB
VENBTC
VENETH
KMDBTC
KMDETH
NULSBNB
RCNBTC
RCNETH
RCNBNB
NULSBTC
NULSETH
RDNBTC
RDNETH
RDNBNB
XMRBTC
XMRETH
DLTBNB
WTCBNB
DLTBTC
DLTETH
AMBBTC
AMBETH
AMBBNB
BCCETH
BCCUSDT
BCCBNB
BATBTC
BATETH
BATBNB
BCPTBTC
BCPTETH
BCPTBNB
ARNBTC
ARNETH
GVTBTC
GVTETH
CDTBTC
CDTETH
GXSBTC
GXSETH
NEOUSDT
NEOBNB
POEBTC
POEETH
QSPBTC
QSPETH
QSPBNB
BTSBTC
BTSETH
BTSBNB
XZCBTC
XZCETH
XZCBNB
LSKBTC
LSKETH
LSKBNB
TNTBTC
TNTETH
FUELBTC
FUELETH
MANABTC
MANAETH
BCDBTC
BCDETH
DGDBTC
DGDETH
IOTABNB
ADXBTC
ADXETH
ADXBNB
ADABTC
ADAETH
PPTBTC
PPTETH
CMTBTC
CMTETH
CMTBNB
XLMBTC
XLMETH
XLMBNB
CNDBTC
CNDETH
CNDBNB
LENDBTC
LENDETH
WABIBTC
WABIETH
WABIBNB
LTCETH
LTCUSDT
LTCBNB
TNBBTC
TNBETH
WAVESBTC
WAVESETH
WAVESBNB
GTOBTC
GTOETH
GTOBNB
ICXBTC
ICXETH
ICXBNB
OSTBTC
OSTETH
OSTBNB
ELFBTC
ELFETH
AIONBTC
AIONETH
AIONBNB
NEBLBTC
NEBLBNB
BRDBTC
BRDETH
BRDBNB
MCOBNB
EDOBTC
EDOETH
WINGSBTC
WINGSETH
NAVBTC
NAVETH
NAVBNB
LUNBTC
LUNETH
TRIGBTC
TRIGETH
TRIGBNB
APPCBTC
APPCETH
APPCBNB
VIBEBTC
VIBEETH
RLCBTC
RLCETH
RLCBNB
INSBTC
INSETH
PIVXBTC
PIVXBNB
IOSTBTC
IOSTETH
CHATBTC
CHATETH
STEEMBTC
STEEMETH
STEEMBNB
NANOBTC
NANOETH
NANOBNB
VIABTC
VIAETH
VIABNB
BLZBTC
BLZETH
BLZBNB
AEBTC
AEETH
AEBNB
RPXBTC
RPXETH
RPXBNB
NCASHBTC
NCASHETH
NCASHBNB
POABTC
POAETH
POABNB
ZILBTC
ZILETH
ZILBNB
ONTBTC
ONTETH
ONTBNB
STORMBTC
STORMETH
STORMBNB
QTUMBNB
QTUMUSDT
XEMBTC
XEMETH
XEMBNB
WANBTC
WANETH
WANBNB
WPRBTC
WPRETH
QLCBTC
QLCETH
SYSBTC
SYSETH
SYSBNB
QLCBNB
GRSBTC
GRSETH
ADAUSDT
ADABNB
CLOAKBTC
CLOAKETH
GNTBTC
GNTETH
GNTBNB
LOOMBTC
LOOMETH
LOOMBNB
XRPUSDT
BCNBTC
BCNETH
BCNBNB
REPBTC
REPBNB
BTCTUSD
TUSDBTC
ETHTUSD
TUSDETH
TUSDBNB
ZENBTC
ZENETH
ZENBNB
SKYBTC
SKYETH
SKYBNB
EOSUSDT
EOSBNB
CVCBTC
CVCETH
CVCBNB
THETABTC
THETAETH
THETABNB
XRPBNB
TUSDUSDT
IOTAUSDT
XLMUSDT
IOTXBTC
IOTXETH
QKCBTC
QKCETH
AGIBTC
AGIETH
AGIBNB
NXSBTC
NXSETH
NXSBNB
ENJBNB
DATABTC
DATAETH
ONTUSDT
TRXBNB
TRXUSDT
ETCUSDT
ETCBNB
ICXUSDT
SCBTC
SCETH
NPXSBTC
NPXSETH
VENUSDT
KEYBTC
KEYETH
NASBTC
NASETH
NASBNB
MFTBTC
MFTETH
MFTBNB
DENTBTC
DENTETH
ARDRBTC
ARDRETH
ARDRBNB
NULSUSDT
HOTBTC
HOTETH
VETBTC
VETETH
VETUSDT
VETBNB
DOCKBTC
DOCKETH
POLYBTC
POLYBNB
PHXBTC
PHXETH
PHXBNB
HCBTC
HCETH
GOBTC
GOBNB
PAXBTC
PAXBNB
PAXUSDT
PAXETH
RVNBTC
DCRBTC
DCRBNB
USDCBNB
MITHBTC
MITHBNB
BCHABCBTC
BCHSVBTC
BCHABCUSDT
BCHSVUSDT
BNBPAX
BTCPAX
ETHPAX
XRPPAX
EOSPAX
XLMPAX
RENBTC
RENBNB
BNBTUSD
XRPTUSD
EOSTUSD
XLMTUSD
BNBUSDC
BTCUSDC
ETHUSDC
XRPUSDC
EOSUSDC
XLMUSDC
USDCUSDT
ADATUSD
TRXTUSD
NEOTUSD
TRXXRP
XZCXRP
PAXTUSD
USDCTUSD
USDCPAX
LINKUSDT
LINKTUSD
LINKPAX
LINKUSDC
WAVESUSDT
WAVESTUSD
WAVESPAX
WAVESUSDC
BCHABCTUSD
BCHABCPAX
BCHABCUSDC
BCHSVTUSD
BCHSVPAX
BCHSVUSDC
LTCTUSD
LTCPAX
LTCUSDC
TRXPAX
TRXUSDC
BTTBTC
BTTBNB
BTTUSDT
BNBUSDS
BTCUSDS
USDSUSDT
USDSPAX
USDSTUSD
USDSUSDC
BTTPAX
BTTTUSD
BTTUSDC
ONGBNB
ONGBTC
ONGUSDT
HOTBNB
HOTUSDT
ZILUSDT
ZRXBNB
ZRXUSDT
FETBNB
FETBTC
FETUSDT
BATUSDT
XMRBNB
XMRUSDT
ZECBNB
ZECUSDT
ZECPAX
ZECTUSD
ZECUSDC
IOSTUSDT
CELRBNB
CELRBTC
CELRUSDT
ADAPAX
ADAUSDC
NEOPAX
NEOUSDC
DASHBNB
DASHUSDT
NANOUSDT
OMGBNB
OMGUSDT
THETAUSDT
ENJUSDT
MITHUSDT
MATICBNB
MATICBTC
MATICUSDT
ATOMBNB
ATOMBTC
ATOMUSDT
ATOMUSDC
ATOMPAX
ATOMTUSD
ETCUSDC
ETCPAX
ETCTUSD
BATUSDC
BATPAX
BATTUSD
PHBBNB
PHBBTC
PHBUSDC
PHBTUSD
PHBPAX
TFUELBNB
TFUELBTC
TFUELUSDT
TFUELUSDC
TFUELTUSD
TFUELPAX
ONEBNB
ONEBTC
ONEUSDT
ONETUSD
ONEPAX
ONEUSDC
FTMBNB
FTMBTC
FTMUSDT
FTMTUSD
FTMPAX
FTMUSDC
BTCBBTC
BCPTTUSD
BCPTPAX
BCPTUSDC
ALGOBNB
ALGOBTC
ALGOUSDT
ALGOTUSD
ALGOPAX
ALGOUSDC
USDSBUSDT
USDSBUSDS
GTOUSDT
GTOPAX
GTOTUSD
GTOUSDC
ERDBNB
ERDBTC
ERDUSDT
ERDPAX
ERDUSDC
DOGEBNB
DOGEBTC
DOGEUSDT
DOGEPAX
DOGEUSDC
DUSKBNB
DUSKBTC
DUSKUSDT
DUSKUSDC
DUSKPAX
BGBPUSDC
ANKRBNB
ANKRBTC
ANKRUSDT
ANKRTUSD
ANKRPAX
ANKRUSDC
ONTPAX
ONTUSDC
WINBNB
WINBTC
WINUSDT
WINUSDC
COSBNB
COSBTC
COSUSDT
TUSDBTUSD
NPXSUSDT
NPXSUSDC
COCOSBNB
COCOSBTC
COCOSUSDT
MTLUSDT
TOMOBNB
TOMOBTC
TOMOUSDT
TOMOUSDC
PERLBNB
PERLBTC
PERLUSDC
PERLUSDT
DENTUSDT
MFTUSDT
KEYUSDT
STORMUSDT
DOCKUSDT
WANUSDT
FUNUSDT
CVCUSDT
BTTTRX
WINTRX
CHZBNB
CHZBTC
CHZUSDT
BANDBNB
BANDBTC
BANDUSDT
BNBBUSD
BTCBUSD
BUSDUSDT
BEAMBNB
BEAMBTC
BEAMUSDT
XTZBNB
XTZBTC
XTZUSDT
RENUSDT
RVNUSDT
HCUSDT
HBARBNB
HBARBTC
HBARUSDT
NKNBNB
NKNBTC
NKNUSDT
XRPBUSD
ETHBUSD
BCHABCBUSD
LTCBUSD
LINKBUSD
ETCBUSD
STXBNB
STXBTC
STXUSDT
KAVABNB
KAVABTC
KAVAUSDT
BUSDNGN
BNBNGN
BTCNGN
ARPABNB
ARPABTC
ARPAUSDT
TRXBUSD
EOSBUSD
IOTXUSDT
RLCUSDT
MCOUSDT
XLMBUSD
ADABUSD
CTXCBNB
CTXCBTC
CTXCUSDT
BCHBNB
BCHBTC
BCHUSDT
BCHUSDC
BCHTUSD
BCHPAX
BCHBUSD
BTCRUB
ETHRUB
XRPRUB
BNBRUB
TROYBNB
TROYBTC
TROYUSDT
BUSDRUB
QTUMBUSD
VETBUSD
VITEBNB
VITEBTC
VITEUSDT
FTTBNB
FTTBTC
FTTUSDT
BTCTRY
BNBTRY
BUSDTRY
ETHTRY
XRPTRY
USDTTRY
USDTRUB
BTCEUR
ETHEUR
BNBEUR
XRPEUR
EURBUSD
EURUSDT
OGNBNB
OGNBTC
OGNUSDT
DREPBNB
DREPBTC
DREPUSDT
BULLUSDT
BULLBUSD
BEARUSDT
BEARBUSD
ETHBULLUSDT
ETHBULLBUSD
ETHBEARUSDT
ETHBEARBUSD
TCTBNB
TCTBTC
TCTUSDT
WRXBNB
WRXBTC
WRXUSDT
ICXBUSD
BTSUSDT
BTSBUSD
LSKUSDT
BNTUSDT
BNTBUSD
LTOBNB
LTOBTC
LTOUSDT
ATOMBUSD
DASHBUSD
NEOBUSD
WAVESBUSD
XTZBUSD
EOSBULLUSDT
EOSBULLBUSD
EOSBEARUSDT
EOSBEARBUSD
XRPBULLUSDT
XRPBULLBUSD
XRPBEARUSDT
XRPBEARBUSD
BATBUSD
ENJBUSD
NANOBUSD
ONTBUSD
RVNBUSD
STRATBUSD
STRATBNB
STRATUSDT
AIONBUSD
AIONUSDT
MBLBNB
MBLBTC
MBLUSDT
COTIBNB
COTIBTC
COTIUSDT
ALGOBUSD
BTTBUSD
TOMOBUSD
XMRBUSD
ZECBUSD
BNBBULLUSDT
BNBBULLBUSD
BNBBEARUSDT
BNBBEARBUSD
STPTBNB
STPTBTC
STPTUSDT
BTCZAR
ETHZAR
BNBZAR
USDTZAR
BUSDZAR
BTCBKRW
ETHBKRW
BNBBKRW
WTCUSDT
DATABUSD
DATAUSDT
XZCUSDT
SOLBNB
SOLBTC
SOLUSDT
SOLBUSD
BTCIDRT
BNBIDRT
USDTIDRT
BUSDIDRT
CTSIBTC
CTSIUSDT
CTSIBNB
CTSIBUSD
HIVEBNB
HIVEBTC
HIVEUSDT
CHRBNB
CHRBTC
CHRUSDT
BTCUPUSDT
BTCDOWNUSDT
GXSUSDT
ARDRUSDT
ERDBUSD
LENDUSDT
HBARBUSD
MATICBUSD
WRXBUSD
ZILBUSD
MDTBNB
MDTBTC
MDTUSDT
STMXBTC
STMXETH
STMXUSDT
KNCBUSD
KNCUSDT
REPBUSD
REPUSDT
LRCBUSD
LRCUSDT
IQBNB
IQBUSD
PNTBTC
PNTUSDT
BTCGBP
ETHGBP
XRPGBP
BNBGBP
GBPBUSD
DGBBTC
DGBBUSD
BTCUAH
USDTUAH
COMPBTC
COMPBNB
COMPBUSD
COMPUSDT
BTCBIDR
ETHBIDR
BNBBIDR
BUSDBIDR
USDTBIDR
BKRWUSDT
BKRWBUSD
SCUSDT
ZENUSDT
SXPBTC
SXPBNB
SXPBUSD
SNXBTC
SNXBNB
SNXBUSD
SNXUSDT
ETHUPUSDT
ETHDOWNUSDT
ADAUPUSDT
ADADOWNUSDT
LINKUPUSDT
LINKDOWNUSDT
VTHOBNB
VTHOBUSD
VTHOUSDT
DCRBUSD
DGBUSDT
GBPUSDT
STORJBUSD
SXPUSDT
IRISBNB
IRISBTC
IRISBUSD
MKRBNB
MKRBTC
MKRUSDT
MKRBUSD
DAIBNB
DAIBTC
DAIUSDT
DAIBUSD
RUNEBNB
RUNEBTC
RUNEBUSD
MANABUSD
DOGEBUSD
LENDBUSD
ZRXBUSD
DCRUSDT
STORJUSDT
XRPBKRW
ADABKRW
BTCAUD
ETHAUD
AUDBUSD
FIOBNB
FIOBTC
FIOBUSD
BNBUPUSDT
BNBDOWNUSDT
XTZUPUSDT
XTZDOWNUSDT
AVABNB
AVABTC
AVABUSD
USDTBKRW
BUSDBKRW
IOTABUSD
MANAUSDT
XRPAUD
BNBAUD
AUDUSDT
BALBNB
BALBTC
BALBUSD
YFIBNB
YFIBTC
YFIBUSD
YFIUSDT
BLZBUSD
KMDBUSD
BALUSDT
BLZUSDT
IRISUSDT
KMDUSDT
BTCDAI
ETHDAI
BNBDAI
USDTDAI
BUSDDAI
JSTBNB
JSTBTC
JSTBUSD
JSTUSDT
SRMBNB
SRMBTC
SRMBUSD
SRMUSDT
ANTBNB
ANTBTC
ANTBUSD
ANTUSDT
CRVBNB
CRVBTC
CRVBUSD
CRVUSDT
SANDBNB
SANDBTC
SANDUSDT
SANDBUSD
OCEANBNB
OCEANBTC
OCEANBUSD
OCEANUSDT
NMRBTC
NMRBUSD
NMRUSDT
DOTBNB
DOTBTC
DOTBUSD
DOTUSDT
LUNABNB
LUNABTC
LUNABUSD
LUNAUSDT
IDEXBTC
IDEXBUSD
RSRBNB
RSRBTC
RSRBUSD
RSRUSDT
PAXGBNB
PAXGBTC
PAXGBUSD
PAXGUSDT
WNXMBNB
WNXMBTC
WNXMBUSD
WNXMUSDT
TRBBNB
TRBBTC
TRBBUSD
TRBUSDT
ETHNGN
DOTBIDR
LINKAUD
SXPAUD
BZRXBNB
BZRXBTC
BZRXBUSD
BZRXUSDT
WBTCBTC
WBTCETH
SUSHIBNB
SUSHIBTC
SUSHIBUSD
SUSHIUSDT
YFIIBNB
YFIIBTC
YFIIBUSD
YFIIUSDT
KSMBNB
KSMBTC
KSMBUSD
KSMUSDT
EGLDBNB
EGLDBTC
EGLDBUSD
EGLDUSDT
DIABNB
DIABTC
DIABUSD
DIAUSDT
RUNEUSDT
FIOUSDT
UMABTC
UMAUSDT
EOSUPUSDT
EOSDOWNUSDT
TRXUPUSDT
TRXDOWNUSDT
XRPUPUSDT
XRPDOWNUSDT
DOTUPUSDT
DOTDOWNUSDT
SRMBIDR
ONEBIDR
LINKTRY
USDTNGN
BELBNB
BELBTC
BELBUSD
BELUSDT
WINGBNB
WINGBTC
SWRVBNB
SWRVBUSD
WINGBUSD
WINGUSDT
LTCUPUSDT
LTCDOWNUSDT
LENDBKRW
SXPEUR
CREAMBNB
CREAMBUSD
UNIBNB
UNIBTC
UNIBUSD
UNIUSDT
NBSBTC
NBSUSDT
OXTBTC
OXTUSDT
SUNBTC
SUNUSDT
AVAXBNB
AVAXBTC
AVAXBUSD
AVAXUSDT
HNTBTC
HNTUSDT
BAKEBNB
BURGERBNB
SXPBIDR
LINKBKRW
FLMBNB
FLMBTC
FLMBUSD
FLMUSDT
SCRTBTC
SCRTETH
CAKEBNB
CAKEBUSD
SPARTABNB
UNIUPUSDT
UNIDOWNUSDT
ORNBTC
ORNUSDT
TRXNGN
SXPTRY
UTKBTC
UTKUSDT
XVSBNB
XVSBTC
XVSBUSD
XVSUSDT
ALPHABNB
ALPHABTC
ALPHABUSD
ALPHAUSDT
VIDTBTC
VIDTBUSD
AAVEBNB
BTCBRL
USDTBRL
AAVEBTC
AAVEETH
AAVEBUSD
AAVEUSDT
AAVEBKRW
NEARBNB
NEARBTC
NEARBUSD
NEARUSDT
SXPUPUSDT
SXPDOWNUSDT
DOTBKRW
SXPGBP
FILBNB
FILBTC
FILBUSD
FILUSDT
FILUPUSDT
FILDOWNUSDT
YFIUPUSDT
YFIDOWNUSDT
INJBNB
INJBTC
INJBUSD
INJUSDT
AERGOBTC
AERGOBUSD
LINKEUR
ONEBUSD
EASYETH
AUDIOBTC
AUDIOBUSD
AUDIOUSDT
CTKBNB
CTKBTC
CTKBUSD
CTKUSDT
BCHUPUSDT
BCHDOWNUSDT
BOTBTC
BOTBUSD
ETHBRL
DOTEUR
AKROBTC
AKROUSDT
KP3RBNB
KP3RBUSD
AXSBNB
AXSBTC
AXSBUSD
AXSUSDT
HARDBNB
HARDBTC
HARDBUSD
HARDUSDT
BNBBRL
LTCEUR
RENBTCBTC
RENBTCETH
DNTBUSD
DNTUSDT
SLPETH
ADAEUR
LTCNGN
CVPETH
CVPBUSD
STRAXBTC
STRAXETH
STRAXBUSD
STRAXUSDT
FORBTC
FORBUSD
UNFIBNB
UNFIBTC
UNFIBUSD
UNFIUSDT
FRONTETH
FRONTBUSD
BCHABUSD
ROSEBTC
ROSEBUSD
ROSEUSDT
AVAXTRY
BUSDBRL
AVAUSDT
SYSBUSD
XEMUSDT
HEGICETH
HEGICBUSD
AAVEUPUSDT
AAVEDOWNUSDT
PROMBNB
PROMBUSD
XRPBRL
XRPNGN
SKLBTC
SKLBUSD
SKLUSDT
BCHEUR
YFIEUR
ZILBIDR
SUSDBTC
SUSDETH
SUSDUSDT
COVERETH
COVERBUSD
GLMBTC
GLMETH
GHSTETH
GHSTBUSD
SUSHIUPUSDT
SUSHIDOWNUSDT
XLMUPUSDT
XLMDOWNUSDT
LINKBRL
LINKNGN
LTCRUB
TRXTRY
XLMEUR
DFETH
DFBUSD
GRTBTC
GRTETH
GRTUSDT
JUVBTC
JUVBUSD
JUVUSDT
PSGBTC
PSGBUSD
PSGUSDT
BUSDBVND
USDTBVND
1INCHBTC
1INCHUSDT
REEFBTC
REEFUSDT
OGBTC
OGUSDT
ATMBTC
ATMUSDT
ASRBTC
ASRUSDT
CELOBTC
CELOUSDT
RIFBTC
RIFUSDT
CHZTRY
XLMTRY
LINKGBP
GRTEUR
BTCSTBTC
BTCSTBUSD
BTCSTUSDT
TRUBTC
TRUBUSD
TRUUSDT
DEXEETH
DEXEBUSD
EOSEUR
LTCBRL
USDCBUSD
TUSDBUSD
PAXBUSD
CKBBTC
CKBBUSD
CKBUSDT
TWTBTC
TWTBUSD
TWTUSDT
FIROBTC
FIROETH
FIROUSDT
BETHETH
DOGEEUR
DOGETRY
DOGEAUD
DOGEBRL
DOTNGN
PROSETH
LITBTC
LITBUSD
LITUSDT
BTCVAI
BUSDVAI
SFPBTC
SFPBUSD
SFPUSDT
DOGEGBP
DOTTRY
FXSBTC
FXSBUSD
DODOBTC
DODOBUSD
DODOUSDT
FRONTBTC
EASYBTC
CAKEBTC
CAKEUSDT
BAKEBUSD
UFTETH
UFTBUSD
1INCHBUSD
BANDBUSD
GRTBUSD
IOSTBUSD
OMGBUSD
REEFBUSD
ACMBTC
ACMBUSD
ACMUSDT
AUCTIONBTC
AUCTIONBUSD
PHABTC
PHABUSD
DOTGBP
ADATRY
ADABRL
ADAGBP
TVKBTC
TVKBUSD
BADGERBTC
BADGERBUSD
BADGERUSDT
FISBTC
FISBUSD
FISUSDT
DOTBRL
ADAAUD
HOTTRY
EGLDEUR
OMBTC
OMBUSD
OMUSDT
PONDBTC
PONDBUSD
PONDUSDT
DEGOBTC
DEGOBUSD
DEGOUSDT
AVAXEUR
BTTTRY
CHZBRL
UNIEUR
ALICEBTC
ALICEBUSD
ALICEUSDT
CHZBUSD
CHZEUR
CHZGBP
BIFIBNB
BIFIBUSD
LINABTC
LINABUSD
LINAUSDT
ADARUB
ENJBRL
ENJEUR
MATICEUR
NEOTRY
PERPBTC
PERPBUSD
PERPUSDT
RAMPBTC
RAMPBUSD
RAMPUSDT
SUPERBTC
SUPERBUSD
SUPERUSDT
CFXBTC
CFXBUSD
CFXUSDT
ENJGBP
EOSTRY
LTCGBP
LUNAEUR
RVNTRY
THETAEUR
XVGBUSD
EPSBTC
EPSBUSD
EPSUSDT
AUTOBTC
AUTOBUSD
AUTOUSDT
TKOBTC
TKOBIDR
TKOBUSD
TKOUSDT
PUNDIXETH
PUNDIXUSDT
BTTBRL
BTTEUR
HOTEUR
WINEUR
TLMBTC
TLMBUSD
TLMUSDT
1INCHUPUSDT
1INCHDOWNUSDT
BTGBUSD
BTGUSDT
HOTBUSD
BNBUAH
ONTTRY
VETEUR
VETGBP
WINBRL
MIRBTC
MIRBUSD
MIRUSDT
BARBTC
BARBUSD
BARUSDT
FORTHBTC
FORTHBUSD
FORTHUSDT
CAKEGBP
DOGERUB
HOTBRL
WRXEUR
EZBTC
EZETH
BAKEUSDT
BURGERBUSD
BURGERUSDT
SLPBUSD
SLPUSDT
TRXAUD
TRXEUR
VETTRY
SHIBUSDT
SHIBBUSD
ICPBTC
ICPBNB
ICPBUSD
ICPUSDT
BTCGYEN
USDTGYEN
SHIBEUR
SHIBRUB
ETCEUR
ETCBRL
DOGEBIDR
ARBTC
ARBNB
ARBUSD
ARUSDT
POLSBTC
POLSBNB
POLSBUSD
POLSUSDT
MDXBTC
MDXBNB
MDXBUSD
MDXUSDT
MASKBNB
MASKBUSD
MASKUSDT
LPTBTC
LPTBNB
LPTBUSD
LPTUSDT
ETHUAH
MATICBRL
SOLEUR
SHIBBRL
AGIXBTC
ICPEUR
MATICGBP
SHIBTRY
MATICBIDR
MATICRUB
NUBTC
NUBNB
NUBUSD
NUUSDT
XVGUSDT
RLCBUSD
CELRBUSD
ATMBUSD
ZENBUSD
FTMBUSD
THETABUSD
WINBUSD
KAVABUSD
XEMBUSD
ATABTC
ATABNB
ATABUSD
ATAUSDT
GTCBTC
GTCBNB
GTCBUSD
GTCUSDT
TORNBTC
TORNBNB
TORNBUSD
TORNUSDT
MATICTRY
ETCGBP
SOLGBP
BAKEBTC
COTIBUSD
KEEPBTC
KEEPBNB
KEEPBUSD
KEEPUSDT
SOLTRY
RUNEGBP
SOLBRL
SCBUSD
CHRBUSD
STMXBUSD
HNTBUSD
FTTBUSD
DOCKBUSD
ADABIDR
ERNBNB
ERNBUSD
ERNUSDT
KLAYBTC
KLAYBNB
KLAYBUSD
KLAYUSDT
RUNEEUR
MATICAUD
DOTRUB
UTKBUSD
IOTXBUSD
PHAUSDT
SOLRUB
RUNEAUD
BUSDUAH
BONDBTC
BONDBNB
BONDBUSD
BONDUSDT
MLNBTC
MLNBNB
MLNBUSD
MLNUSDT
GRTTRY
CAKEBRL
ICPRUB
DOTAUD
AAVEBRL
EOSAUD
DEXEUSDT
LTOBUSD
ADXBUSD
QUICKBTC
QUICKBNB
QUICKBUSD
C98USDT
C98BUSD
C98BNB
C98BTC
CLVBTC
CLVBNB
CLVBUSD
CLVUSDT
QNTBTC
QNTBNB
QNTBUSD
QNTUSDT
FLOWBTC
FLOWBNB
FLOWBUSD
FLOWUSDT
XECBUSD
AXSBRL
AXSAUD
TVKUSDT
MINABTC
MINABNB
MINABUSD
MINAUSDT
RAYBNB
RAYBUSD
RAYUSDT
FARMBTC
FARMBNB
FARMBUSD
FARMUSDT
ALPACABTC
ALPACABNB
ALPACABUSD
ALPACAUSDT
TLMTRY
QUICKUSDT
ORNBUSD
MBOXBTC
MBOXBNB
MBOXBUSD
MBOXUSDT
VGXBTC
VGXETH
FORUSDT
REQUSDT
GHSTUSDT
TRURUB
FISBRL
WAXPUSDT
WAXPBUSD
WAXPBNB
WAXPBTC
TRIBEBTC
TRIBEBNB
TRIBEBUSD
TRIBEUSDT
GNOUSDT
GNOBUSD
GNOBNB
GNOBTC
ARPATRY
PROMBTC
MTLBUSD
OGNBUSD
XECUSDT
C98BRL
SOLAUD
XRPBIDR
POLYBUSD
ELFUSDT
DYDXUSDT
DYDXBUSD
DYDXBNB
DYDXBTC
ELFBUSD
POLYUSDT
IDEXUSDT
VIDTUSDT
SOLBIDR
AXSBIDR
BTCUSDP
ETHUSDP
BNBUSDP
USDPBUSD
USDPUSDT
GALAUSDT
GALABUSD
GALABNB
GALABTC
FTMBIDR
ALGOBIDR
CAKEAUD
KSMAUD
WAVESRUB
SUNBUSD
ILVUSDT
ILVBUSD
ILVBNB
ILVBTC
RENBUSD
YGGUSDT
YGGBUSD
YGGBNB
YGGBTC
STXBUSD
SYSUSDT
DFUSDT
SOLUSDC
ARPARUB
LTCUAH
FETBUSD
ARPABUSD
LSKBUSD
AVAXBIDR
ALICEBIDR
FIDAUSDT
FIDABUSD
FIDABNB
FIDABTC
DENTBUSD
FRONTUSDT
CVPUSDT
AGLDBTC
AGLDBNB
AGLDBUSD
AGLDUSDT
RADBTC
RADBNB
RADBUSD
RADUSDT
UNIAUD
HIVEBUSD
STPTBUSD
BETABTC
BETABNB
BETABUSD
BETAUSDT
SHIBAUD
RAREBTC
RAREBNB
RAREBUSD
RAREUSDT
AVAXBRL
AVAXAUD
LUNAAUD
TROYBUSD
AXSETH
FTMETH
SOLETH
SSVBTC
SSVETH
LAZIOTRY
LAZIOEUR
LAZIOBTC
LAZIOUSDT
CHESSBTC
CHESSBNB
CHESSBUSD
CHESSUSDT
FTMAUD
FTMBRL
SCRTBUSD
ADXUSDT
AUCTIONUSDT
CELOBUSD
FTMRUB
NUAUD
NURUB
REEFTRY
REEFBIDR
SHIBDOGE
DARUSDT
DARBUSD
DARBNB
DARBTC
BNXBTC
BNXBNB
BNXBUSD
BNXUSDT
RGTUSDT
RGTBTC
RGTBUSD
RGTBNB
LAZIOBUSD
OXTBUSD
MANATRY
ALGORUB
SHIBUAH
LUNABIDR
AUDUSDC
MOVRBTC
MOVRBNB
MOVRBUSD
MOVRUSDT
CITYBTC
CITYBNB
CITYBUSD
CITYUSDT
ENSBTC
ENSBNB
ENSBUSD
ENSUSDT
SANDETH
DOTETH
MATICETH
ANKRBUSD
SANDTRY
MANABRL
KP3RUSDT
QIUSDT
QIBUSD
QIBNB
QIBTC
PORTOBTC
PORTOUSDT
PORTOTRY
PORTOEUR
POWRUSDT
POWRBUSD
AVAXETH
SLPTRY
FISTRY
LRCTRY
CHRETH
FISBIDR
VGXUSDT
GALAETH
JASMYUSDT
JASMYBUSD
JASMYBNB
JASMYBTC
AMPBTC
AMPBNB
AMPBUSD
AMPUSDT
PLABTC
PLABNB
PLABUSD
PLAUSDT
PYRBTC
PYRBUSD
PYRUSDT
RNDRBTC
RNDRUSDT
RNDRBUSD
ALCXBTC
ALCXBUSD
ALCXUSDT
SANTOSBTC
SANTOSUSDT
SANTOSBRL
SANTOSTRY
MCBTC
MCBUSD
MCUSDT
BELTRY
COCOSBUSD
DENTTRY
ENJTRY
NEORUB
SANDAUD
SLPBIDR
ANYBTC
ANYBUSD
ANYUSDT
BICOBTC
BICOBUSD
BICOUSDT
FLUXBTC
FLUXBUSD
FLUXUSDT
ALICETRY
FXSUSDT
GALABRL
GALATRY
LUNATRY
REQBUSD
SANDBRL
MANABIDR
SANDBIDR
VOXELBTC
VOXELBNB
VOXELBUSD
VOXELUSDT
COSBUSD
CTXCBUSD
FTMTRY
MANABNB
MINATRY
XTZTRY
HIGHBTC
HIGHBUSD
HIGHUSDT
CVXBTC
CVXBUSD
CVXUSDT
PEOPLEBTC
PEOPLEBUSD
PEOPLEUSDT
OOKIBUSD
OOKIUSDT
COCOSTRY
GXSBNB
LINKBNB
LUNAETH
MDTBUSD
NULSBUSD
SPELLBTC
SPELLUSDT
SPELLBUSD
USTBTC
USTBUSD
USTUSDT
JOEBTC
JOEBUSD
JOEUSDT
ATOMETH
DUSKBUSD
EGLDETH
ICPETH
LUNABRL
LUNAUST
NEARETH
ROSEBNB
VOXELETH
ALICEBNB
ATOMTRY
ETHUST
GALAAUD
LRCBNB
ONEETH
OOKIBNB
ACHBTC
ACHBUSD
ACHUSDT
IMXBTC
IMXBUSD
IMXUSDT
GLMRBTC
GLMRBUSD
GLMRUSDT
ATOMBIDR
DYDXETH
FARMETH
FORBNB
ICPTRY
JASMYETH
LINABNB
OOKIETH
ROSEETH
UMABUSD
UNIETH
XTZETH
LOKABTC
LOKABNB
LOKABUSD
LOKAUSDT
ATOMBRL
BNBUST
CRVETH
HIGHBNB
NEARRUB
ROSETRY
SCRTUSDT
API3BTC
API3BUSD
API3USDT
BTTCUSDT
BTTCUSDC
BTTCTRY
ACABTC
ACABUSD
ACAUSDT
ANCBTC
ANCBUSD
ANCUSDT
BDOTDOT
XNOBTC
XNOETH
XNOBUSD
XNOUSDT
COSTRY
KAVAETH
MCBNB
ONETRY
WOOBTC
WOOBNB
WOOBUSD
WOOUSDT
CELRETH
PEOPLEBNB
SLPBNB
SPELLBNB
SPELLTRY
TFUELBUSD
AXSTRY
DARTRY
NEARTRY
IDEXBNB
ALPINEEUR
ALPINETRY
ALPINEUSDT
ALPINEBTC
TUSDT
TBUSD
API3BNB
BETAETH
INJTRY
TLMBNB
ASTRBUSD
ASTRUSDT
API3TRY
GLMRBNB
MBOXTRY
NBTBIDR
NBTUSDT
GMTBTC
GMTBNB
GMTBUSD
GMTUSDT
ANCBNB
ATOMEUR
GALAEUR
KSMETH
UMATRY
KDABTC
KDABUSD
KDAUSDT
APEUSDT
APEBUSD
APEBTC

 

 

and what return me  is only this

 

 

Posted
20 minutes ago, fulvius said:

Hi , i have a script for create a link of binance  data collaction , my script works so it takes all the tickers from a txt sheet puts them in an array and then cycles them to build the zip address to download, but it stops after a few tickers and I can't understand why anyone can help me ?? thank you all

 

 

 becuz of this: If $CDateInv >= "2021-03-01" Then,if you disable it it give all of inside txt file.

none

Posted

yes  but    in this mode  count  over 2021-03-01 and  in this mode not exist a  file and at near at end give me array error , i dont belive is correct way

Posted

yes  but    in this mode  count  over 2021-03-01 and  in this mode not exist a  file and at near at end give me array error , i dont belive is correct way

Posted

sorry for reply post i think , my connection have problem sometime

i find  a problem but  i dont understund  why the  variable $j  increases before the ticker sub cycle is over

during  this  cicle  $aAllSymbol = have 1790 items and must cicle this till the end  but after 100 this varible $J increase but is not possible because is always  in subcycle of  symbol

why_?   is  bug ??

For $h = 0 To UBound($aAllSynbol) - 1   ; simboli

 

Posted

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...