stockmarket | Python game where you can buy and sell stocks | Business library

I'm working on a GUI project where the user is faced with the following QDialog:

For a school project I am attempting to determine the number of mentions specific words have in Reddit titles and comments. More specifically, stock ticker mentions. Currently the dataframe looks like this (where type could be a string of either title or comment):

I'm trying to get data from a sliding table on a website (like those stockmarket prices on some websites).

I'm using this line:

I am new to python and I don't really understand the sql thing that well. Currently on the 6th week of team treehouse so please bare with me here if these are noob questions.

Goal

1. Import CSV with stock_tickers and 5 other columns of data
2. Convert CSV into pandas dataframe
3. Import dataframe into database. If there is already the unique stock_ticker for it to not add a new row, but next to check if the data in the other 5 columns is different. If it is than update it.

Right now I can do steps #1 and #2 and half of #3. With the help on here was able to get the looping thing to work. If there is a new stock_ticker row in the csv it will add it to database. If the data changes for an existing stock_ticker it won't do any updates.

Question How do I append my dataframe to database so that it checks if stock_ticker exists , only to append the rows where stock_ticker does not exist?

This is the process that I did

1. Import CSV file to pandas dataframe
2. Assign column names to be same as in database
3. Sending the dataframe to database using the code below but getting

sqlite3.IntegrityError: UNIQUE constraint failed: stocks.stock_ticker

I tried to follow the pandas and sqlite3 documentation but I am not entirely sure if I am setting things up correctly.

I set up the database with peewee in this format. I wanted to make stock_id be the number that goes 1,2,3,4,5,6 automatically ect. When I manually add entries with SQLite Browser it seems to work like that.

i have some client script, that connects on socket and wait for data. On server side there is ZeroMQ lib with json wrapper.

So, actually, its a socket connection with json data format. Its a stockmarket data from metatrader. So i wait a one data line per minute. As my timeframe is M1.

The question is why this script eats 100% cpu?

Most of time it should wait for data and do nothing. I thing there might be some mistake in a script. But i have no skill yet in threding. Please tell me where i should look for a problem.

here is a script:

I am trying to set up graphs in my stockmarket project. I am trying to display the graph of the stock clicked on in Gatsby.

Currently, I can display the stock graph of any stock by manually typing in the stock name to the code. I would like to replace the stock name with ${query} inside of the url of the api call because of const query = event.target.value in index.js. So the searched term will be saved as query and I need to have access to the same variable in my other file chartData.js so that I can change my API call from let API_CALL = `https://cloud.iexapis.com/stable/stock/aapl/chart/5y?token=${API_KEY}`; into let API_CALL = `https://cloud.iexapis.com/stable/stock/${query}/chart/5y?token=${API_KEY}`; Thus I will have access to whichever term is searched and be able to turn it into a graph.

I thought maybe I could use state to do this, like moving query to state via query: this.state.value or query: {this.state.value}. Both of these returned errors so I figured that would not work (or I was doing it wrong at least).

index.js

I am making a stock portfolio project using Gatsby and a stockmarket API. Currently, when you search by a ticker-symbol it returns the ticker-symbol, market cap, and previous close in a table. When you click on the returned ticker-symbol it brings you to another page. On this next page, I would like to have access to the same API search just to display more details of the stock.

I was told last night here on StackOverflow I could send API data through Link however after looking through some documentation I am not sure how to implement specifically what I described.

I do not mind switching details.js to a class component, I had tried that earlier and setting state up but I just had a plethora of different errors.

index.js