Biggest Swings
Calculate daily % change
Sort
Daily Change - Descending
First
10
First 10
Last
10
Last 10
Warning
All
ByName
#1
#2
Combine data
Combine data
C:\Users\LCORNE~1\AppData\Local\Temp\Engine_43784_698f7301e07e424a98b72999aa40c67b_\Engine_36384_6301ee0c501e4e00a2896e76b38a0226_.yxdb
Single
Profile
Download Data
URL
String
65001
GET
Compose
2
600
Download data for yahoo
Download data for yahoo
ADA
BTC
ETH
BNB
DOT1
LINK
LTC
THETA
XRP
USDT
Define download URL
URL = 'https://query1.finance.yahoo.com/v7/finance/download/'+[Ticker]+'-USD?per...
DownloadData
Split downloaded data into rows
Split downloaded data into rows
DownloadData
Last
DownloadData
Split to columns based on comma separators
Split to columns based on comma separators
FirstRow
Warn
Rename columns based on first row of data
Rename columns based on first row of data
Remove unnecessary fields
Remove unnecessary fields
Simple
!=
Date
True
fixed
2021-04-08 09:25:00
0
Date
2021-04-08 09:25:00
2021-04-08 09:25:00
Remove extra header rows in data
[Date] != "Date"
False
False
"Crypto","Date","Open","High","Low","Close","Adj Close","Volume"
True
True
True
False
False
False
False
False
False
upper
Horizontal
New Workflow2