Stock Transaction List

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
spillaip
Senior User
Posts: 20
Joined: Sun Nov 01, 2020 8:51 am
Are you a spam bot?: No
Contact:

Stock Transaction List

Post by spillaip »

I am trying to write a Stock Transactions report between two dates, need help with the query. The format is:

Date of Transaction
Type of transaction
Stock
Qty
Price
Cost (Qty*Price)
Current Price
Current Value

Help is greatly appreciated.
Thank you
Dr Suresh PB
Fanntiago
New User
Posts: 1
Joined: Thu Jun 27, 2024 1:03 am
Are you a spam bot?: No

Re: Stock Transaction List

Post by Fanntiago »

I think you can add the buy and sell volume during the day
- Dustin Kramegeometry dashr -
spillaip
Senior User
Posts: 20
Joined: Sun Nov 01, 2020 8:51 am
Are you a spam bot?: No
Contact:

Re: Stock Transaction List

Post by spillaip »

I have already input the stock transactions. The need is to get a query to get list of stock transactions.
Thank you
Dr Suresh PB
User avatar
Renato
MVP User
Posts: 720
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Stock Transaction List

Post by Renato »

No developers are currently active.
Users who are active in the forum will probably not have such a good knowledge of SQL to be able to fulfil such requests.

MMEX is a classic open source project and there is no entitlement to support. The forum here is a user forum, which means that users help each other.
I have tried to document further explanations about Open Source here: viewtopic.php?t=11132
Renato Forum Administrator
Post Reply