Excel help - getting GANN value of stocks list

Installations & Python Packages
1

Hi,



I have created a spreadsheet, where on one tab i have implemented GANN chart calculations, these calculations work on the PRICE (it could be LTP or CLOSE).

On the another sheet i have list of all the stock i wish to track with fetching OHLC data for these stock.



Now i need to get the GANN value of all the listed stock by passing the LTP to the GANN sheet, bcoz the GANN calculation in complex and that why done separately on new sheet and it generates all sort of values which i want to use with the list of stock.



Can someone please suggest me how to pass the LTP value from sheet1 to sheet2 and get the GANN values for all the stock listed automatically. 



I am trying to avoid any MACRO or VB coding. All the suggestions are welcome.



Thanks

Sachin

2

Hi Sachin,



If you can share your spreadsheet, we can help you better. Please email your spreadsheet to the email below:



quantra@quantinsti.com



Thanks,

Ashish