• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Only Buy Values has to be published to the next page

T

Techtrend

Member
Hello Team

In the Attached CALLS Page there are BUY in the Y Col ,

Only the Buy Calls has to be published to the next BUY-SELL page
the Full Row has to be Published Date wise ,
i have now done manually.

In the Calls page we will Adding data daily and as and when the buy calls are generated we need to publish in the next page.

Thanks
Naren
 

Attachments

  • Signature.xlsx
    14.4 KB · Views: 4
See attached
I have setup 2 Names
Ticker and Date/Time

Date Time is offset from Ticker so they are always the same length

Date/Time is =OFFSET(Ticker,,1)
So for Open it will be =OFFSET(Ticker,,2)

You can setup the rest

As a comment if you want to keep a blank row between the daily data You must put a space in Column 1 which i have done for you already
Or else the formulas will be wrong
 

Attachments

  • Signature.xlsx
    19.7 KB · Views: 2
I assume this is to do with how Google handles Named Formulas as they are all showing errors

I have never used Google Spreadsheet and have no interest in exploring it

This is an Excel based Blog
 
Last edited:
Hui said:
I assume this is to do with how Google handles Named Formulas as they are all showing errors

I have never used Google Spreadsheet and have no interest in exploring it

This is an Excel based Blog
Click to expand...
ok no probs thanks a lot for the solution in excel.
 
You must log in or register to reply here.
Back
Top