Mahendra Mistry
View Profile

EXCEL ONCE AGAIN

Mahendra Mistry at 05:32 PM - Mar 25, 2014 ( ) Views: 2,923

5 12

Experts.. here's the situation...

I transfer the live feed from ODIN to Excel just by one click...  below that screen with live streaming I paste my Buy / SELL with targets...EXAMPLE...

Script Name Buy above Target1 Target2 Target3 Target4 Sell Below Target1 Target2 Target3 Target4
ADANIENT 326.9271697 327.815929 328.7047 329.97 330.7383 321.1728 320.2841 319.3953 318.13 317.3617
AMBUJACEM 187.4137354 187.8195489 188.2254 188.8031 189.1539 184.7863 184.3805 183.9746 183.3969 183.046

Also, I added one column where I  put a formula saying when LAST TRADED PRICE IS ABOVE my Buy value display BUY..

However, My question is that is there any way I can add a POP UP notification for this like list of stocks.. and it should give me a notification when it changes to BUY / SELL / WAIT which has been added with the formula


(1 to 20 out of 33) - Latest Replies on Top | First | << Previous | Next >> | Last |
Mahendra Mistry at 09:37 AM - Apr 14, 2014 ( )

BALU JI... u can find the the formula and Gann right in the very sheet on the excel file I upload through  dropbox... in regards to elliot wave u have to check whats the pattern day is running... check on the low and high till 10 and then check on appropriate buy or sell..

Balu D at 03:15 PM - Apr 12, 2014 ( )

GANN ...ok ....how find ELLIOT...BUY AND SELL LVL...?

Mahendra Mistry at 02:00 PM - Apr 12, 2014 ( )

Balu ji... I've sent the excel file with the GANN and Elliot calculations as well... u can do the calculations in that... I am not sure about below link...

Balu D at 06:19 PM - Apr 11, 2014 ( )

http://www.pivottrading.50webs.com/pivot/pivot/gann.html

http://www.pivottrading.50webs.com/pivot/pivot/elliot.html

is it correctt?

Mahendra Mistry at 05:48 PM - Apr 11, 2014 ( )

I think was easy as per automation where as GANN and elliot calculation is bit difficulty.. however, would really appreciate if u can chck on this... let me know if u want to know anything else with this excel

Mahendra Mistry at 05:47 PM - Apr 11, 2014 ( )

https://www.dropbox.com/s/u509ut8h0d0eps0/mudraa%20--BALU%20D%20sirji.xlsx

Balu D at 03:52 PM - Apr 11, 2014 ( )

dear,  Mahendra Mistry  in the EXCEL ...in  B16....see three condition and 1.1 to 25% FIBO and 25 to 40 % =GANN and ABV 40% = ELLIOT......Pls explain    fibo in the same excel ok  gann and elliot....?

Kashish Mirpuri at 12:28 PM - Apr 11, 2014 ( )

As soon as the status (WAIT/SELL/BUY) is changed manually or some other program changes it, it will display a pop up box with the scrip name and the updated status.

Kashish Mirpuri at 12:25 PM - Apr 11, 2014 ( )

Hello Sir, I have tried to solve your problem. Please check it out.
https://www.dropbox.com/s/zmnovm5udp1tzud/Arbitrage2014.xlsm 

Mahendra Mistry at 04:52 PM - Apr 10, 2014 ( )

Anyone intesrested to add something on it??

Mahendra Mistry at 06:24 PM - Apr 07, 2014 ( )

PING>>>

Mahendra Mistry at 06:32 PM - Apr 04, 2014 ( )

AUR KOI!!

Darn really curious and excited about this...

Mahendra Mistry at 09:12 AM - Apr 04, 2014 ( )

balu ji... here's for my buy and sell...

howevr, it's only for bank nifty.. i use similiar for equity

https://www.dropbox.com/s/acwabzot43b51sf/Mudraa%20Testing%20Automated%20BNF%20only.xlsx

Balu D at 09:09 AM - Apr 04, 2014 ( )

how u calculate BUY ABV and SELL BELOW values....pls explain and i search for code - POP UP

Roshan Men at 11:23 PM - Apr 03, 2014 ( )

Mahendra bhai I don't understand why u need a pop up notification when the buy/sell signals are clearly visible in the excel. is this file updated in real time or do u have to click on something to import the data?

Roshan Men at 10:57 PM - Apr 03, 2014 ( )

u can use vba to get a pop up. if u upload the excel file I can do it for u

Mahendra Mistry at 10:10 PM - Apr 03, 2014 ( )

ANYONE YET??

Mahendra Mistry at 06:14 PM - Apr 02, 2014 ( )

https://www.dropbox.com/s/jc7pbsg7v8xihhj/Arbitrage2014.xlsm

here's the excel sheet where I want the POP UP.. u can see the formula and if u scroll till "A74" u can see the the calls also.. from there I take the reference of buy trigger price with CMP on AL6, AM6, AN6... I hope u feel my concern...

Mahendra Mistry at 09:07 AM - Mar 31, 2014 ( )

@Nitin JI.... just to ask can we use filter in excel showing live data from odin ??

@Roshan Bhai... I'll update the file and paste link in here... just reached office and market is abt to open....

Thanks Experts for your help..

Regards,

Mahendra

Nitin Potade at 08:42 PM - Mar 29, 2014 ( )

Mahendra bhai,

I never tried it and I use filter command to find the desireable results.

Thanks.

1 to 20 out of 33

Login to participate in discussion.



Top Gainers

MCDOWELL HOLDINGS LTD. 19.80 3.30 (20.00%)
HATHWAY CABLE & DATACOM 32.50 5.40 (19.93%)
SOMI CONVEYOR BELT. LTD. 14.80 2.45 (19.84%)
DEN NETWORKS LTD 80.55 10.70 (15.32%)
INDUSTRIAL INV TRUST LTD 72.80 8.00 (12.35%)
THE MANDHANA RET VENT LTD 13.35 1.20 (9.88%)
63 MOONS TECHNOLOGIES LTD 99.00 7.55 (8.26%)
CINELINE INDIA LIMITED 35.75 2.65 (8.01%)
FLEXITUFF INTER LIMITED 13.95 0.95 (7.31%)
NAVIN FLUORINE INT. LTD 689.90 45.80 (7.11%)



Top Losers

HOUSING DEV & INFRA LTD 8.80 -2.20 (-20.00%)
CG POWER AND IND SOL LTD 11.85 -2.95 (-19.93%)
VAKRANGEE LIMITED 27.70 -6.30 (-18.53%)
SANGAM (INDIA) LTD 40.00 -8.00 (-16.67%)
PARAG MILK FOODS LTD. 142.50 -18.60 (-11.55%)
PARAMOUNT COMM LTD 8.85 -1.10 (-11.06%)
AKSH OPTIFIBRE LIMITED 6.55 -0.80 (-10.88%)
SHREYAS SHIPPING & LOGIST 72.00 -8.00 (-10.00%)
SUPERHOUSE LIMITED 70.85 -7.85 (-9.97%)
IND TERRAIN FASHIONS LTD 75.00 -8.15 (-9.80%)