Skip to main content

Questions tagged [pset7]

For problem set 7 (CS50 Finance)

182 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
0 answers
2k views

How to call the usd function in the jinja template of quoted.html?

I want to display the cost of the share in Quote tab using the "usd" function defined in helpers.py. I've tried adding app.jinja_env.globals.update(usd=usd)in application.py and then calling the ...
Aditya Gaikwad's user avatar
2 votes
1 answer
68 views

Students only passing 4/6 the last two showing concatnation error but works locally somebody help

[33mTraceback (most recent call last):[0m [33mFile "roster.py", line 34, in main()[0m [33mFile "roster.py", line 27, in main print(row[0] + " " + row[1]+" "+ ...
Dynamo Denis's user avatar
2 votes
1 answer
306 views

I receive "Not authorized to access this private project" page when trying to get to CS50 Finance page in pset7

I think something is incorrect with my permissions when I'm trying to set up my pset7 materials per the spec. I've followed the spec exactly. I used username50 and password50 to put my username and ...
Dash Young-Saver's user avatar
2 votes
2 answers
100 views

Difficulty submitting PSET7 to be graded

My pset7 zip file is about 700kb, i click in "Add files..." button and select pset7.zip, next i click the "Start upload" button, the uploader appears to fill pretty fast as normal but it doesn't ...
thomas's user avatar
  • 167
2 votes
1 answer
168 views

pset7 finance unable to submit

My zipped pset7 folder is about 6oo KB and is taking hours to upload. I eventually abort because it seams to go on forever. In contrast other psets upload in a matter of seconds. Any help is greatly ...
Rachel Zhande's user avatar
1 vote
1 answer
67 views

PSET7/SQL Any clues as to why my logic isn't working? (13.sql)

This very nested query is to return names of all the actors that performed on a Kevin Bacon film. Instead it's returning nothing, any ideas are appreciated! Note: I'm yet to implement the part that ...
General Noob's user avatar
1 vote
1 answer
833 views

roster.py not getting output

import sys import cs50 # checking argv (that there's one and it's a csv) if (len(sys.argv) != 2): sys.exit("Usage: roster.py house_name") housename = sys.argv[1] #print(house_name) #open(f"...
Hama Ijaz's user avatar
1 vote
1 answer
113 views

Pset7 Finance Unable to Buy Multiple Shares

I am able to make 1 purchase which appears on my index page, however if I try buy any further stocks my cash goes down but the stocks are not shown and aren't inserted into my portfolio. Here is my ...
M. Alex's user avatar
  • 135
1 vote
1 answer
96 views

style50 not updating

I recently submitted the pset7/finance in cs50. I checked for style in style50 and it returned looks good! which is an indication that it is correct. But when I submitted to using submit50 I ended ...
paradox_hunter's user avatar
1 vote
1 answer
76 views

Pset7 Yahoo finance broken

I've been working on this problem for a long time. I've asked people about my code and they say everything looks fine with it, and I've been told the yahoo finance has been taken down. I can't do this ...
Joel Banks's user avatar
1 vote
0 answers
238 views

PSET7 check50 error code 400 logging in registered user

Running into issue with PSET7 check 50.It frowns at me and says :( logging in as registered user succceeds expected status code 200, but got 400 Log sending POST request to /login checking that ...
mrspacely's user avatar
1 vote
1 answer
654 views

issues with buy - functionality works but fails check50

Can't figure this out. My code passes functionality it buys stocks no problem but fails check50 with this error: :( buy handles valid purchase application raised an exception (see log for details) ...
Arun Narayanan's user avatar
1 vote
0 answers
90 views

Python PSET7 /Buy

Can't figure this out. My code passes functionality it buys stocks no problem but fails check50 with this error :( buy handles valid purchase application raised an exception (see log for details) ...
Arun Narayanan's user avatar
1 vote
1 answer
107 views

My implementation of cs50 finance goes wrong with check50

My implementation of CS50 finance has security questions as personal touch on the register page. I believe this is why check50 is failing to detect successful user registration. What do I do in such a ...
Archit Checker's user avatar
1 vote
2 answers
181 views

Pset7 => "NoneType" error on SELECT query (2017)

I’m really stuck on the index part of PSET7…. Flask keeps iterating over the following SELECT query: dab = db.execute("SELECT SUM(share) FROM portfolio WHERE symbol = :symbol AND user_id = :user_id",...
Faye_108's user avatar
1 vote
0 answers
134 views

Pset7 - Quote always returning apology

So, I'm struggling with pset7 a lot (mostly because I've never programmed before either =/) now I'm on quote and it's always rendering an apology after I fill in the form. I can't quite figure out ...
Gabriel Luz Carpes's user avatar
1 vote
1 answer
930 views

AlphaVantage API Error "Please consider optimizing your API call frequency"

On C$50 Finance, when I refresh my web server too many times, AlphaVantage stops returning stock quotes. As a result, Flask returns "TypeError: 'NoneType' object is not subscriptable" when my code ...
John Quinn's user avatar
1 vote
1 answer
500 views

Pset7 - CS50 Finance - Register - returns the same apology each time

When im testing my code by entering in blank entries in username or password, i expect the site to show me the apologies like "Must provide username" or "Must provide password", but it only shows the ...
L.D's user avatar
  • 27
1 vote
0 answers
59 views

CS50 Final Project: Unique URL for each user of my flask app (2 of 2)

I have a pending question here: CS50 Final Project: Unique URL for each user of my flask app (posted two days ago) regarding the implementation of unique URLs. This unanswered question was in fact ...
Alex Chan's user avatar
  • 121
1 vote
1 answer
466 views

Pset7: from cs50 import SQL - 'No name SQL in module CS50'

Getting the above error at the head of my pset7 programme in the cs50 ide. Any advice? I've tried updating cs50 a couple times. edit: Also CS50 IDE is displaying an error: 'Error: [object Object]'
Zach Arundel's user avatar
1 vote
1 answer
3k views

flask.cli.NoAppException Error when trying to launch web server in pset 7

I'm trying to finish up pset7 and was trying to launch the web server to view the result but every time that I do I get the above error. I'm not really sure what I'm doing wrong. I ran flask in the /...
Dave G's user avatar
  • 15
1 vote
1 answer
183 views

unable to start apache

while doing pset7 first phpMyAdmin wasn't working, so I searched online and ran a few commands on the terminal and now even apache is not working and shows the following error: Starting web server ...
Pranjal Sharma's user avatar
1 vote
1 answer
48 views

Question about php mailer

suppose I have an email address [email protected] can I use this email address to send mails through the php mailer code where in the TODOs the password is the password of [email protected] and ...
Furrukh Jamal's user avatar
1 vote
1 answer
143 views

PSET7 - Using OOP in CS50 library

I´m really curious about the CS50 library (cs50.php). I noticed that the staff implemented OOP there (object oriented php) but not in helpers.php. I just wonder why? Does anybody know?
Ania Kludka's user avatar
1 vote
1 answer
209 views

accessing pset7 from outside the appliance

I was just wondering if there was anyway to access the cs50finance webpage from outside the appliance, using a browser for example. I was hoping to get some friends who don't live in the same city, (...
William Kenney's user avatar
1 vote
0 answers
287 views

error: token mismatch for pset7

For pset7, I followed steps to do assignment, just till below Zamyla's first video. When I finished the register.php and open http://pset7/register.php to see the result and open phpMyAdmin Browse tab ...
Ken Ding's user avatar
  • 111
1 vote
0 answers
88 views

PHPMailer library not found

I am trying to implement the phpmailer and I am stuck at the first step calling the PHPMailer library. I have tried multiple path variations, but can't figure out where the library is located, e.g.: ...
romain galoisy's user avatar
1 vote
0 answers
307 views

Update Cash in "sell.php" is Not Working

Everything is working file but the cash is not updating. I think its due to typecasting. The value for shares is an integer and price is a float-point integer but I'm confused as to how to cast them. ...
avishek arora's user avatar
1 vote
1 answer
403 views

CS50 Finance not showing up

I'm starting CS50 Finance and I've reached a small hitch. When I try to load the page "pset7"/localhost (After doing all the first steps listed in the spec), I don't get the CS50 Finance logo, but ...
lijrobert's user avatar
1 vote
2 answers
843 views

Password for phpLiteAdmin

I am requested to enter a password for phpLiteAdmin. I was following steps from the lecture, intro to phpliteadmin. After I inserted a new row ("name", "dorm") into the table registrants, I got this ...
wingedRuslan's user avatar
0 votes
0 answers
11 views

Pset9 finance final error not solved

Like many others before me, I am stuck at the sell error in pset 9 - finance :( sell handles valid sale Cause expected to find "56.00" in page, but it wasn't found Log sending GET request to ...
Akash Thanki's user avatar
0 votes
0 answers
48 views

PSET 7, Error when executing query: Not an executable object: 'SELECT 1'

When I try to check my songs or movies problem, "Error when executing query: Not an executable object: 'SELECT 1'" comes up. Executing in sqlite3 works fine though, and I have submitted ...
Alexandra Shevchenko's user avatar
0 votes
0 answers
41 views

ModuleNotFoundError: No module named 'validator_collection'

I am facing this issue of "Module Not Found Error" when executing response.py assignment. I have already installed the module via PIP.
Afridi's user avatar
  • 1
0 votes
0 answers
37 views

Week 7 Movies - 13.sql Query Running Forever

Title is a bit of a lie because I didn't sit around for ages waiting to see if the query will end up executing or not. However, I really can't find a reason for why this query would take so long to ...
qwest's user avatar
  • 1
0 votes
1 answer
76 views

No results hours after submission pset7

I completed pset7 yesterday and submitted it, but there are still no results after 12 hours and my progress has not been updated to show that I have completed week 7. Check50 worked fine, I'm logged ...
Malia's user avatar
  • 1
0 votes
0 answers
62 views

PSet7 Fiftyville: Two possible thieves and accomplices left, can't figure out how to narrow it down further

I've narrowed who the thief and accomplice are down to two choices, but I can't figure out how to narrow it down further (I already have where the thief escaped to). The only tables I haven't used are ...
They think im slow EH's user avatar
0 votes
0 answers
29 views

What's wrong in this query?

Why this query outputs just 61 rows instead of more than 185? I 'm trying to do 13.sql SELECT name FROM people WHERE id = (SELECT person_id FROM STARS JOIN people ON people.id = stars.person_id WHERE ...
Mohamed Hassan's user avatar
0 votes
1 answer
3k views

Fiftyville - please help!

I am quite sure about my answers... but still, check50 doesn't approve my answers... can you please tell me whether my answers are indeed wrong to start thinking about it again cause in my mind I am ...
Danae Philioti's user avatar
0 votes
1 answer
288 views

How does the database ER diagram look like in Pset7 (Fiftyville)?

Pset7 (Fiftyville) DB has 10 tables. It would be much easier to work with them if the entity–relationship model (ER diagram) is presented. Pset description doesn’t have it.
NeMaksym's user avatar
0 votes
2 answers
763 views

Fiftyville: Can't find a logical way to find the thief

I have done the appropriate INTERSECTION between the person at the: atm, exiting the parking lot and the person on the first flight out of Fiftyville on the 29th. I am left with two people. I know who ...
Oris's user avatar
  • 1
0 votes
1 answer
128 views

pset7/fiftyville - Some people do not have a passport number

I ran the following query SELECT name, passport_number FROM people ORDER BY name; This was the result name | passport_number Aaron | 9852889341 Abigail | Adam | Alan | 2884243902 Albert | ...
Upanshu Lakhani's user avatar
0 votes
1 answer
48 views

pset7 - buying and selling from index results in duplicate flash's and apologies not being rendered

I passed all the check50 tests and I am working on my personal touch component, which for me is adding buying and selling to index. Everything works except: When more than one stock is sold/bought, ...
Clueless's user avatar
0 votes
1 answer
49 views

7.sql CASE error

I'm getting an error where it says Error: near line 3: near "DESC": syntax error My code is SELECT title, rating FROM movies JOIN ratings ON movies.id = ratings.movie_id WHERE year = 2010 ...
Snow's user avatar
  • 11
0 votes
1 answer
81 views

Pset7 houses - why does my output prints thrice instead of once?

The code is as follows: for row in students_list: first, middle, last, birth = row["first"], row["middle"], row["last"], row["birth"] print(f"{...
Bryson Ang's user avatar
0 votes
1 answer
602 views

PSET 7 Movies 12.sql

can someone explain the difference between using IN and "="? Here is my code. When I use IN it runs perfectly but when I use "=" there is no output. Thank you! SELECT title FROM ...
anahop's user avatar
  • 1
0 votes
1 answer
188 views

Pset7 Movies Q12: I don't get what's wrong

I can't figure out why my pset7 movies Q12 code isn't working. Can anyone tell me why? Here is my code: SELECT DISTINCT title FROM movies, stars, people WHERE movie_id IN (SELECT movie_id FROM stars ...
Miguel's user avatar
  • 1
0 votes
1 answer
270 views

CHECK50 Bug in pset7: movies SQL

I have been banging my head on this for an hour and half. Finally finished the pset, uploaded it. Check 50 says: Now, both cs50 ide and DB browser return the correct results, and number of lines for ...
andrewdoeslearn's user avatar
0 votes
1 answer
461 views

pset7 Q7: How many actors are named "Meryl"?

I am at a complete loss for something that should be very simple to find in SQLite. In the IMDB database, I have to find how many actors have the name 'Meryl', I have tried select name, count(name) ...
StimpakNeeded's user avatar
0 votes
1 answer
50 views

I am working through roster.py, but the first line in the solution is not printing in my output. why is this happening?

import cs50 import sys import sqlite3 db = sqlite3.connect("students.db") house_reader = db.cursor() if len(sys.argv) != 2: print('Usage: import.py file.csv') exit() house_reader.execute("...
Oran S Goodman's user avatar
0 votes
0 answers
83 views

Pset7 buy route error due to API use by lookup function

I am experiencing an error each time I call the lookup function within the buy route when the request method equals post. However, calling lookup during quote does not result in the same error. I ...
Bilad's user avatar
  • 1