Skip to content
    Back to all Bounties

    Earn 1,080 ($10.80)

    Time Remainingdue 2 years ago
    Canceled

    Create an Webull Screenshot to Text/Data Program that Sorts Data into Spreadsheet

    jiofunk
    jiofunk
    Posted 2 years ago

    Bounty Description

    Problem Description

    I have thousands of images that look like the following.

    Unsupported image

    Here is another:

    Unsupported image

    Note how this one's 'P/E (FWD)' category is dashed, unlike the first image. The program you create MUST be able to pick up on these differences and properly extract whatever text is there.

    Create a program that extracts all of the data from these images and organizes them into a spreadsheet (.csv or .xslx only). Your submission MUST be an easily runnable .exe. A person with no coding background should be able to use it. The program must be able to run with no internet.

    Some of the images look like this:

    Unsupported image

    Note that some of the categories in this image are in different places than they were in the other images, such as the 'Free Float' category. The program you create must account for these format differences and still organize all data into the correct columns.
    Another format difference is that some images have their 'High" and 'Low' categories organized like this:

    Unsupported image

    Note how the high and low data are in the same region? Your program must account for this and process the data in a way that still separates the High and Low into different columns.

    The program should also produce a separate column that extracts the file names of the images the user uploads. Here is a list for extracting the file name of each file to. Here is a list of what data should be extracted from each image:

    File Name • Symbol • Exchange • Price • Change • % Change • High • Low • Volume • Open • Prev. Close • % Turnover • % Range • P/B • P/S • Free Float Mkt. Cap • Free Float • Market Cap • 52 Week High • 52 Week Low • EPS (TTM) • BVPS • BETA • Shares Outstanding • Lot Size • Turnover • Avg. Vol. (3M) • P/E (TTM) • P/E (FWD) • Dividend • Div Yield • Next Earnings • Ex-Div. Date

    Here is an image highlighting which data should be extracted:

    Unsupported image

    Here are images of how the spreadsheet should be organized:

    Unsupported image

    Unsupported image

    Note how there is only one row of data in this spreadsheet? The program you create must generate a spreadsheet with however many rows of data as there are pictures uploaded. This means that the program must be able to handle processing thousands of uploaded images and extracting data from them. A new .csv or .xslx must be generated for each user upload. The program must store all .CSVs or .XSLXs it has produced in the past. The program must have a user friendly UI.

    Program Requirements

    MUST be run on a local application. I should not have to run this through Replit at all, there should be a completely separate app/.exe that you created.
    • Again, this program must be able to run without being connected to internet.
    • Must be able to pick up on dashed lines, dots, and slashes, and extract them properly
    • Always properly sort data into the correct columns, especially because some images are formatted differently
    • Must have a user friendly UI. **I will tip 2000 Cycles if you can create a UI that is similar to that of this website. Please do not attempt to replicate this UI if you will not do a thorough job. For the 2000 Cycles, you must create a UI that is very close, with similar fonts and elements.

    Acceptance Criteria

    This project must be completely finished by this Tuesday, July 4th. I know the Bounty has a separate date, but that was not up to me. Please have this finished ASAP.

    Please consistently update me on your progress to avoid any misunderstandings over the course of the project.

    I unfortunately cannot compromise at all. The project must be completed exactly as I described. If this is not possible for you, please do not apply. Please only take on this project if you are confident you can complete it exactly as requested.