1. E

    Need AFL programmer to write signals from AMIBROKER to CSV

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

    Real Time Data Feed Required

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

    stocks data stream to generate history in excel

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

    Excels for Help, in trading !!!

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

    How to make excel sheet with stock financials

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

    nseindia to Amibroker

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

    Help with Nest

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

    Nifty auto refreshing Excel sheet to Amibroker - Help Needed

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

    Excel Copying

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

    Need help... access data from Excel Sheet

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

    Excel 2007 - Need help with conditional formatting

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

    Excel Sheet - Options

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

    Financial reports in excel for fundamental analysis

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

    Best Excel Formula file for MCX Base Metals

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

    How can I export explore to csv using AFL code?

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

    FNO data in excel

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

    Data Feed (EOD & Intraday) for Excel

    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 &...
  18. E

    Stocks and F&O Data on Excel?

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

    Configuring Amibroker

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

    Solving Developing Functions 4 trading EXCEL sheet.

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