Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

find nearest (higher and lower) value

Featured Replies

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.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.