Newbie - struggling to export community sentiment data

Oct 24 at 09:56
130 Visualizações
1 Replies
JPR
Membro Desde Dec 18, 2010   1 postagens
Oct 24 at 09:56
Hi all,
Please can you help me to confirm the correct API Key / token to use to pull sentiment data.

When I have the correct key, will this basic script do the job?
..................................
import requests
import csv
import datetime
import time

# Your Myfxbook API credentials
API_KEY = '?' # Replace with actual API key

def get_sentiment_data():
    endpoint = 'https://www.myfxbook.com/api/get-community-outlook.json'
    params = {'session': API_KEY}
    response = requests.get(endpoint, params=params)

    if response.status_code == 200:
        data = response.json()
        if data['error'] == 0:
            return data['outlook']
        else:
            print(f'Error: {data['message']}')
            return None
    else:
        print(f'Failed to retrieve data. Status code: {response.status_code}')
        return None

def save_to_csv(data):
    filename = 'sentiment_data.csv'
    with open(filename, mode='a', newline='') as file:
        writer = csv.writer(file)
        # Write the header if the file is new
        if file.tell() == 0:
            writer.writerow(['Date', 'Symbol', 'Short Percentage', 'Long Percentage', 'Short Volume', 'Long Volume'])

        for symbol in data['symbols']:
            writer.writerow([
                datetime.datetime.now().strftime('%Y-%m-%d'),
                symbol['name'],
                symbol['shortPercentage'],
                symbol['longPercentage'],
                symbol['shortVolume'],
                symbol['longVolume']
            ])

def main():
    while True:
        sentiment_data = get_sentiment_data()
        if sentiment_data:
            save_to_csv(sentiment_data)
        time.sleep(86400) # Sleep for 24 hours

if __name__ == '__main__':
    main()

......................

Thanks in advance
Jason
The trader is as big as the things that make him angry.
Membro Desde Oct 17, 2024   1 postagens
Nov 23 at 11:11
Hi.
Just wondered if you figured this out, as I'm vurrently trying to do the same tbing.
AJM
Entrar / Cadastrar-se to comment
You must be connected to Myfxbook in order to leave a comment
*Não serão tolerados uso comercial ou spam. O não cumprimento desta regra poderá resultar na exclusão da conta.
Dica: Ao adicionar uma URL de imagem/youtube, você estará automaticamente incorporando-a à sua postagem!
Dica: Digite o símbolo @ para que o nome de um usuário que participe desta discussão seja completado automaticamente.