Search found 12 matches

by Woolley89
24 Feb 2021, 22:45
Forum: Ask for Help (v1)
Topic: Spreadsheet to arrays into an array Topic is solved
Replies: 4
Views: 656

Re: Spreadsheet to arrays into an array Topic is solved

I didn't try to address the rest of what your script is doing, but you can use this function to read your CSV file contents into an array that is keyed on the header name and the row number, starting with the row after the header row as 1. So in your example file, MyData.high.4 (or MyData["high"][4...
by Woolley89
24 Feb 2021, 20:25
Forum: Ask for Help (v1)
Topic: Spreadsheet to arrays into an array Topic is solved
Replies: 4
Views: 656

Re: Spreadsheet to arrays into an array Topic is solved

Chunjee wrote:
24 Feb 2021, 20:08
What attachment?

[lib] CSV - AutoHotkey library for working with CSV Files might be useful.
Image

This forum keeps on keeps on breaking the link and won't let me attach the .csv file for some reason
by Woolley89
24 Feb 2021, 18:24
Forum: Ask for Help (v1)
Topic: Cryptocurency web scrapping in Chrome
Replies: 2
Views: 972

Re: Cryptocurency web scrapping in Chrome

Hello, Could someone advice where I could find info how to connect to Chrome with AHK? I tried to web scrapping with IE, but it seems that IE cant handle crypto curreny page features and do not show latest date or other coins. I want to do some analysis and have practice with web scrapping. Thank y...
by Woolley89
24 Feb 2021, 18:23
Forum: Ask for Help (v1)
Topic: Spreadsheet to arrays into an array Topic is solved
Replies: 4
Views: 656

Spreadsheet to arrays into an array Topic is solved

I need some help! I'm trying to have a script create an array with several arrays generated with each having the name of the first cell in each colum in an .csv file. The script would read the first row of the file and create an array for each of the cells in the first row, then would .Push() into t...
by Woolley89
29 Dec 2020, 03:47
Forum: Ask for Help (v1)
Topic: Multi Dementional Array to String Topic is solved
Replies: 3
Views: 257

Multi Dementional Array to String Topic is solved

Multi arrays in Array to string How can I turn an array into a string were there are some elements in the array that have arrays and maybe some arrays in there too? So far I made this, but its limited to only two layers of arrays cutter(array) { Loop, % array.Count() { if !(array[A_Index].Count()) r...
by Woolley89
26 Dec 2020, 04:11
Forum: Ask for Help (v1)
Topic: lowest number in array that's not less than 5 Topic is solved
Replies: 7
Views: 259

lowest number in array that's not less than 5 Topic is solved

How can I get the lowest number in an array thats no less than 5?

Example:

Code: Select all

array := [9,2,6,4,4,7,2,5.9]
Msgbox, % min(array*)          ;would return 5.9
by Woolley89
01 Dec 2020, 16:27
Forum: Ask for Help (v1)
Topic: Help with function Topic is solved
Replies: 2
Views: 274

Help with function Topic is solved

Hey there! Could someone help me turn this spreadsheet into a function returning the last column? Each row is supposed to represent each execution of the order(close, long, qty) Function, but im stuck. So far this is the code I managed to make but I'm only half way to getting the final column shown ...
by Woolley89
30 Nov 2020, 22:48
Forum: Ask for Help (v1)
Topic: Hardware for data crunching and large arrays
Replies: 2
Views: 311

Hardware for data crunching and large arrays

I’m looking to up grade my hardware specifically for running autohotkey scripts. These scripts have to calculate many averages and other functions on every element of every array, but its taking ages to crunch the results. There’s a 3 dimensional cube testing combinations and each of those combinati...
by Woolley89
27 Nov 2020, 03:52
Forum: Ask for Help (v1)
Topic: Shrink code
Replies: 6
Views: 397

Re: Shrink code

Hmm, theres a strange issue with output := [] For i, varname In ["close", "orderSize", "orderValue", "long", "reversal" , "orderSum", "valueOfOrder", "valueOfSum", "avgPrice", "change", "pyramids" , "tradeProfit", "capitalProfit", "cumulativeProfit", "cumulativePercentage"] { last%varname% := %varn...
by Woolley89
26 Nov 2020, 22:22
Forum: Ask for Help (v1)
Topic: Shrink code
Replies: 6
Views: 397

Re: Shrink code

A bit shorter, results should be the same. I notice that output var stores same values as all those last* vars. Maybe there is a way to get rid of them and achieve even cleaner variant. order(close, long, qty, totalCapital) { orderSize := (long == false) ? -qty : qty orderValue := totalCapital / cl...
by Woolley89
26 Nov 2020, 01:56
Forum: Ask for Help (v1)
Topic: Shrink code
Replies: 6
Views: 397

Shrink code

Is there a clean organized way I could shrink this snippet? global lastClose := "na" global lastOrderSize := "na" global lastOrderValue := "na" global lastLong := "na" global lastReversal := "na" global lastOrderSum := "na" global lastValueOfOrder := "na" global lastValueOfSum := "na" global lastAvg...
by Woolley89
17 Nov 2020, 17:45
Forum: Ask for Help (v1)
Topic: Moving Average of a Moving Average Of an Array Topic is solved
Replies: 1
Views: 179

Moving Average of a Moving Average Of an Array Topic is solved

I've been scratching my head on this for a while, and haven't found out how to have a moving average of a moving average of an array Example: array_source := [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15] first_average := moving_average(array_source, 2) last_average := moving_average(first_average, 3) arrayS...

Go to advanced search