Jump to content
Sign in to follow this  
markfmf

Table Occurences - filtering prices according to price ranking

Recommended Posts

Dear Forum members

I am struggling to implement the following.

Tables:

Table 1: Shares (Products)

Product ID -- Name

[color:red]P1 -- BHP Billiton

Table 2: Details Share Prices as at different dates and also details the Price Source.

fPID-- Date – Price – Price Source

[color:red]P1 – 31/10/2008 – 10 – Yahoo-finance

P1 – 31/10/2008 – 10.5 – Reuters

P1 – 30/11/2008 – 10 – Yahoo-finance

Table 3: Price Sources Ranking

For a certain share (e.g P1), the user can select the ranking of price sources. That is, given several price sources at one date, the final result (table) should detail that price with the highest ranking.

E.g Lets say there are two price sources for a given share (Yahoo and Reuters). The users ranks these price sources in order of preference. If at a certain date e.g 31/10/2008, there are two price sources avalaible for the same product, then the result should take the highest ranking price source as selected by the user.

Lets assume the user selected Reuters to be the default price source, and if no other price source existed then the price as given by Yahoo finance should be sourced. So in this example; the final price as at 31/10/2008 is 10.5 as Reuters is the first ranking price source. For 30/11/2008 the price is 10, as Yahoo is the only price source avalailable.

Problem:

Ideally, in Table 1 (or a TO of Table 1) I would like to have a portal or similar that displays all prices for all dates and that only details one price as at a certain date (and details that price which has the highest price source ranking as listed by the user).

I hope the above is clear enough.

R

Mark

Share this post


Link to post
Share on other sites

Hi Mark,

Does each user have their own set of ranking for each price source, or does this order true across all users?

Stephen

Share this post


Link to post
Share on other sites

I intend to let the admin determine the pricing source order/ranking. Such that the order is tru for all users.

R

Mark

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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