Find Jobs
Hire Freelancers

getndone Stock News Crawler

$30-250 USD

In Progress
Posted over 13 years ago

$30-250 USD

Paid on delivery
i need a php program to get symbol from my db table below. the program must be FAST because there are over 4000 symbols select symbol from StockSymbols; mysql> desc StockSymbols; +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+----------------+ | StockId | int(11) | NO | PRI | NULL | auto_increment | | Market | text | NO | | | | | Symbol | text | NO | | | | +---------+---------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) crawl the url for the newest news url is formatted like this [login to view URL]{Symbol} sample url [login to view URL] get all title, link, datetime of article, symbole do the following if the article is not in the news table below it will insert it into the table if the article is in the news table already move on to the next symbol mysql> desc news; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | title | text | NO | | | | | link | varchar(200) | NO | UNI | | | | news_date | datetime | NO | | | | | news_summary | text | NO | | | | | newskey | varchar(200) | NO | | | | +--------------+--------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) and no duplicates. the crawler will move on to the next symbol after it finds news that it is found already you understand i do not want any duplicates and the crawler will move on to the next symbol if it finds a duplicate you can actually get the last entry from the db and if it matches move on i need it to be fast becuase there are a lot of symbols
Project ID: 844937

About the project

1 proposal
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average $30 USD for this job
User Avatar
please, give me a chance to do this work.
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hacienda Heights, United States
4.9
199
Member since Feb 17, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.