PUT and CALL options

[columbus]

thank you.

Suggestion:

since you take screen shot of , could you please change
the highlight color of PUTs section ......

this is slightly unreadable.


many thanks....

Hi comm,

Filling of digits 0,6,8 and 9 is creating problem.Planning to change
some colours.Format posted by timepass is too good.

 

[timepass]

Columbus, it is a simple .xls file, with data copied from old nse site and pasted directly in Excel. Then you can simply resize the boxes.

 

[columbus]

Feb series-Day6 ,NiftySpot:5326 (+56)

The EFFECTIVE ZONE moved to at 4900~5400.Upto 1400hrs ,there was hardly
any movement in the Nifty.There is HUGE build-up of positions ,especially
in PUT side.

Options less than 10 Rs are shown in white text.


New format.Courtesy:Timepass
Though the format is good,lot of editing is required.
Bid-Ask rates/volumes are deleted ,so that the table fits into this page ,without
any difficulty.

 

[timepass]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

Though the format is good,lot of editing is required.
Bid-Ask rates/volumes are deleted ,so that the table fits into this page ,without
any difficulty.

Yes. I did mention in an earlier post that it was too much trouble. You can cut down the trouble by using a blank sheet for rough work and pasting only the final data in the formatted sheet.

For copying from net, to paste it in excel, an easier way is to right click in excel, choose "Paste Special" and then paste as "Text" or "Unicode Text". Try it.

 

[columbus]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

Yes. I did mention in an earlier post that it was too much trouble. You can cut down the trouble by using a blank sheet for rough work and pasting only the final data in the formatted sheet.

For copying from net, to paste it in excel, an easier way is to right click in excel, choose "Paste Special" and then paste as "Text" or "Unicode Text". Try it.

Hi Timepass,

At present I am using PASTE SPECIAL >>>TEXT only.

 

[timepass]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

At present I am using PASTE SPECIAL >>>TEXT only.

Aha.. that reduces the effort a lot.

 

[adityasaraf007]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

New format.Courtesy:Timepass
Though the format is good,lot of editing is required.
Bid-Ask rates/volumes are deleted ,so that the table fits into this page ,without
any difficulty.

Aha........ Let me see..... If I can make that Excel Sheet completely mechanical.... It would color all the rows for you........ If I am successful in creating such a sheet would share it over this weekend......

 

[columbus]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

Aha.. that reduces the effort a lot.

Hi timepass,

By writing a small MACRO the effort will be reduced further.
I am good at QUATTRO PRO ,quite similar to EXCEL.Right now it is not
installed in my LAPTOP.

 

[timepass]

Ha !! Qpro !!!! Heard that name after a long time. I have never used Qpro though, I learnt spreadsheets on Lotus 123. Never had the need to use macros either.

 

[columbus]

Re: Feb series-Day6 ,NiftySpot:5326 (+56)

Aha........ Let me see..... If I can make that Excel Sheet completely mechanical.... It would color all the rows for you........ If I am successful in creating such a sheet would share it over this weekend......

Hi Aditya,
Thank you.Things like Column Width,Number Format ..... can be changed
using a simple MACRO.But Background colour and Text colour involves
conditions.