Here I will post some excels, which will help in taking Buy/Sell decisions and zeroing the stocks to trade.
As you all know, its always better to club any system with indicators, before entering the trade
and this applies here as well !!!
so take decision wisely, enter only if you have atleast...
I want to make a excel sheet of stocks along with their cmp, financial ratios like roe, roce, pledged shares, etc. but doing it manually for all 5000+ stocks is almost impossible. So can anyone help me how to do it. Most screeners out there mostly doesn’t cover all BSE stocks. If they do, then...
Please help me plot IV data for call and put in amibroker.
I want the data to be pulled up from www.nseindia.com.
Hi guys, i am using Nest Terminal for Zerodha and also for Karvy. I have been having difficulty to get the real time data from Nest to link to Excel (No Aibroker or FCharts)
I have been working on an option Valuation model for which i just want RTD in Excel. I have tried everything but "#N/A"...
I have an excel sheet that fetches Call Put data from nifty every one minute. That is auto refreshing.
I want to plot OI of a current strike price in one chart in amibroker.
I have attached an auto refreshing excel sheet of HCL tech.
I am able to get the max volume using MAX formula.
I want to copy the related strike price where max volume falls for CALL & PUT.
Max volume in call put change on every refresh, so cannot use simple copy paste.
Successfully configured RT data(Trade Tiger) to amibroker using Excel, as per previous Threads of Josh1 & sr114... Thanks alot for the help.
I'm new to Amibroker programming... I got data into Excel, but I dont know how to lookup for the data... particular column like Upper Circuit...
I am trying to apply conditional formatting to an excel sheet in excel 2007, but not successful.
1. When column A says BUY to corresponding cell in column D should remain +ve number.
1. When column A says SELL to corresponding cell in column D should...
I am search an excel sheet that can pull up options data from nseindia.com
Please advise if such an excel sheet be formed that can pull such data automatically or at a single click.
I want to include Nifty and all stocks having options.
I managed to get P&L, Balance sheet, Cash flow statement into excel for more than 1000 nse listed stocks (using python script :thumb:)
How useful are financial reports on moneycontrol for fundamental analysis
Is it possible to automate fundamental analysis (at least for screening)
I am a newbie trader in MCX.
Can somebody, please post the links for the best EXCEL Formula file which works for MCX Base Metals?
Also, if you could also upload best working Amibroker formula, that would be useful for all.
Thanks in Advance.
As title, I know how to do it in amibroker by clicking "File -> Export HTML/CSV". However, if I want to perform the action in afl, what should I do?
Here is the code that I output the daily return in explore,
rp = ROC(C);
Can someone help me find NSE FNO data for past 3 months(or more) in excel sheet. All I want is EOD open, high, low, close for the past 3 months or more.
Your help will be greatly appreciated. Thank you.
Hi, Is there any data provider who can provide data that can be extracted to MS Excel instead of extracting the same to some charting software like AmiBroker, MetaStock, etc.
I have coded ADX, EMA, MACD & Stochastics in excel and use the same to generate signals. Hence, I need some reliable &...
I have seen some tools that feed data from Yahoo and Google to Excel. Or tools that have scraped data from NSE/BSE website or other sites.
But pretty much all these tools give data for Equities only. None have Futures and Options data. For F&O, pretty much the only options are expensive...
I have Amibroker 5.4
I tried to play around and configure it myself but I donot understand anything about it :confused:. I would request someone to do the same for me and help me setup the system so that I am able to generate buy-sell signals for stocks in Nifty and Sensex.
Here this thread can be utilized for solving your queries or giving some knowledge about the functioning of EXCEL workouts,
which can be useful for trading and updating the issues in related like screening, calculations, functions, data, download, auto updating etc.
here I am providing...
Just thought of sharing it
It gets data from http://amfiinda.com/spages/NAV0.txt.
Just enter Fund Name, NAV price ,Quantity ,Date( optional ).
It will do the rest.
Please find correct...
Hello all my Trading friends,
I wanted to make a free of cost trading platform for the traderji Users, who doesn't have real time data feed. I saw some threads are there, but there was no solution. I have computer science background. So I decided to make one for myself first. So here in this...