excel

Need AFL programmer to write signals from AMIBROKER to CSV so that other applications access CSV to send orders to brokers

Hi, This is Aniket. I am new to the forum. I am a Derivatives enthusiast and I like to work around with strategies. I have been trying to find a way to get Real Time Data Feed in excel so that I can set up option chains and strategies for analysis. I have an account with Upstox and have been...

Hi, I have stocks data stream coming to an excel...need to generate history of calculations and incoming data along with timestamp in excel. timestamp stock-price 0900 100 1000 101 1100 102 like this

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...

Hi Members, Please help me plot IV data for call and put in amibroker. I want the data to be pulled up from www.nseindia.com. https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?segmentLink=17&instrument=OPTIDX&symbol=NIFTY&date=28APR2016 Thanks...

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"...

Hi Member, 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. Please guide. Thanks Aman

Hi All, 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. please help...

Hi All, 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...

Hi members, I am trying to apply conditional formatting to an excel sheet in excel 2007, but not successful. please help. 1. When column A says BUY to corresponding cell in column D should remain +ve number. 2. 1. When column A says SELL to corresponding cell in column D should...

Hi All, 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. Screenshot Example: Thanks mates.....

Hi All, 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) Is...

Hi All, 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. Regards, kacraj.

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, Filter=1; NumColumns=1; rp = ROC(C); Column0=rp; Column0Name="Daily Return"...

Hello Friends, 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. Alternatively...

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...