Is it possible to insert Price-lvls from excel to ToS

[tillman]

Hello, i wonder if anybody know if its possible to insert Price levels ( which are in my Excelsheet ) into ThinkOrSwim.
So that ThinkOrSwim does take these price levels from excel and draw these Sup/res-lvls automatically.

When you manually draw sup/res levels with TOS then you are also able to put some text on that sup/res line.

So i need to know if this can get automated, but using pricelevels from excel.

If anybody knows this, please let me know !

 

[rad14733]

@tillman No, linking an Excel Spreadsheet to TOS in realtime for importing is not possible... I have only exported data, not imported...

 

[ajai]

Hello @rad14733 is there an indicator which can draw price levels after inputting the values in the indicator?
ie if I want to put GEX levels which change every week and put the levels in the indicator and it draws these lines for me.

 

[rad14733]

Hello @rad14733 is there an indicator which can draw price levels after inputting the values in the indicator?
ie if I want to put GEX levels which change every week and put the levels in the indicator and it draws these lines for me.

Yes, we can plot any values as price levels on our charts whether extrapolated from within TOS or from manually entered values... Example below...

input gexLevel1 = 123.45;
plot gl1 = gexLevel1;
gl1.SetDefaultColor(Color.CYAN);
gl1.SetLineWeight(2);

# Repeat as needed

You would simply edit the GEX Levels each week as needed...

 

[ajai]

TY @rad14733
One more question.How can we get the highest OI for the closest expiration of calls and put numbers to these levels from within the TOS

 

[rad14733]

TY @rad14733
One more question.How can we get the highest OI for the closest expiration of calls and put numbers to these levels from within the TOS

This must be done manually, by you, because Thinkscript does not offer us the capabilities to easily extrapolate such data... If you have the required data you might be able to use Option Hacker to Scan for Options but it would be difficult to get an exact match... I run Option Hacker continuously to populate a Watchlist of Calls and Puts that fit my personal criteria but have never incorporated GEX values... My Scans are based more on Open Interest, Volume, Delta, and contract price ranges...

 

[ajai]

@rad14733 I really appreciate your prompt response.You have a great day.

 

[AndrewPnF]

Hello, i wonder if anybody know if its possible to insert Price levels ( which are in my Excelsheet ) into ThinkOrSwim.
So that ThinkOrSwim does take these price levels from excel and draw these Sup/res-lvls automatically.

When you manually draw sup/res levels with TOS then you are also able to put some text on that sup/res line.

So i need to know if this can get automated, but using pricelevels from excel.

If anybody knows this, please let me know !

I had a question a while back about creating many lines based on my custom input.
https://usethinkscript.com/threads/addchartbubble.7004/#post-112518

The coding that @SleepyZ created for me worked exactly as expected. So here's the way that I "use excel" to update the information. I just copy the entire code from ToS, into a spreadsheet. I update the number values in that spreadsheet with what I would like and then copy that code from excel back into a ToS indicator.

 

[halcyonguy]

if you have the desired numbers in excel, go to a new sheet and create excel formulas that mimic thinkscript code lines. then copy the cells and paste it into TOS as a new study