crypto_candles is giving data of wrong length and dates

[AndrewBworth]

Hello, I just started working with finnhub moving from yfinance. It's returning the wrong data, the data I ask for is today and up to 200 days back, but instead I get odd numbers like 128 days back or 228 days back, and the start and end times are completely wrong. Here's my "hello world", it has a unfinished function in the middle (functionmovingaverage), but it's just a rough unfinished program. I have a long list of crpytocurrencies reading out of a text file (CryptoList.txt)

!/usr/bin/python

import finnhub import pandas as pd import datetime import time

starttime = datetime.datetime.now() - datetime.timedelta(days = 200) currenttime = datetime.datetime.now() - datetime.timedelta() starttimestamp = int(starttime.timestamp()) currenttimestamp = int(currenttime.timestamp())

print(starttimestamp) print(currenttimestamp) cryptolist = open("CryptoList.txt")

fc = finnhub.Client(api_key="cjsjv99r01qm5ielfq1gcjsjv99r01qm5ielfq20")

def functionmovingaverage(pandasdata): count = 199 sum200 = 0 sum50 = 0 sum20 = 0 sum10 = 0 sum5 = 0 lastval = 0 datalength = len(pandasdata) print(datalength) if datalength > 200: print(datalength) if datalength < 200: return -333 for k in pandasdata.itertuples(): print(k)

for i in cryptolist.readlines(): fixedi = i.split('\n')[0] name = fixedi print(name) res = fc.crypto_candles(name, 'D', starttimestamp, currenttimestamp) dataframe = pd.DataFrame(res) functionmovingaverage(dataframe) time.sleep(1)

[canstralian]

import finnhub # Import the Finnhub API client import pandas as pd import datetime import time

def get_valid_crypto_symbols(file_path): """Reads cryptocurrency symbols from a file and returns a list of valid symbols.""" valid_symbols = [] with open(file_path, 'r') as file: for line in file: symbol = line.strip() # Remove leading/trailing whitespaces if symbol: valid_symbols.append(symbol) return valid_symbols

def fetch_crypto_data(client, symbol, start_timestamp, end_timestamp): """ Fetches cryptocurrency data for the given symbol within the specified time range. Returns a pandas DataFrame containing the fetched data. """ try:

Call Finnhub API to get cryptocurrency candles data

    res = client.crypto_candles(symbol, 'D', start_timestamp, end_timestamp)
    if 's' in res:
        return pd.DataFrame(res['s'])  # Convert the response to a DataFrame
    else:
        print(f"No data found for symbol {symbol}")
        return None
except Exception as e:
    print(f"Error fetching data for symbol {symbol}: {e}")
    return None

def main():

Define time range

start_time = datetime.datetime.now() - datetime.timedelta(days=200)
end_time = datetime.datetime.now()
start_timestamp = int(start_time.timestamp())
end_timestamp = int(end_time.timestamp())

# Initialize Finnhub client
api_key = "YOUR_API_KEY"  # Replace "YOUR_API_KEY" with your actual API key
client = finnhub.Client(api_key=api_key)

# Get valid cryptocurrency symbols from the file
crypto_symbols = get_valid_crypto_symbols("CryptoList.txt")

# Fetch data for each cryptocurrency symbol
for symbol in crypto_symbols:
    # Fetch data for the symbol
    crypto_data = fetch_crypto_data(client, symbol, start_timestamp, end_timestamp)
    if crypto_data is not None:
        # Process the fetched data or call other functions here
        print(f"Fetched data for {symbol}:")
        print(crypto_data.head())  # Just printing the first few rows for demonstration
        print()

    time.sleep(1)  # Add a delay to avoid hitting API rate limits

if name == "main": main()