Jump to content

find nearest (higher and lower) value


alimrb

This topic is 6145 days old. Please don't post here. Open a new topic instead.

Recommended Posts

i have two tables named eps & price:

'eps' fields:

id

company

ReportDate

eps

'price' fields:

id

company

date

ClosePrice

in the stock exchange in my country shares closed some days before eps report date and aren't traded to some days after report day, it hasn't any rule how much days a stock was closed, maybe 1 day closed, maybe 2 months closed, i want to know the price of closed stock in the trade day just before closed day for eps reporting and just in the trade day of opening.

somebody help me please.

Link to comment
Share on other sites

This topic is 6145 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.