Search results

Kindly somebody solve my query. I want the conditional formatting to be done in my excel sheet. Kindly somebody solve my query.

Well u have protected this sheet. so i can't view the formula. I want only the IV prices font to be changed. According to the conditions mentioned by me

Dear Excel Experts, I'm looking for a conditional formatting formula were the condition is if the IV price is trading above the CMP then it should be should in red color. Similarly, if the IV price is trading below the CMP then it should be in green color. The working file is attached along...

Thank you dear...its working fine

Dear Excel Experts, In the attached excel sheet i have two sheets named Data and Industry PE. In the Industry PE sheet i have given the Industry PE of each specific sectors. But in the data sheet in the M column u will see Ind PE downwards all the data's are blank. I'm looking for a formula...

Marc sorry for the delay in reply since i was not welll. I'm giving my explanation in a step by step process given below:- 1. First open a blank excel file. Adding two command buttons. First command button name "INSERT FILE" & Second command button name "PROCESSING". 2. Once the user click the...

Marc i didn't understand what do u mean by a relative column. the idea here is combine data just like the text file given in the notepad. Even without vba u can do it do help me out. Once the data is like the notepad text file then i can upload into my charting software.

Note:- In the sec_bhavdata_full_21042023 care should be taken only to take datas which contains only EQ and BE in column named "SERIES" rest of the datas should be avoided ok

Dear Excel Experts, Every day i used to download the indices and stock details file from the nse website. The first file named ind_close_all_21042023 contains all the indices data and the sec_bhavdata_full_21042023 contains all the stocks data. The NSE updates this files on a end today basis...

ETAF the problem is solved ok. Thanks for ur help

Bosco i tried ur formula but an error happened. Anyway the problem is solved and you have been a great help when i post any of my queries. Kudos Bosco.

Thank you Friend....this formula is working perfectly fine. All the results are correct. Thanks a lot

Dear Excel Experts, In my attached excel sheet i have added some numbers which are in the heading "High - Open" and "Low -Open". The aim is to give a formula in the trend column as of now the result i have typed manually. For each trend i have given note. Can a formula be made as per my...

Bosco its perfect. What will be the formula for this condition Gap Down "Won" condition ">= -0.50% and < -1% Gap Down "Won condition ">=-1% and < -2%

Dear All, In the attached Countifs Working file i was just counting how many Gap Up "Won" condition ">=0.50% and <1%". I'm getting only 3 but the actual result is 4 between the given dates. Do help me to correct the formula. Thanks & Regards, Sonjoe Joseph

It comes to around Rs.6000 bugs every year according to India. If this was a one time payment i would have been paid.

Bosco this office 365 is very costly this guys are charging almost Rs.6000 per year. Is Microsoft Business Basic is good. but its only Rs.125 a month but i think it has limited features. My use is to link my trading terminal to excel and to get live data's. I also need to do lots of...

Thank You Bosco for helping me

Its working my dear

ETAF you array formula is working perfectly fine.. Just checked it now. Thank you for helping me

Dear All, I have an excel sheet in which i have created 3 sheets named " DD which contains drop down to select date, Data which contains some transactions & Extract were the needed data is to be extracted. I need to extract only the date, TC, NET (P/L) & EC from the "Data" to the "Extract"...

Thank You Bosco...This is working perfectly fine. Kudos to you and thanks a lot for helping me.

Tried using the formala....but some of them coming wrong. Even i entered the High and Low prices and applied ur formula but still coming wrong.

Do u need the lows and highs ....i will send if u want....i want to make this right. Do message me

Bosco i checked yours is almost 95% correct but i got three errrors which are marked in red. Kindly go through do edit how to rectify that ok. The file is attached long with this message.