General market lab and commentary Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : General market lab and commentary

SPY 670.92

+0.1%

Nov 7 4:00 PM EST

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Robohogs who wrote (474)	6/3/2016 2:18:59 PM
From: Robohogs	of 668

I will go in early next week and put in more complex indexing formulas to dynamically shift ranges and match 2nd and 3rd guys with same numbers - need to shift range after matches. This stuff is awesome - need to have logic. And experience with moving quickly helps. But complex logic code can be found online. You need to understand it to make it yours, but memory no longer needed. I have a heavy crunching xbi spreadsheet of ONLY 1 million cells but I was so efficient in minimizing cells that it still overtaxes google which allows 2 million cells. Heavy logic calcs. I wanted to add dynamic MAs but spreadsheet dying anyway. I really need to use google for data sourcing only. Excel thereafter. The pivot and data tables confusing in google - still use excel. Most of this are one ticker data feeds so just export Yahoo. Jon

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next