OEC excel Add-in Update Quotes together with the Positions in Excel

NexusFi · 2017-10-05T07:55:31-04:00

Hi folks, With the OEC Excel Add-in, I am able to get all positions from Gain into excel. There is a column "Symbol". With the value under "Symbol", I manually key in it to form a proper query statement for "Quotes", to get "Bid", "Last" etc fram gain. I didn't find a way to combine the symbol value into the query statement though. The worse comes when new positions are added. New positions comes in alphetical order such that it can be insert into the …

Discussion in Options

Updated October 5, 2017

2,260 views
0 thanks given
1 followers

Search this Thread

OEC excel Add-in Update Quotes together with the Positions in Excel

October 5th, 2017, 07:55 AM	#1 (permalink)
sinpeople Singapore Elite Member Experience: Beginner Platform: TDAmeritrade Trading: Options On Futures Posts: 44 since Aug 2017 Thanks Given: 4 Thanks Received: 10	Hi folks, With the OEC Excel Add-in, I am able to get all positions from Gain into excel. There is a column "Symbol". With the value under "Symbol", I manually key in it to form a proper query statement for "Quotes", to get "Bid", "Last" etc fram gain. I didn't find a way to combine the symbol value into the query statement though. The worse comes when new positions are added. New positions comes in alphetical order such that it can be insert into the existing position rows. Then I have to update the Quotes part manually again. How do you update the quotes automatically by tie it with the positions query results? Many thanks. I have attached my OEC worksheet in the image below. Best Regards David =========================================