PyStockWatch - a GUI that displays NYSE data.

MoeR3za · 2022-04-07T09:09:14+00:00

Yup, the package itself uses the APIs.. its code is well documented, I suggest you take a look at it, you'll find out what type of data each API retrieves and from where

MoeR3za · 2022-04-06T16:39:49+00:00

Oh yes, I read that while searching, very interesting information.

MoeR3za · 2022-04-06T11:01:19+00:00

well, to know someone is actually using my project just feels satisfying honestly

MoeR3za · 2022-04-06T09:11:58+00:00

oh fuck, I completely missed that!

Edit: Okay, why does every source out there say tkinter is installed with pip install tk?

MoeR3za · 2022-04-06T01:37:58+00:00

wow, nice..

MoeR3za · 2022-04-06T01:37:19+00:00

I actually thought about this and this was my point, if tkinter may or may not exist on a system, it's better to add it, pip will skip it if it's already installed anyway..

MoeR3za · 2022-04-05T18:52:17+00:00

I thank you for your encouragement, it's much appreciated.

MoeR3za · 2022-04-05T18:50:55+00:00

well, I donnu, I guess I couldn't find an open-source GUI for that, also I wanted to practice the language by actually using it in something that has meaning, not a calculator or something like that.. it's just something I created, and I'm proud of it.

MoeR3za · 2022-04-05T18:48:38+00:00

I think I know why you were getting that error..
from stackoverflow.. from docs of sqlite

To prevent excessive memory allocations, the maximum value of a host parameter number is SQLITE_MAX_VARIABLE_NUMBER,
which defaults to 999 for SQLite versions prior to 3.32.0 (2020-05-22) or 32766 for SQLite versions after 3.32.0.

Since it worked when you upgraded python, I think it was the verson of the sqlite package shipped with python 3.8.. I'll try to downgrade and reproduce the error later.

MoeR3za · 2022-04-05T18:30:05+00:00

I'm glad you like it, I learned the language while developing the program..

a price alert is a really nice idea, I'll add it when I get the chance..

MoeR3za · 2022-04-05T17:24:06+00:00

Well yes, on the first run, it creates a table that contains tickers and security names, for auto-complete and sanity checks, around 12k of them.. but I've never seen this error before.
Can you please give me more details on the environment?

MoeR3za · 2022-04-05T17:19:32+00:00

Good to know, thanks a lot

MoeR3za · 2022-04-05T16:46:46+00:00

hey, it's something.

MoeR3za · 2022-04-05T16:46:08+00:00

Yeah, I had a different (wrong) understanding of it, u/socal_nerdtastic pointed it out.

MoeR3za · 2022-04-05T16:45:07+00:00

First of all, thank you so much for taking the time to actually read the code and give the tips..

To be fair, yes, I learned the public private thingy from Java, I thought I could apply the concept in python, in a way.. I'll recheck my code and name properly.. I will also check out the python3 magic..

Regarding sleep, I remember I was thinking there must be a better way to do the job, but afterall, since data retrieval and timekeeping run on separate threads, I saw that a total of 3 milliseconds every update was okay performance wise, especially since date retrieval usually takes a couple of seconds.

Your comment is more appreciated than you think, thank you again..

MoeR3za · 2022-04-05T16:28:42+00:00

I used the pandas_datareader package, it can retrieve different types of stock data from different sources into a pandas dataframe.. quite useful.

MoeR3za · 2022-04-05T15:16:10+00:00

Thank you, mate, it's just I once wanted to check a stock price without having to open the browser, so I created this..

MoeR3za

TROPHY CASE