MinoMacro
New Member
- Joined
- May 3, 2019
- Messages
- 3
I have a Excel sheet: (1 tab - Test_OHLC, 3 modules VBA)
CryptoCurrency_7_14_days_kraken.xlsm
at the moment I can obtain info into according AssetPair=C6=ListOf_All_Crypto(I can select just 1) and Interval=C8 and TimeFrom=C10(Calculated in M2:M4) cells: B16:J800 which contains:
for me is important to use parameter C8=10080 minutes and for each CryptoPair I would like to obtain 2 rows with parameter C10=TimeFrom(Now-14)=calculated cell in M4)
Can you help me please?
CryptoCurrency_7_14_days_kraken.xlsm
at the moment I can obtain info into according AssetPair=C6=ListOf_All_Crypto(I can select just 1) and Interval=C8 and TimeFrom=C10(Calculated in M2:M4) cells: B16:J800 which contains:
| assetpair | time | open | high | low | close | vwap | volume | count |
for me is important to use parameter C8=10080 minutes and for each CryptoPair I would like to obtain 2 rows with parameter C10=TimeFrom(Now-14)=calculated cell in M4)
| assetpair | time | open | high | low | close | vwap | volume | count |
| 1INCHEUR | 1632355200 | 2,242 | 3,413 | 1,9 | 2,151 | 2,302 | 284549,573 | 1410 |
| 1INCHEUR | 1632960000 | 2,145 | 2,819 | 2,145 | 2,781 | 2,486 | 274861,451 | 1120 |
| AAVEEUR | 1632355200 | 258,56 | 265 | 216,22 | 228,35 | 238,2 | 15688,1495 | 6023 |
| AAVEEUR | 1632960000 | 228,47 | 278,31 | 227,57 | 262,76 | 257,89 | 7139,28696 | 3555 |
| ADAEUR | 1632355200 | 1,933152 | 2,099 | 1,733001 | 1,779817 | 1,888022 | 55950292,8 | 67167 |
| ADAEUR | 1632960000 | 1,778962 | 1,999294 | 1,769856 | 1,912947 | 1,898818 | 27237814,8 | 36205 |
Can you help me please?
