# Data Management How to manage data in the cycles app for analysis # Integrated Datafeeds The cycle toolbox has integrated external data-sources for end-of-day datasets. It includes major global stocks, market indices, crypto-currencies and forex data. ### **Stock market data** The market type ID to get major global stocks and indices datasets is **YFI**. Use Yahoo Finance for symbol search. For weekly data add -W to the symbol. Example symbols are:
**Symbol****Name****Cycle Tools Symbol ID****Link**
^GSPCS&P 500 Index^GSPC:YFI[Open](https://cycle.tools/cyclescanner/%5EGSPC:YFI)
^GSPC-WS&P 500 Index Weekly^GSPC-W:YFI[Open](https://cycle.tools/cyclescanner/%5EGSPC-W:YFI)
CL=FOilCL=F:YFI[Open](https://cycle.tools/cyclescanner/CL=F:YFI)
ES=FE Mini FuturesES=F:YFI[Open](https://cycle.tools/cyclescanner/ES=F:YFI)
DX-Y.NYB-WUS Dollar Index WeeklyDX-Y.NYB-W:YFI[Open](https://cycle.tools/cyclescanner/DX-Y.NYB-W:YFI)
GBPUSD=XGBP/USD Currency in USDGBPUSD=X:YFI[Open](https://cycle.tools/cyclescanner/GBPUSD=x:YFI)
---
### **Crypto-currency datasets** The market type ID to get crypto datasets is **CDS**. Generic symbol format is: \[FromSymbol\]-\[ToSymbol\]-\[Exchange\] Short usage is: \[Symbol\] – in this case ToSymbol is USD and the exchange is CCCAGG index \*. Example symbols are:
**Symbol****Name****Cycle Tools Symbol ID****Link**
ETHEthereum USDETH:CDS[Open](https://cycle.tools/cyclescanner/ETH:CDS)
BTCBitcoin USDBTC:CDS[Open](https://cycle.tools/cyclescanner/BTC:CDS)
LTCLitecoin USDLTC:CDS[Open](https://cycle.tools/cyclescanner/LTC:CDS)
BTC-EUR-CCCAGGBitcoin EURBTC-EUR-CCCAGG:CDS[Open](https://cycle.tools/cyclescanner/BTC-EUR-CCCAGG:CDS)
ETH-JPY-COINBASEEtheruem JPY at CoinbaseETH-JPY-COINBASE:CDS[Open](https://cycle.tools/cyclescanner/ETH-JPY-COINBASE:CDS)
---
### **Managed Forex datasets** The market type ID to get managed forex currency pairs is **FX**. Generic symbol format is: \[FromSymbol\]\[ToSymbol\]
**Symbol****Name****Cycle Tools Symbol ID****Link**
EURUSDEUR USDEURUSD:FX[Open](https://cycle.tools/cyclescanner/EURUSD:FX)
USDJPYUSD JPYUSDJPY:FX[Open](https://cycle.tools/cyclescanner/USDJPY:FX)
EURGBPEUR GBPEURGBP:FX[Open](https://cycle.tools/cyclescanner/EURGBP:FX)
---
### **Economic datasets** (FRED) Access to the economic data services of the Economic Research Division of the Federal Reserve Bank of St. Louis. The market type ID to get FRED data is **FDS**. Online symbol search via FRED: [https://fred.stlouisfed.org/](https://fred.stlouisfed.org/) Example symbols are:
**Symbol****Name****Cycle Tools Symbol ID****Link**
VIXCLSCBOE Volatility IndexVIXCLS:FDS[Open](https://cycle.tools/cyclescanner/VIXCLS:FDS)
VXDCLSDJIA Volatility IndexVXDCLS:FDS[Open](https://cycle.tools/cyclescanner/VXDCLS:FDS)
T5YIFR5-Year Forward Inflation Expectation RateT5YIFR:FDS[Open](https://cycle.tools/cyclescanner/T5YIFR:FDS)
STLFSI2-WSt. Louis Fed Financial Stress Index (Weekly) [More dataset details](https://fredblog.stlouisfed.org/2020/03/the-st-louis-feds-financial-stress-index-version-2-0/)STLFSI2-W:FDS[Open](https://cycle.tools/cyclescanner/STLFSI2-W:FDS)
---
### **Quandl datasets** The market type ID to get free quandl datasets is **QDS**. Generic symbol format to load free quandl data via the time series API: \[Quandl database code\]-\[Quandl dataset code\]-\[column\]-\[collapse\] \[column\] (optional) Ensure that you pick that correct column number. The column number is different for each dataset. \[collapse\] (optional):
none daily weekly monthly quarterly annualChange the sampling frequency of the returned data. Default is `none`; i.e., data is returned in its original granularity.
Example symbols are:
**Database-Symbol****Name****Cycle Tools Symbol ID****Link**
CHRIS-EUREX\_FDAX1-4DAX Futures, Continuous Contract #1 (FDAX1) (Front Month), EUREX, SettleCHRIS-EUREX\_FDAX1-4:QDS[Open](https://cycle.tools/cyclescanner/CHRIS-EUREX_FDAX1-4:QDS)
FSE-VOW3\_XVolkswagen AG, Stock Price, Frankfurt Stock ExchangeFSE-VOW3\_X:QDS[Open](https://cycle.tools/cyclescanner/FSE-VOW3_X:QDS)
BSE-SensexBombay Stock Exchange – SENSEX IndexBSE-Sensex:QDS[Open](https://cycle.tools/cyclescanner/BSE-SENSEX:QDS)
LBMA-Gold-2Gold London Fixing USD PM (London Bullion Market Association) [More dataset details](https://www.quandl.com/data/LBMA/GOLD-Gold-Price-London-Fixing)LBMA-Gold-2:QDS[Open](https://cycle.tools/cyclescanner/LBMA-Gold-2:QDS)
LBMA-Gold-2-weeklyGold London Fixing USD PM weekly dataLBMA-Gold-2-weekly:QDS[Open](https://cycle.tools/cyclescanner/LBMA-Gold-2-weekly:QDS)
LBMA-Gold-4Gold London Fixing GBP PM (London Bullion Market Association) [More dataset details](https://www.quandl.com/data/LBMA/GOLD-Gold-Price-London-Fixing)LBMA-Gold-4:QDS[Open](https://cycle.tools/cyclescanner/LBMA-Gold-4:QDS)
LBMA-Silver-3Silver London Fixing EUR (London Bullion Market Association) [More dataset details](https://www.quandl.com/data/LBMA/SILVER-Silver-Price-London-Fixing)LBMA-Silver-3:QDS[Open](https://cycle.tools/cyclescanner/LBMA-Silver-3:QDS)
ECB-EURJPY-1EUR vs JPY Exchange Rate (European Central Bank) [More dataset details](https://www.quandl.com/data/ECB/EURJPY-EUR-vs-JPY-Foreign-Exchange-Reference-Rate)ECB-EURJPY:QDS[Open](https://cycle.tools/cyclescanner/ECB-EURJPY:QDS)
CHRIS-ICE\_CC5-4Cocoa Futures, Continuous Contract (Settle) [More dataset details](https://www.quandl.com/data/CHRIS/ICE_CC1-Cocoa-Futures-Continuous-Contract)CHRIS-ICE\_CC5-4:QDS[Open](https://cycle.tools/cyclescanner/CHRIS-ICE_CC5-4:QDS)
CHRIS-ICE\_B1-4Brent Crude Futures, Continuous Contract (Settle) [More dataset details ](https://www.quandl.com/data/CHRIS/ICE_B1-Brent-Crude-Futures-Continuous-Contract)CHRIS-ICE\_B1-4:QDS[Open](https://cycle.tools/cyclescanner/CHRIS-ICE_B1-4:QDS)
CHRIS-ICE\_B1-4-weeklyBrent Crude Futures, Continuous Contract (Settle) - weeklyCHRIS-ICE\_B1-4-weekly:QDS[Open](https://cycle.tools/cyclescanner/CHRIS-ICE_B1-4-weekly:QDS)
\*) Data is sourced from CryptoCompare. If no exchange is specified the CCCAGG index data will be returned. The Crypto Coin Comparison Aggregated Index (“CCCAGG”) refers to the real-time index calculation methodology, the purpose of which is to show the best price estimation for crypto traders and investors to value their portfolio at any time. It aggregates transaction data of over 70 exchanges,using 24 hour volume weighted average. The CCCAGG is calculated for each crypto coin in eachcurrency it is trading in. We provide the data from CryptoCompare to the community based on their license without any additional change or charge (for research, software/applicationdevelopment, portfolio valuation, etc.), and is under the Creative Commons Attribution-NonCommercial3.0 Unported (CC BY-NC 3.0) license ( https://creativecommons.org/licenses/by-nc/3.0/ ). # Upload your own data You can upload your own datasets as CSV files and save them in the cycles app. A CSV ("comma-separated values") file is a delimited text file that uses a comma to separate values.

You can always manage (add, remove, update) your own saved data-sets in the settings area: [https://cycle.tools/settings/datasets](https://cycle.tools/settings/datasets)

To upload new data series, go to the Settings -> MyDatasets area and click "Upload New". You need to ensure the right format of your text file. The first line always needs to include the header "time, value" indicating each following line has a text for the date/time and a numeric value (e.g. close). --- ##### ##### EOD ```C time, value 2019-04-11, 80.01 2019-04-12, 82.1 ```

Use the [attached file eod\_upload\_test.csv](https://docs.cycle.tools/attachments/8) shown in the navigation panel as template with daily data.

--- ##### ##### Intraday ```C time, value 2019-04-11 13:01, 2301 2019-04-12 13:02, 2320 ```

Please see and test the [attached file](https://docs.cycle.tools/attachments/7) (eurusd-1h-example.csv) shown in the navigation panel as template with 1h intraday data for the EURUSD.

--- ##### ##### Generic date formats
\[yy\]yy-mm-dd yyyymmdd